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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.
Learn more today by joining now.