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 ‘buffer’
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
List of Undocumented DBCC command..
Posted: 10th March 2010 by Deepak in Scripts, SQL DBA, SQL Dev, UncategorizedTags: buffer, cachestats, checkalloc, checkdb, DBA, dbcc, dbcc page, shrinkfile, sql, sqldba, sqlperf, update, useplan
List of Undocumented DBCC command.. DBCC activecursors [(spid)] DBCC addextendedproc (function_name, dll_name) DBCC addinstance (objectname, instancename) DBCC adduserobject (name) DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid) DBCC autopilot (typeid, dbid, tabid, indid, pages [,flag]) DBCC balancefactor (variance_percent) DBCC bufcount [(number_of_buffers)] DBCC buffer ( {‘dbname’ | dbid} [, objid [, number [, printopt={0|1|2} ][, [...]
