View what stored procedures are currently in the procedure cache 
Author Message
 View what stored procedures are currently in the procedure cache
What is the command to display all the procedure that are currently in the
procedure cache?

--
--Buddy



Sun, 10 Nov 2002 03:00:00 GMT
 View what stored procedures are currently in the procedure cache

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


Quote:
> What is the command to display all the procedure that are currently in the
> procedure cache?

> --
> --Buddy




Sun, 10 Nov 2002 03:00:00 GMT
 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




Mon, 11 Nov 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. temporary tables in stored procedures/parameter views vs stored procedures

2. Stored procedure dependancy on tables, views and other stored procedures

3. Initializing Dictionary Cache and Stored Procedure Cache

4. Cannot drop stored procedure because it is currently in use

5. Calling a Java Stored Procedure from another Java Stored Stored Procedure

6. Please help to convert view on views to stored procedure

7. Please help to convert view on views to stored procedure

8. stored procedure for viewing views...

9. Stored Procedures & Views - where are they stored

10. Stored Procedure - am I missing something

11. I am attempting to execute a stored procedure as the sql query for a data

12. Simple question..I am running a stored procedure from SQL PLUS


 
Powered by phpBB® Forum Software