December 17, 2012 at 11:30 pm
Could someone please help me?
When trying to configure "optimize for ad hoc workload" in a 2005 Developer edition , getting below error.
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Msg 5808, Level 16, State 1, Line 2
Ad hoc update to system catalogs is not supported.
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option 'optimize for ad hoc workloads' does not exist, or it may be an advanced option.
Msg 5808, Level 16, State 1, Line 1
Ad hoc update to system catalogs is not supported.
December 18, 2012 at 2:05 am
The optimise for ad-hoc workloads option does not exist in SQL 2005. It was added in SQL 2008.
p.s. you may want to change 'allow updates' back to 0 if you want to get rid if that 'adhoc updates to the system catalogs are not allowed' message every time you try to reconfigure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2012 at 2:12 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply