Undocumented DBCC command for cache usage

Question

Undocumented DBCC command for cache usage

virgilrucsandescu

SSCrazy

Points: 2457
More actions
March 13, 2008 at 2:13 pm

#71282

A while ago I found an undocumented DBCC command for sql2k, having a parameter "n" and showing up the first "n" objects in the cache (but in clear, not like DBCC MEMUSAGE), but I really can't remember it. Can anybody help me please?

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

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

virgilrucsandescu SSCrazy Points: 2457 More actions · Answer 1

Please ... Maybe it was a stored procedure, I am not exactly sure ... but it has a parameter (whatever - DBCC or stored procedure) that means

something like "show me the first "n" objects" in the cache. And I am 100% sure it is working in Sql Server 2000

Sergiy SSC Guru Points: 110208 More actions · Answer 2

You're probably looking for the data in table master.dbo.syscacheobjects

_____________
Code for TallyGenerator

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

Dunno if it's any of these... see attached... might be DBCC Buffer or DBCC ProcBuf.

--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)

virgilrucsandescu SSCrazy Points: 2457 More actions · Answer 4

After a pretty long search I have just found what I was looking for ...

It is :

DBCC MEMUSAGE (names,100) for ex shows up the first 100 objects in the cache with their name in clear 🙂

Quite helpful for me ...

Thank you!

Virgil Rucsandescu

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

Thanks for posting the solution, Virgil...

--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)