CACHESTORE_SQLCP flush automatically?

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  September 28, 2013 at 6:38 am

  #298417

  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