Tempdb Space usage report shows incorrect data when large result sets are returned #310
Description
Report seems to show incorrect results:
The T-SQL query returns different results (correct)
Possibly happening due to a very large result set from
SELECT ssu.runtime,
ssu.session_id,
tsu.exec_context_id,
tsu.cpu_time,
CONVERT(DECIMAL(10, 3), ssu.internal_objects_alloc_page_count / 128.0) AS internal_objects_alloc_MB,
CONVERT(DECIMAL(10, 3), ssu.internal_objects_dealloc_page_count / 128.0) AS internal_objects_dealloc_MB,
CONVERT(DECIMAL(10, 3), ssu.user_objects_alloc_page_count / 128.0) AS user_objects_alloc_MB,
CONVERT(DECIMAL(10, 3), ssu.user_objects_dealloc_page_count / 128.0) AS user_objects_dealloc_MB,
CONVERT(DECIMAL(10, 3), ssu.user_objects_deferred_dealloc_page_count / 128.0) AS user_objects_deferred_dealloc_MB,
ssu.open_transaction_count,
ssu.program_name,
ssu.most_recent_query,
tsu.batch_text,
tsu.statement_text,
tsu.wait_type,
tsu.wait_time
FROM dbo.tbl_dm_db_session_space_usage AS ssu
LEFT OUTER JOIN dbo.tbl_dm_db_task_space_usage AS tsu
ON ssu.session_id = tsu.session_id
WHERE (ssu.internal_objects_alloc_page_count >= 1280)
OR (ssu.user_objects_alloc_page_count >= 1280)