Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server stops responding


SQL Server stops responding

Author
Message
dwilliscp
dwilliscp
SSC-Addicted
SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)

Group: General Forum Members
Points: 418 Visits: 767
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.
David Webb-CDS
David Webb-CDS
SSC Eights!
SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)

Group: General Forum Members
Points: 916 Visits: 8584
You might want to check the NIC on the SQL Server and any errors reported by the network gear.



And then again, I might be wrong ...
David Webb
dwilliscp
dwilliscp
SSC-Addicted
SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)

Group: General Forum Members
Points: 418 Visits: 767
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
David Webb-CDS
David Webb-CDS
SSC Eights!
SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)

Group: General Forum Members
Points: 916 Visits: 8584
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?



And then again, I might be wrong ...
David Webb
vultar
vultar
Old Hand
Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)

Group: General Forum Members
Points: 306 Visits: 1213
Are you connecting to the SQL server via ssms on your desktop, or rdp ?

Cheers

Vultar
dwilliscp
dwilliscp
SSC-Addicted
SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)

Group: General Forum Members
Points: 418 Visits: 767
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.
David Webb-CDS
David Webb-CDS
SSC Eights!
SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)SSC Eights! (916 reputation)

Group: General Forum Members
Points: 916 Visits: 8584
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?



And then again, I might be wrong ...
David Webb
Erland Sommarskog
Erland Sommarskog
SSC Eights!
SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)

Group: General Forum Members
Points: 931 Visits: 866
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?

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
dwilliscp
dwilliscp
SSC-Addicted
SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)

Group: General Forum Members
Points: 418 Visits: 767
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search