• lassell - Saturday, July 22, 2017 10:13 PM

    Apologies if you feel this goes way beyond a free forum request but you have under miss-understood my request.

    I am not after someone to providing me with a free answer,  I have a full understanding of the different metrics I can collate for performance tuning, reporting etc I wanted to know if anyone had any ideas about how these metrics can be presented within one graph that a non-technical person would understand or relate to.

    In your case (high-level senior management) I don't think the graph type or visual is nearly as important as providing a basic, clearly (and shortly) worded statements of what is being observed - as well as at least what order of magnitude numbers represent "suboptimal or worse". Even a descending line where "smaller is better" could represent a HORRID situation, whereas an increasing chart could be awesome because it is two orders of magnitude away from a pain-point threshold.

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