Tempdb % Full

• jsqldba

  SSChampion

  Points: 11256

  More actions

  September 18, 2001 at 8:02 am

  #57600

  I have tempdb defined to an exclusive drive at 4GB, and currently there is only a couple hundred MBs left. I would like monitor what % of tempdb is being used, and see how close we are to exceeding our drive capacity. There is a perfmon counter to monitor % log full but not for the db. The % used is given on the database/space allocated page of EM. How can I capture this info and regularly monitor? I presume there is a query behind the page on the system tables but don't know the specifics.

  Thanks

  Jay

• Steven.

  SSCrazy Eights

  Points: 9806

  More actions

  September 18, 2001 at 11:16 am

  #418298

  It may be worth you stopping and starting SQL server, as this recreates your tempdb database from scratch. Hence giving you a clean starting place.

  Steven

• Andy Warren

  SSC Guru

  Points: 119694

  More actions

  September 18, 2001 at 3:45 pm

  #418309

  Sp_spaceused would be a starting place. You could profile EM to see how its getting the info maybe, probably using DMO.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter