Question on ProcCache

Hi,
DBCC PROCCACHE is giving me that info. How can i know if
the ProcCache is FULL or closed to be ? Can it become
FULL ?
How does it effect Proc performance or general performance?
num proc buffs num proc buffs used num proc buffs active
proc cache size proc cache used proc cache active
-- -- -- --
-- -- --
16642 16642 10492
11736 11736 5586
Thanks !
Don
Have you looked at the documentation on DBCC PROCCACHE? You can find this
in Books Online or, if you don't have it installed:
http://msdn.microsoft.com/library/en..._dbcc_61d1.asp
http://www.aspfaq.com/
(Reverse address to reply.)
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:295fe01c46524$2f422ab0$a401280a@.phx.gbl...
> Hi,
> DBCC PROCCACHE is giving me that info. How can i know if
> the ProcCache is FULL or closed to be ? Can it become
> FULL ?
> How does it effect Proc performance or general performance?
> num proc buffs num proc buffs used num proc buffs active
> proc cache size proc cache used proc cache active
> -- -- -- --
> -- -- --
> 16642 16642 10492
> 11736 11736 5586
> Thanks !
> Don
>
|||... and also refer to Memory Architecture & Memory pool for more information under BOL.
"Aaron [SQL Server MVP]" wrote:

> Have you looked at the documentation on DBCC PROCCACHE? You can find this
> in Books Online or, if you don't have it installed:
> http://msdn.microsoft.com/library/en..._dbcc_61d1.asp
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Don" <anonymous@.discussions.microsoft.com> wrote in message
> news:295fe01c46524$2f422ab0$a401280a@.phx.gbl...
>
>
|||Performance will typically not be affected as the Lazywriter will be
flushing out aged pages. Pls read Books Online Memory architecture and
Lazywriter for more details.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Question on ProcCache

Hi,
DBCC PROCCACHE is giving me that info. How can i know if
the ProcCache is FULL or closed to be ? Can it become
FULL ?
How does it effect Proc performance or general performance?
num proc buffs num proc buffs used num proc buffs active
proc cache size proc cache used proc cache active
-- -- -- --
-- -- --
16642 16642 10492
11736 11736 5586
Thanks !
DonHave you looked at the documentation on DBCC PROCCACHE? You can find this
in Books Online or, if you don't have it installed:
http://msdn.microsoft.com/library/e...s_dbcc_61d1.asp
http://www.aspfaq.com/
(Reverse address to reply.)
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:295fe01c46524$2f422ab0$a401280a@.phx
.gbl...
> Hi,
> DBCC PROCCACHE is giving me that info. How can i know if
> the ProcCache is FULL or closed to be ? Can it become
> FULL ?
> How does it effect Proc performance or general performance?
> num proc buffs num proc buffs used num proc buffs active
> proc cache size proc cache used proc cache active
> -- -- -- --
> -- -- --
> 16642 16642 10492
> 11736 11736 5586
> Thanks !
> Don
>|||... and also refer to Memory Architecture & Memory pool for more informatio
n under BOL.
"Aaron [SQL Server MVP]" wrote:

> Have you looked at the documentation on DBCC PROCCACHE? You can find this
> in Books Online or, if you don't have it installed:
> http://msdn.microsoft.com/library/e...s_dbcc_61d1.asp
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Don" <anonymous@.discussions.microsoft.com> wrote in message
> news:295fe01c46524$2f422ab0$a401280a@.phx
.gbl...
>
>|||Performance will typically not be affected as the Lazywriter will be
flushing out aged pages. Pls read Books Online Memory architecture and
Lazywriter for more details.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.