• A little knowledge is a dangerous thing....be careful.

    First off, my advice is: Change nothing.

    Monitor monitor monitor. Get to know the environment. Check all of the agent jobs, what do they do, when do they run, how long, what is the history - solid runs or occational failures. Do you need to deal with the failures? How?

    Is a backup process in place? Are the indexes being maintained (http://ola.hallengren.com/)? Is there a process for monitoring disk use and datafile use/growth?

    Brent Ozars sp_Blitz is a good starting point for digging around, but again dont change a thing based on this output. That wonky setting may be there for a reason.

    Get the daily operational stuff down. Then you can look at improvements.