In SQL Monitor, I want to...

Ability to store a baseline

After attending SQL in the city and listening to Grant Fritchey talk about the need to create baselines (and demo sql monitor) a feature I would like is the ability to create a baseline over 24 hours and have it stored. This could be then added to the analysis page as a Versus. ie last hour vs baseline, last day vs baseline.

118 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Andrew HodgeAndrew Hodge shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    With SQL Monitor v.3.5 introducing a powerful baselining feature, we consider this suggestion as completed.

    One thing our implementation doesn’t do (though it was mentioned in a couple of comments) is to be able to “freeze” a data range so as to retain a static baseline. We’ve created a suggestion for this additional functionality – so if you are interested in that aspect please vote on the following suggestion: http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11122092-select-and-store-a-static-baseline-for-future-refe

    Thanks
    Daniel

    10 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Ray HerringRay Herring commented  ·   ·  Flag as inappropriate

        It would be nice to have rolled up or aggregated metrics for the baseline. For example, when the data is older than a week aggregate Hourly Min, Max, Avg Disk Sec/Read. When the data is older than a month aggregate Daily min, max, avg with high hour, low hour.

        Also provide a way to designate a particular interval as a baseline. Like a snapshot. I would like to have perhaps a half dozen different snap shots for the instance and for each DB. These would be "permanent" and retained until the user replaced or deleted them.

      • jonathanallen69jonathanallen69 commented  ·   ·  Flag as inappropriate

        Daniel, this request is wholly different from the baselines available in SQL Monitor v3.5. We need to be able to store a baseline for performance for a given duration, in isolation, for as long as we choose. Not to have to keep everything from a point in time in order to draw baselines from that data. this request should not be closed.

      • Blaž DakskoblerBlaž Dakskobler commented  ·   ·  Flag as inappropriate

        Hi Priya,

        First, props for the feature. Was already using the compare feature extensively, this is a nice upgrade to that.

        I'd like to point out something that came to my mind while using it - sometimes you get data you would like to exclude from the baseline. Let's say you want to check out some graph for today, 24 hours back and extend that a couple days more into the past. The problem is what if one day was completely off the baseline - you'd want to exclude that, else it skews the baseline.
        Don't really have an idea how to solve this elegantly, but thought I'd share this with you anyway.

        Cheers,
        Blaž

      • kevrileykevriley commented  ·   ·  Flag as inappropriate

        excellent idea. Maybe also add baseline management, so that after a major change you can 'recalibrate' your baseline

      Feedback and Knowledge Base