As a SQL Database Administrator, developer, designer you must be eager to know how long does a stored procedure execution plan stay in the cache? On what basis and parameters Microsoft SQL Server decide age of an execution plan to reside in cache? The quick answer is, it is based on the cost factor [...]
Posts Tagged ‘lazywriter’
How long does a SP stay in the cache?
Posted: 14th April 2010 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: administrator, buffer, cache, checkpoint, DBA, freeproccache, lazywriter, memory, memorystatus, sp, sqlperf, stored procedure
0
