July 24, 2013 at 12:52 pm
From time to time... 2min - 15min the SQL server will stop responding... In Management studio this means that all of a sudden the login box comes up and it times out.
There is nothing in the SQL log or the windows server logs... the 24 CPU's range less than 15% and the data hard drives between 30% - 55%.
What is going on??? Where should I look?
Thanks.
July 24, 2013 at 1:04 pm
You might want to check the NIC on the SQL Server and any errors reported by the network gear.
July 24, 2013 at 1:41 pm
THe Broadcom Advanced Control Suite does not seem to have a log.
It does have some running counts... by frame...
660571618 sent ok
178420228 Rec ok
5 Out of Buffer
59392752 Large Send Offload Trans Req
0 Rec with CRC Error
0 Rec with Align Error
0 Trans with Collision
July 24, 2013 at 2:01 pm
I'm not a network expert, but that doesn't show any of the problems I might have been looking for, though you might want to look at this also:
http://technet.microsoft.com/en-us/library/gg162709(v=WS.10).aspx
Does the server appear to stop for everyone or just for your connection?
July 25, 2013 at 4:59 pm
Are you connecting to the SQL server via ssms on your desktop, or rdp ?
Cheers
Vultar
July 26, 2013 at 1:03 pm
This effects all the SQL server jobs connecting to this server, and all users connected. So for users we have both Management Studio, and .Net Apps.
July 26, 2013 at 1:28 pm
Can you log on to the actual server the SQL Server is running on during these outages? Is it behaving normally or is it also frozen?
July 26, 2013 at 4:23 pm
dwilliscp (7/26/2013)
This effects all the SQL server jobs connecting to this server, and all users connected. So for users we have both Management Studio, and .Net Apps.
A key here is: when this happens, can you connect locally? That is, if you have SSMS running on the server, can you connect to SQL Server from this local instance of SSMS?
If you can, and everything else is locked out, it seems like a network issue. If you cannot, it is more likely to be a problem inside SQL Server.
Have you checked the SQL Server errorlog for messages related to these incidents?
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 29, 2013 at 7:46 am
I didn't try to log in from the server.. but the SQL server log did not have anything at all in it.. for the time in question. The same is true for the server log.
We have not had this problem come back yet... I say yet because I still have not found the problem. My guess is the SQL server... but either all blocking had cleared, but the time it let me back on.. or that was not the cause.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply