Open for Voting

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.