April 1, 2011 at 1:09 am
Can I change this settings to TRUE on Online database? What are the concerns plz...
April 1, 2011 at 1:30 am
Which settings?
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 1, 2011 at 1:50 am
Ohhh my bad,
Optimize for Adhoc workload
April 1, 2011 at 2:05 am
Hope the below link helps. There is a good explanation about it.
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 1, 2011 at 2:13 am
Shaiju, it was a good article. However I did not get an answer. My specific question is "Can I be changed Optimize adhoc for workload" setting to true for an online database, ie, I do not wanna take my DB offline. If not What would be the impact?
Thanks in advance!!!
April 1, 2011 at 2:36 am
Oh. Sorry. I read the below in one link. So, It should work online.
"Setting the optimize for ad hoc workloads to 1 affects only new plans; plans that are already in the plan cache are unaffected."
Also check the following link.
http://sqlserverperformance.idera.com/memory/optimize-ad-hoc-workloads-option-sql-server-2008/
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 1, 2011 at 5:09 am
Paul Randal is recommending turning it on for all servers. That's good enough for me. I'd go for it.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply