SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server stops responding


SQL Server stops responding

Author
Message
dwilliscp
dwilliscp
SSC Eights!
SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)

Group: General Forum Members
Points: 812 Visits: 775
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
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1558 Visits: 8586
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 Eights!
SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)

Group: General Forum Members
Points: 812 Visits: 775
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
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1558 Visits: 8586
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 (393 reputation)Old Hand (393 reputation)Old Hand (393 reputation)Old Hand (393 reputation)Old Hand (393 reputation)Old Hand (393 reputation)Old Hand (393 reputation)Old Hand (393 reputation)

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

Cheers

Vultar
dwilliscp
dwilliscp
SSC Eights!
SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)

Group: General Forum Members
Points: 812 Visits: 775
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
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1558 Visits: 8586
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
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2105 Visits: 872
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 Eights!
SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)SSC Eights! (812 reputation)

Group: General Forum Members
Points: 812 Visits: 775
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