SQLSACT (10/25/2012)
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
That is a sledge hammer approach that can make some things faster/better but can totally screw the pooch on others. Test and see if it is right for your workloads.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service