Home Dashboard Directory Help
Search

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


Status: 

Active


15
0
Sign in
to vote
Type: Suggestion
ID: 786132
Opened: 5/2/2013 10:14:04 AM
Access Restriction: Public
0
Workaround(s)
view

Description



Hi,

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.
Details
Sign in to post a comment.
Posted by Microsoft on 6/25/2013 at 2:54 PM
Hello,
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.