In SQL Monitor, I want to...

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!

27 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…)
    Daniel RothigDaniel Rothig shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    SQL4GNTSQL4GNT shared a merged idea: The ability to clear baselines  ·   · 
    tjaybelttjaybelt shared a merged idea: Ability to Purge stored data  ·   · 

    5 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...
      • AdamAdminAdam (User Experience Specialist, Red Gate Software) commented  ·   ·  Flag as inappropriate

        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

      • SQL4GNTSQL4GNT commented  ·   ·  Flag as inappropriate

        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

      • tjaybelttjaybelt commented  ·   ·  Flag as inappropriate

        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

      Feedback and Knowledge Base