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 flush automatically? Expand / Collapse
Author
Message
Posted Saturday, September 28, 2013 6:38 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 8:55 PM
Points: 1,076, Visits: 3,054
Hi.

I have checked my production database for top memory consumer components

Database enabled - AdHoc workloads and force parameterzation (for the reason too much single plans created and wasted memory)

1. CACHESTORE_SQLCP - using Constantly 2.5GB due to database do not have SP and all.. Application request Ad Hoc query only..

2. TokenAndPermUserStore - using 800 MB

I cleared the TokenAndPermUserStore by using command (dbcc freesystemcache('TokenAndPermUserStore') and automatically reduce the CACHESTORE_SQLCP memory usage, what could be reason?

Thanks
ananda


Post #1499685
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse