Home Forums SQL Server 2005 Administering optimize for ad hoc workload RE: optimize for ad hoc workload
SQL Show
SSCertifiable
Points: 6143
More actions
December 19, 2012 at 2:12 am
#1569933
We were examining plan cache size. Actually cache size of most of the adhoc queries are more than 40KB. We are working to convert them either parameterized or SPs.
Thanks Gail.