Return
-
Title
Long Running SQL Alarm filter does not ignore certain text in a SQL query -
Description
The Long Running SQL Alarm alarm allows the user to specify to not alarm for certain values, however the value in this case is the SPID of the process. Ideally it would be useful if the user could ignore the alarm based on certain text in a SQL query string.
-
Cause
The alarm ignore list works on the key column, in the case of Long Running SQL, this is the spid.
This means the user can ignore this alarm for a specific spid but the user cannot ignore alarms for sql's that contain specific text. -
Resolution
WORKAROUND:
None
STATUS
Enhancement request has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise. -
Defect ID
SOSSE-2662