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 5 of 5   
 

SQL Monitor Custom Metric: Plan Cache; Cache Pages Total

This metric collects the number of 8-kilobyte pages that make up the plan cache to help identify memory pressure or plan cache pollution. A sudden drop in values for this metric may indicate that the instance is under memory pressure and SQL Server had to reclaim part of the plan cache for other use.  Read more...
By Press Release 2015/05/06 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 5,881 reads

Checking the Plan Cache Warnings for a SQL Server Database

How often do you check your query plans to see if they contain any warnings? If you're missing them, it means that you're not getting all those hints about missing indexes, join predicates or statistics. Is the query optimiser trying to tell you about implicit conversions? Dennes shows how to view the warnings in plan cache for a particular database using SQL.  Read more...
By Additional Articles 2015/03/02 | Source: SimpleTalk | Category: plan cache
Rating:  Rate this |   Briefcase | 7,200 reads

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: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,748 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 | 712 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,307 reads
   Items 1 to 5 of 5   
 
Tags
custom metrics (2)    
sql monitor (2)    
execution plans (1)    
nhibernate (1)    
redgate software (1)    
sp_prepexec (1)