• Jeff Moden (1/25/2016)


    I guess "It Depends" on what you call a "gut feel". I was recently asked to provide hard evidence that a particular stored procedure was the source of a performance problem. They refused the "anecdotal" evidence of the (recorded) major blockage during the day occurring (causing the folks on the floor to complain) when that stored procedure is running and nothing else is. They called the plateau of CPU and wild/high disk IO as recorded in perfmon "anecdotal". They were especially firm in calling the many user complaints that occur at that same time "anecdotal". So, my "gut feel" is that they don't have a clue or don't want to spend the time fixing something that needs it.

    Someone needs to believe in "Scotty" when he says, "CAPTAIN, THE ENGINES!!!".

    I think that's called "denying the obvious" when the data identifies the root cause. People do it all the time according to what they hope is true, not what is true.