how is the cache broken up in SQL 2000?

I want to know how much of my buffer pool is being used for data and how
much is consumed for procedure cache?
Is there a way I can find out?Hi Hassan
"Hassan" wrote:
> I want to know how much of my buffer pool is being used for data and how
> much is consumed for procedure cache?
> Is there a way I can find out?
Have you seen http://support.microsoft.com/kb/271624 ?
John|||Hassan,
please take a look at DBCC MEMORYSTATUS :
http://support.microsoft.com/Default.aspx?id=271624. DBCC CACHESTATS, and
SYSCACHEOBJECTS might also be of interest (see
http://www.quest-pipelines.com/newsletter-v4/0303_B.htm).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||In addition, you can also use the perfmon counters in SQLServer:Buffer
Manager to get the info.
Linchi
"Hassan" wrote:
> I want to know how much of my buffer pool is being used for data and how
> much is consumed for procedure cache?
> Is there a way I can find out?
>
>