Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

sql service restarted unexpectedly Expand / Collapse
Author
Message
Posted Monday, September 24, 2012 7:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 25, 2014 7:11 PM
Points: 208, Visits: 1,026
hello experts,
in my production server sql service restarted unexpectedly, the concern teams are asking for root cause analysis doc for that, what is the best way to troubleshoot why get restarted and who restarted it.

please help
Post #1363485
Posted Monday, September 24, 2012 7:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 8:53 AM
Points: 5,218, Visits: 5,072
Check the windows logs, check the SQL server logs, they should contain the information about who/what/where/why/when restarted the SQL service.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1363488
Posted Monday, September 24, 2012 7:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 25, 2014 7:11 PM
Points: 208, Visits: 1,026
i found following msgs in windows log
Cluster resource 'SQL Server' in Resource Group 'SQLVS01' failed.

Timeout (30000 milliseconds) waiting for a transaction response from the DWMRCS service.

Timeout (30000 milliseconds) waiting for a transaction response from the Netman service.


The SQL Server Agent (MSSQLSERVER) service was successfully sent a stop control.


The SQL Server Agent (MSSQLSERVER) service terminated unexpectedly. It has done this 4 time(s).


The SQL Server (MSSQLSERVER) service was successfully sent a stop control.

The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 2 time(s).

The SQL Server (MSSQLSERVER) service was successfully sent a start control.
Post #1363493
Posted Monday, September 24, 2012 8:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 8:53 AM
Points: 5,218, Visits: 5,072
whats in the SQL logs around the same times?



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1363521
Posted Wednesday, September 26, 2012 8:13 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:16 AM
Points: 1,270, Visits: 2,784
That isn't good.

Look at the SQL Server log as the previous poster stated

Also look at the Windows Application and system log. There has to be more detail there.



Post #1364718
Posted Wednesday, September 26, 2012 9:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 25, 2014 7:34 AM
Points: 1,322, Visits: 1,730
Ensure that you have no automatic updates scheduled on your servers.

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Post #1364807
Posted Wednesday, September 26, 2012 11:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 25, 2014 7:11 PM
Points: 208, Visits: 1,026
how do we check if it is enabled or not?
Post #1364844
Posted Wednesday, September 26, 2012 11:57 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 25, 2014 7:34 AM
Points: 1,322, Visits: 1,730
Zeal-DBA (9/26/2012)
how do we check if it is enabled or not?


go to control panel--> windows updates-->check if you have enabled it


“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Post #1364861
Posted Wednesday, September 26, 2012 3:36 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:55 PM
Points: 256, Visits: 1,445
You should also look at the cluster events in the cluster manager.
Post #1364954
Posted Thursday, September 27, 2012 1:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 25, 2014 7:11 PM
Points: 208, Visits: 1,026
no, automatic update is turnedoff..
Post #1365060
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse