Re: procedure cache flush?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 12:51:32 -0500

Lazy Writer marks objects in proc cache for removal if they have not been
referenced in a while. 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"arthur" <alangham@gmail.com> wrote in message
news:1106576154.599621.204540@z14g2000cwz.googlegroups.com...
> on friday i checked the size of the procedure cache (using dbcc
> proccache) and it was at 1G. now it's at 340Mb. is there some process
> that clears the cache periodically, or did i just do my math wrong? on
> a related note, has anyone seen the performance monitor buffer
> manager:procedure cache counter give incorrect results?)
>
> also, what objects, other than stored procedures, are in the procedure
> cache?
>
> if anyone has any more recommendations on articles or books on the
> topic of sql server memory management and configuration it would be
> greatly appreciated.
>
> sorry for the question spam.
>
> thanks,
>
> arthur
>

Relevant Pages

  • Re: FTS query performance on SQL 2005
    ... rather the full-text catalog pages which are cached in the file system cache ... Looking for a SQL Server replication book? ... now all of my queries return in under 1/2 second. ... the memory usage was steadily increasing. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: How to clear memory usage after executing queries ?
    ... Uh, Tom, if the pages that have been the cache the longest are constantly ... SQL Server will push pages out of memory only if it has to read new ... > pages into memory. ...
    (microsoft.public.sqlserver.programming)
  • Re: HIT and MISS
    ... clear both data cache and buffer cache but still does ... Create a stored procedure demo_sp as dbo, and grant exec rights to some ... This is because SQL Server first looks up if the user owns a procedure ...
    (comp.databases.ms-sqlserver)
  • Re: persistent cache in SQL Server
    ... If so, as Gregory said, it's not a cache. ... You can call WCF method and store the retrieved data into Session. ... Then store the retrieved data into database and use Sql Server Agent ... In fact, however, it can be good to have a copy either in memory and sql server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL server login does not appear
    ... Clearing the cache is one of the many benefits of this strategy. ... > prompts for a password? ... >>Access does cache the credentials on linked tables. ... >>> the SQL server logon window does not show up. ...
    (microsoft.public.access.externaldata)