Home Forums SQL Server 2008 SQL Server 2008 Administration Does this sound like a good place to enable "Optimize for ad-hoc workloads?" RE: Does this sound like a good place to enable "Optimize for ad-hoc workloads?"
dbafromthecold@gmail.com
SSChampion
Points: 10160
More actions
June 28, 2013 at 2:04 pm
#1628419
Hi,
Without knowing more about the server it is hard to make a call. How many and now big are the databases on it? What type of work load does it churn throughout one business cycle?
Andrew