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.
STATUS: 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
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy