• Mike Dougherty-384281 (3/22/2013)


    I assume that if I asked any of the professionals in this SQLServerCentral community if I should change setting X, the most accurate answer would be "it depends"

    🙂

    Mike hit it on the head with this statement. The general configuration and default is for a general installation and data collection. We have the normal configuration for the normal data collection and business activity. If your data collection or process is vastly different you will want to configure things to optimize that processing or requirement.

    Do we need more switches? "Yes depending on" the level of control we really need or feel we need for our specific process/data/user activity.

    The challenge is that with more options we introduce a potential for more confusion by these new or unfamiliar with the process, theory, and strategies of data could become. By having say 14 new dials we may find some DBA's thinking that they should use some of them just because they are there and they may "test drive" a few just to see. In doing so they may introduce a significant amount of work with little or no gain.

    Mike is right,, it really does depend on ...

    Not all gray hairs are Dinosaurs!