The status and login user in Long Running SQL alarm are different from sessions drill down
说明
After receiving a Long Running SQL alarm email from Spotlight, it indicated the status was suspended and Login Name was blank while in the sessions drill down the corresponding session status was running and the SQL user column is not blank.
解决办法
WORKAROUND:
None.
STATUS:
A fix is available in the latest version of Spotlight on SQL Server Enterprise which can be downloaded here.