Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag plan cache Rss

   Items 1 to 3 of 3   
 

SQL Monitor Performance Metric: SQL Server: Plan Cache: Cache Pages Total

This metric collects the total amount of memory, in kilobytes, used by the plan cache of an instance to help identify memory pressure or plan cache pollution. It is similar to the SQL Server: memory manager: SQL cache memory counter, but instead of providing the number of 8-kilobyte pages that make up the plan cache, it provides the total memory used.  Read more...
By Additional Articles 2013/10/01 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,602 reads

Find Single use plans in Plan Cache

This script will return all the Adhoc Single use Plans currently in your Plan Cache. It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008   Read more...
By SQLSACT 2012/12/11 | Source: SQLServerCentral.com | Category: plan cache
Rating: |  Discuss |   Briefcase | 672 reads

sp_prepexec and nHibernate

SQL Server architect David Poole sets about exploring sp_prepexec when called from nHibernate.  Read more...
By David Poole 2011/12/08 | Source: SQLServerCentral.com | Category: sp_prepexec
Rating: |  Discuss |   Briefcase | 8,158 reads
   Items 1 to 3 of 3   
 
Tags
custom metrics (1)    
execution plans (1)    
nhibernate (1)    
red gate (1)    
sp_prepexec (1)    
sql monitor (1)