Home Dashboard Directory Help

Improve the log message when a restart service was caused. by Marcos Freccia



Sign in
to vote
Type: Suggestion
ID: 786132
Opened: 5/2/2013 10:14:04 AM
Access Restriction: Public



In my day to day working as a DBA, I would like to see a better message when the SQL Server Service was restarted or just crashed. Today the message logged on errorlog doesn't show the user who was logged on Windows or if the restart was executed inside SSMS (Not sure if this can be tracked).

The standard message "SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required." doesn't help me to understand who or what caused the problem and doesn't meet the expectations.

In environments with lots of servers and a big DBA Teams this improvement will help.

That's would be applied for SQL Server 2012 and newer versions.
Sign in to post a comment.
Posted by Microsoft on 6/25/2013 at 2:54 PM
Thank you for submitting this feedback. After carefully evaluating this suggestion, we are closing this item as this is needs to be tracked by Windows. SQL Server does not have visibility into service shutdown through Service Control Manager. However, we will re-evaluate the closed suggestions again in the future based on the product roadmap.
Thanks again for providing the product suggestion and continued support for our product.

Ajay Jagannathan
Senior Program Manager
Sign in to post a workaround.