Skip to content

In Redgate Monitor, I want to...

← Suggestions

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

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Andrew Hodge shared this idea  ·   ·  Report…  ·  Admin →
completed  ·  Daniel Rothig responded  · 

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

Show previous admin responses (3)

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Ray Herring commented  ·   ·  Report

    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.

  • jonathanallen69 commented  ·   ·  Report

    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ž Dakskobler commented  ·   ·  Report

    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ž

  • AdminPriya Sinha (Admin, Red Gate Software) commented  ·   ·  Report

    Hi Jiri,

    Thanks for your feedback.

    We are currently discussing baseline and in the process of scoping it. But I am afraid we dont have any dates yet. Will update this thread as soon as we have some dates.

    Thanks,
    Priya

  • John Stafford commented  ·   ·  Report

    Definitely a useful idea - could we store several / a few baselines?

  • AdminAdam (User Experience Specialist, Red Gate Software) commented  ·   ·  Report

    I was also at Grant's talk at SQL in the City and remember he did emphasise the importance of baslines. We really like the idea of saving a baseline for comparison and we'll post back when we have an update on this.

    Thanks both for the feedback

  • kevriley commented  ·   ·  Report

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

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)