Skip to content

In Redgate Monitor, I want to...

← Suggestions

Select and store a static baseline for future reference

CONTEXT: When comparing server performance over longer periods of time or across deployments, the baseline functionality in SQL Monitor's analysis section is useful.

PROBLEM: SQL Monitor creates a dynamic baseline based on previous data. While this baseline is a realistic idea of what's "normal" it requires us to keep a lot of data in SQL Monitor

EXAMPLE SOLUTIONS:
• Aggregate data in SQL Monitor so that it can be retained for longer without using much space
• Allow us to "freeze" a baseline so that the data doesn't get deleted.

What do you think about these solutions? Got another idea? Let us know in the comments!

41 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…)
Daniel Rothig shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

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
  • SQL4GNT commented  ·   ·  Report

    Yes as an extension to the existing suggestion.

    Agreed!

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

    Hi,

    Thanks for the suggestion. This could be considered as an extension to an existing suggestion - the ability to store a baseline. https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2059115-ability-to-store-a-baseline

    This would allow you to store and manage your baseline, with the ability to include/exclude data from it. If you agree, I will merge your suggestion so that your votes are added to it?

    Thanks again,
    Adam

  • SQL4GNT commented  ·   ·  Report

    Sometimes the baselines that get established will change due to modifications of the job or the server. The ability to adjust baselines and/or clear them would be extremely helpful

  • tjaybelt commented  ·   ·  Report

    I ran into a situation this past week when the RedGateMonitor database grew to consume the rest of the space on the LUN allocated it.
    While it was full, many functions ceased working properly. I ended up adding another data file to the database to get around the issue. It would have been nice if I could go into a config and purge out old data. maybe cleared alerts that I just recently cleared. Maybe some sets of data that you deem 'old' that could be forcefully purged from the system

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)