September 24, 2012 at 7:37 am
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
September 24, 2012 at 7:42 am
Check the windows logs, check the SQL server logs, they should contain the information about who/what/where/why/when restarted the SQL service.
September 24, 2012 at 7:55 am
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.
September 24, 2012 at 8:26 am
whats in the SQL logs around the same times?
September 26, 2012 at 8:13 am
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.
September 26, 2012 at 9:55 am
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
September 26, 2012 at 11:00 am
how do we check if it is enabled or not?
September 26, 2012 at 11:57 am
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
September 26, 2012 at 3:36 pm
You should also look at the cluster events in the cluster manager.
September 27, 2012 at 1:19 am
no, automatic update is turnedoff..
September 27, 2012 at 1:19 am
in cluster log nothng found same error as follows:
Cluster resource 'SQL Server' in Resource Group 'SQLVS01' failed.
September 27, 2012 at 1:43 am
can you dump out the sql, windows and cluster logs into a zip file and attach to the post, might be worth a second (or many) pair of eyes looking over them.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply