• Well done.

    I have been doing this type of analysis for a decade now, but have never done the execution histogram like you have done with the case statements. I like that.

    It would have been nice if you had covered some of the ways to 'normalize' the executions by replacing sproc parameter values. Perhaps the next article... 🙂

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service