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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply