Return
-
Title
CPU Usage alarm generated email from Spotlight to show the SQL Query that raised the alarm. -
Description
User receives an High CPU Usage alarm email which only shows the CPU % at the time. They would like to see what SQL Query was causing the high CPU usage with the email that gets sent. -
Cause
Capabilities of the Alarm Action Email for High CPU Usage are limited the server name and the process currently running at the time the alarm was raised. It is not possible to include the SQL Query that caused the high CPU Usage. -
Resolution
WORKAROUND:
None
STATUS:Enhancement request SOSSE-I-58 has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise.
-
Defect ID
SOSSE-I-59