VA TempDB Workspace Auditor
HEALTHY: < 50% Used
WARNING: 50-80% Used
CRITICAL: > 80% Used
Surgical Action Plan: Restore Server Stability
- If Internal Objects (Purple) are high: A query is performing a massive sort or hash join too large for RAM (TempDB Spill). Action: Check Query Performance for high logical reads.
- If User Objects (Blue) are high: An application created a massive #temp table or variable. Action: Contact the Login identified below to close their session.
- If Version Store (Orange) are high: A long-running transaction is preventing SQL cleanup. Action: Check Blocking Chains for the oldest open transaction.
Allocated Size
0.56 GB
Used Space
95.7 %
Version Store
0.0 MB
Top Consumer
SPID 59 (390.62 MB)
Unified Distribution Logic
Top 5 Space Hogs (Who is responsible?)
| SPID | Login | WorkDB | User MB | Internal | Total Impact |
|---|---|---|---|---|---|
| SPID 59 | DESKTOP-LQEABPI\penny | AWL | 390.62 MB | 0.00 MB | 390.62 MB |
| SPID 64 | DESKTOP-LQEABPI\penny | AWL | 156.25 MB | 0.00 MB | 156.25 MB |
| SPID 58 | DESKTOP-LQEABPI\penny | AWL | 0.00 MB | 0.00 MB | 0.00 MB |
Reference: Raw Truth Verification Query
SELECT s.session_id, s.login_name, (ts.user_objects_alloc_page_count - ts.user_objects_dealloc_page_count) * 8 / 1024.0 as [UserMB], (ts.internal_objects_alloc_page_count - ts.internal_objects_dealloc_page_count) * 8 / 1024.0 as [InternalMB] FROM tempdb.sys.dm_db_session_space_usage ts JOIN sys.dm_exec_sessions s ON s.session_id = ts.session_id WHERE (ts.user_objects_alloc_page_count + ts.internal_objects_alloc_page_count) > 0 ORDER BY [UserMB] DESC;