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