http://www.sqlservercentral.com/blogs/robert_davis/2013/05/21/bug-sysdm_db_session_space_usage-reporting-extremely-high-tempdb-allocations/

Printed 2014/11/28 11:16AM

Bug: sys.dm_db_session_space_usage Reporting Extremely High Tempdb Allocations

By Robert Davis, 2013/05/21

A little more than a year ago while working at Idera, I was consulted on reports from a few clients using the Idera monitoring tool SQL diagnostic manager (SQLdm). SQLdm was reporting very high numbers for internal object allocations (internal_objects_alloc_page_count) and very low numbers for internal object deallocations (internal_objects_dealloc_page_count) to the point that SQLdm showed Read More →
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.