The most recent content from our members.
Whenever tempdb is the topic of discussion, it seems that colorful terms such as “parasites” and “public toilet” abound. As SQL Server’s common workspace for everything from triggers to cursors to sort spills, tempdb has a well-earned association with unique and sometimes mysterious SQL Server performance problems. The new…
What are DPA's capabilities for monitoring and troubleshooting when [tempdb] runs out of space? Can DPA... * Identify SPIDs/transactions consuming the most space in [tempdb]? * Identify related SQL statements of SPIDs/transactions? * Identify [tempdb] file space usage (size, allocated size, unallocated size, version store…
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…
My Tempdb is filling up fast How can I use DPA to identify the spid using most tempdb space?
Description This custom metric will collec the current free space for TempDB as a percentage. Metric Definition To create the custom metric, click on Options > Custom Resource Metrics and configure the metric similar to this: Database Versions: <no limitations> Display Name: TempDB Free Space (%) Description: <add your own…
I opened a support case as well but wanted to bounce this off other users on here. I recently applied the 12.0.1 update for NPM and since then I have been seeing the tempdb file for the SolarWinds database bloat and eat up all the free space on the disk it resides on. I can restart the server or bounce the SQL server…
Description Checks for tempdb contention. Had an issue recently caused by this, other metrics didn't highlight much of a problem other than high pagelatch waits. Resolved by adding more data files to tempdb in my case (other options are available though)! see The Accidental DBA (Day 27 of 30): Troubleshooting: Tempdb…
Description This custom metric will collect the current used space for TempDB in MB. Metric Definition To create the custom metric, click on Options > Custom Resource Metrics and configure the metric similar to this: Database Versions: <no limitations> Display Name: TempDB Size (MB) Description: <add your own description>…
It looks like you're new here. Sign in or register to get started.