Identify SPID with highest tempdb Usage

• sgambale

  SSCommitted

  Points: 1709

  More actions

  June 22, 2011 at 8:49 am

  #253237

  I have a job that looks at tempdb space usage and sends me an email when the tempdb data file size has exceeded a threshold.

  I have had some users running big queries and filling up tempdb in the past.

  What I want to do in this situation is identify what spid is currently running that is using the most space in tempdb as I may have to kill it or inform user right away.

  Steve

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 22, 2011 at 8:53 am

  #1342459

  This one should do:

  http://www.sqlservercentral.com/scripts/tempdb/72007/

  Hope this helps

  Gianluca

  -- Gianluca Sartori