Home Forums SQL Server 2014 Administration - SQL Server 2014 Plan Cache. Size in sys.dm_os_performance_counters and sys.dm_exec_cached_plans RE: Plan Cache. Size in sys.dm_os_performance_counters and sys.dm_exec_cached_plans

  • November 19, 2015 at 6:47 am

    #1840964

    Justin Manning SA (11/19/2015)

    You have a lot of the cache allocated to ad hoc statements?

    Have you identified these and suggested making them stored proc's at least?

    Yes. This is some kind of normal 🙂

    Justin Manning SA (11/19/2015)

    I think the number will fluctuate as long as there are ad hoc queries running against your server.

    That is not the question. When no activity on server same diference between counter and cache.

    And few month ago, with same activity, there was no problem.