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: Tuesday, December 16, 2014 10:09 PM
Points: 208, Visits: 1,040
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: Monday, December 8, 2014 1:45 AM
Points: 5,221, Visits: 5,120
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: Tuesday, December 16, 2014 10:09 PM
Points: 208, Visits: 1,040
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: Monday, December 8, 2014 1:45 AM
Points: 5,221, Visits: 5,120
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: Today @ 11:58 AM
Points: 1,326, Visits: 2,950
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, November 17, 2014 12:23 PM
Points: 1,368, Visits: 1,761
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: Tuesday, December 16, 2014 10:09 PM
Points: 208, Visits: 1,040
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, November 17, 2014 12:23 PM
Points: 1,368, Visits: 1,761
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: Wednesday, December 17, 2014 11:15 AM
Points: 257, Visits: 1,594
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: Tuesday, December 16, 2014 10:09 PM
Points: 208, Visits: 1,040
no, automatic update is turnedoff..
Post #1365060
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse