I'm having problems with one of my SQL Server 2016 Standard servers. I have 8 production servers and this one is the only one who crashes randomly without having any trace in the log.
I have system_health enabled on it. I noticed that I have a row in system health witch is "sql_exit_invoked".
I'm trying to find more informations on that row. What does it means? The only info I found over the internet is that it happens when SQLExit() is called and that it's logged only since SQL 2012. (link available on msdn website )
So my question is : Should I worry to see this in my log? I find this only on my problematic server and not on any of the other 7 servers. (All of them are SQL Server 2016 Standard edition)
Can anybody give me more information on this?
FAST_SHUTDOWN
,NICE_SHUTDOWN
,ORDERLY_SHUTDOWN
,SHUTDOWN_NOT_SET
according toSELECT * FROM sys.dm_xe_map_values WHERE name = 'sql_shutdown_option';
– Dan Guzman Dec 13 '18 at 15:12