Return
-
Title
Spotlight using too much tempdb -
Description
Workload Analysis shows that Spotlight is using over 2 GB of tempdb space to run QS_ConnectionDetails.sql . -
Cause
The drill-down that shows TempDB space usage by session may display wrong data due to this Microsoft defect:http://sqlity.net/en/671/deferred-deallocations-of-pages-in-tempdb/
This problem is fixed in SQL Server 2012 Service Pack 2 and 2014 Service Pack 1 by the addition on a new column user_objects_deferred_dealloc_page_count to the DMV sys.dm_db_session_space_usage; however, the Spotlight query has yet to reflect this change.
-
Resolution
WORKAROUND: NoneSTATUS: Issue fixed in version 12.0. 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
DS-527