The database is on the same server as Bigfix.
I am on version SQL Server 2008 SP3 build 10.00.5890 (which includes MS15-058 QFE Patch)
Microsoft SQL Server Management Studio 10.0.5890.0
Microsoft Analysis Services Client Tools 10.0.5890.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.5485
Operating System 6.1.7601
I do not have any scheduled SQL jobs running at the times of the timeout. I am not using any domain ids for any of the BES services, just Local System.
Thanks for the article, I saw that too, but it applied to SQL 2012.
There are no SQL server errors in any of the error logs only in the BESRelay.log so my DBA is stumped.
I was thinking about going to SQL SP4, but this issue just started about a month ago, I and didn’t know if it would do any good. Everything is running very smoothly and very quickly.
My server wait times are great:
C:>netstat -aon | find /i “52311” | find “TIME_WAIT” /i /c
10
I can send an empty action to all 20,000+ clients and get a completed response from all clients in my console in 8 minutes!
Applying the SQL server pack may do more harm than good, and the issue hasn’t been around for long so I am just trying to figure out what is causing it.
My BES version is 9.2.7.53 and Windows Server 2008 R2 SP1
Thanks for all the replies,
Scott