tempdb Monitoring

score 38
Voted on 38 times. You have not voted. Open for Voting

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.

Comments

Vote history

SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website, you consent to our use of cookies. For more information on cookies, see our cookie policy.