One of the SQL Servers instances which is being monitored by Spotlight stopped responding and user had to restart SQL services to get it up and running. When examining the SQL logs user found the following:
"2011-07-28 08:49:31.09 spid73 ***Stack Dump being sent to C:\MSSQL2005\MSSQL.1\MSSQL\LOG\SQLDump0017.txt
2011-07-28 08:49:31.09 spid73 SqlDumpExceptionHandler: Process 73 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2011-07-28 08:49:31.09 spid73 * *******************************************************************************
2011-07-28 08:49:31.09 spid73 *
2011-07-28 08:49:31.09 spid73 * BEGIN STACK DUMP:
2011-07-28 08:49:31.09 spid73 * 07/28/11 08:49:31 spid 73
2011-07-28 08:49:31.09 spid73 *
2011-07-28 08:49:31.09 spid73 *
2011-07-28 08:49:31.09 spid73 * Exception Address = 0000000077EFC8CB Module(ntdll+000000000003C8CB)
2011-07-28 08:49:31.09 spid73 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2011-07-28 08:49:31.09 spid73 * Access Violation occurred reading address 000000004B28F268
2011-07-28 08:49:31.09 spid73 * Input Buffer 510 bytes -
2011-07-28 08:49:31.09 spid73 * -- SoSSE - 8.0.1.4943 -- File -"
Restarted SQL Server services.
The Access Violation error is caused SQL Server service itself.
