Return
-
Title
Spotlight spawning multiple traces on SQL Server -
Description
SQL Server Logs in Management Studio are picking up multiple traces from Spotlight.
For example...12/15/YYYY 06:05:53,spid57,Unknown,SQL Trace ID 8 was started by login "domain\spotlight_user".12/15/YYYY 06:05:50,spid54,Unknown,SQL Trace ID 7 was started by login "domain\spotlight_user".12/13/YYYY 04:22:32,spid59,Unknown,SQL Trace ID 6 was started by login "domain\spotlight_user".12/13/YYYY 04:21:36,spid70,Unknown,SQL Trace ID 5 was started by login "domain\spotlight_user".12/12/YYYY 15:01:26,spid63,Unknown,SQL Trace ID 2 was started by login "domain\spotlight_user".Why is Spotlight spawning multiple traces on SQL Server? -
Cause
There is a defect in how Spotlight handles errors that are returned from the trace occasionally. The trace returning the error causes the code to abandon that trace and start a new one without stopping the original trace. -
Resolution
WORKAROUND:
None
STATUS:
Issue fixed in version 11.5. The latest version of Spotlight on SQL Server Enterprise can be downloaded at https://support.quest.com/spotlight-on-sql-server-enterprise/download-new-releases
-
Defect ID
SOSSE-4455 -
Additional Information
Issue may occurred in following SQL Server version: 2008 R2, 2005, 2012.