Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

CACHESTORE_SQLCP Expand / Collapse
Author
Message
Posted Wednesday, November 28, 2012 12:24 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:53 AM
Points: 1,375, Visits: 2,667
Hi Guys

I've seen it posted that when using a Query like below to check Memory Allocations, if there is a high amount for CACHESTORE_SQLCP then that means that there are lots of Adhoc Plans in your plan cache

I tend to disagree with this because the CACHESTORE_SQLCP cache store also stores plans for Prepared Queries which has their plans re-used the same way Stored Procs would.

Unless my understanding is off?

Any thoughts on this?

SELECT TOP(20) [type], [name], SUM(single_pages_kb)/1024 AS [SPA Mb] ,SUM(multi_pages_kb)/1024 AS [MPA Mb]
FROM sys.dm_os_memory_clerks
GROUP BY [type], [name]
ORDER BY SUM(single_pages_kb) DESC;

Post #1389534
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse