Home Forums SQL Server 2008 SQL Server 2008 Administration Plan Cache - Adhoc - Usecounts 1 RE: Plan Cache - Adhoc - Usecounts 1

  • October 25, 2012 at 5:25 am

    #1552640

    Grant Fritchey (10/23/2012)

    There is a setting called 'Optimize for Ad Hoc Workload' that could help you out. Instead of storing a plan each time a query is run, the first time it's run a plan stub is stored. This radically reduces the amount of wasted space in the cache.

    Thanks

    What do you think about the database setting "parameterization forced"?

    Thanks