
View what stored procedures are currently in the procedure cache
DBCC MEMUSAGE doesn't show ALL of the procs in the cache. I once used a
command, which I think was an undocumented DBCC command, that showed all
procs in the cache. It's been a along time since I used it and can't
remember what it is.
--Buddy
Quote:
> What version?
> In 6.5, you can use DBCC MEMUSAGE.
> In 7.0, there is no command. There is a pseudo system table called
> syscacheobjects in the master database you can look at. It contains more
> than just procs, it contains all compiled plans. Inside SQL Server 7.0 has
a
> script to create a proc to read syscacheobjects and report on the
procedures
> therein. You can also get it from my web site, in the Cool News section,
> with the slides and scripts from my user group presentation called
"Secrets
> of the System Tables"
> HTH
> --
> Kalen Delaney
> MCSE, SQL Server MCT, MVP
> www.InsideSQLServer.com
> Feed Someone for Free Today:
> www.TheHungerSite.com
> > What is the command to display all the procedure that are currently in
the
> > procedure cache?
> > --
> > --Buddy