Tempdb % Full

  • jsqldba

    SSChampion

    Points: 11256

    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

    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

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

    Andy

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply