• 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