Post reply

TempDB Taskpad View

  • March 6, 2008 at 2:59 pm

    #93222

    Hi,

    I have 'dbo' access on the development server. I'm trying to view TempDB data & log usage, using EM -- View -Taskpad. I do see the 'Transaction Log space' in Taskpad. But not the 'Data'.

    Can any one tell me what are the DB access needed to view this detail. FYI, I could see these (Data & Log usage) details in all user databases.

    Thank You,

  • March 6, 2008 at 4:08 pm

    #786398

    It's a bug... turn off task pad by selecting a different kind of view... then, turn it back on. Problem should fix itself. If it doesn't you may have to stop/restart the SQL Server service and try again.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • March 6, 2008 at 4:17 pm

    #786406

    Jeff,

    Thank you for your reply. The Taskpad refresh works for other user databases. But not in TempDB.

    Even in TempDB, I could see the Transaction Log usage. The issue is the data usage I do not see.

    Thanks,

  • March 6, 2008 at 6:19 pm

    #786446

    Sure am sorry about that... Task Pad has always been a little quirky in 2k.

    If you really want to know those values, try the following

    USE TEMPDB

    EXEC dbo.sp_HelpFile

    EXEC dbo.sp_SpaceUsed

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • March 7, 2008 at 10:44 am

    #786813

    Thank You again Jeff.

    I tried to monitor the temp db size using sp_spaceused. The 'Unallocated Space' value is static when the query is running. It is supposed to change when the TempDB gets full.

    Any help is appreciated.

    Thank You,

  • March 7, 2008 at 11:42 am

    #786845

    You may have to do a DBCC UPDATEUSAGE on TempDB just before the sp_SpaceUsed to get that to change...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 6 posts - 1 through 5 (of 5 total)

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