TempDB Taskpad View

Question

TempDB Taskpad View

shivsen-572151

Valued Member

Points: 61
More actions
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,

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

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

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

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)

shivsen-572151 Valued Member Points: 61 More actions · Answer 2

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,

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 3

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)

shivsen-572151 Valued Member Points: 61 More actions · Answer 4

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,

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 5

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)