Return
-
Title
Spotlight causes high SOS waits. -
Description
Monitoring of database by Spotlight Diagnostic Server causes a lot of SOS_SCHEDULER_WAIT waits. -
Resolution
WORKAROUND:
none
SOLUTION:
The change of reporting of these waits was part of bigger algorithm changed in version 11.6.1. This latest version of Spotlight on SQL Server Enterprise can be downloaded here: https://support.quest.com/spotlight-on-sql-server-enterprise/download-new-releases
-
Additional Information
Run the following query to check if the issue is really caused by Spotlight: SELECT [er].[session_id], [es].[program_name], [est].text, [er].[database_id], [eqp].[query_plan], [er].[cpu_time] FROM sys.dm_exec_requests [er] INNER JOIN sys.dm_exec_sessions [es] ON [es].[session_id] = [er].[session_id] OUTER APPLY sys.dm_exec_sql_text ([er].[sql_handle]) [est] OUTER APPLY sys.dm_exec_query_plan ([er].[plan_handle]) [eqp] WHERE [es].[is_user_process] = 1 AND [er].[last_Wait_type] = N'SOS_SCHEDULER_YIELD' ORDER BY [er].[session_id]