cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

tempdb Monitoring

tempdb Monitoring

Perform periodic queries against the DMO objects that contain tempdb usage information (i.e., sys.dm_db_task_space_usage, sys.dm_db_session_space_usage). Persist this information to the Ignite repository. This information is useful so that we can find which session is consuming a lot of the tempdb resources and possibly filling up the tempdb data/log segments.

Tags (1)
1 Comment
Level 8

I added a custom metrics to accomplish this. See my post here:TempDB