lianvh (9/11/2012)
I am frustrated, because , a consultancy firm used this tool and now to keep the peace we have to implement this setting.
May I recommend that you find a consultancy that is a) capable of independent thinking and which is up to date on current SQL Server "best practices" and more importantly b) recommends things that are necessary for YOUR ENVIRONMENT to function optimally/correctly and which shows you WHY they make such recommendations using metrics from YOUR system(s)?!?
I happen to know of just such a consultancy, btw. 😎
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service