Skip to content

Suggestions

Welcome to the Redgate SQL Monitor feature suggestions list. Tell us how we can improve SQL Monitor by voting on these suggestions or by submitting your own ideas.

This is the easiest way to make an impact on SQL Monitor’s roadmap. Check out the completed suggestions to see how your ideas have influenced us in the past. Please note that this list is one of multiple sources that drive our development, meaning that we will not always implement the highest-ranking suggestions.

To give your idea the greatest possible impact, please follow these guidelines:

  • Describe the goal you’re trying to accomplish, rather than a specific solution to get there
  • If you have a favoured solution, add it as a comment to your suggestion
  • Give us as much context as possible
  • Only make one suggestion per post. If you have multiple ideas, submit them in separate posts
  • Comment and vote on existing posts to develop the ideas — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!

If you have any questions visit the SQL Monitor forum.


In SQL Monitor, I want to...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

665 results found

  1. Clear RedGate Alerts automatically

    Once the alert is taken care of, RedGate should send an email saying that the alert is cleared. Also, there is no need of a clear button in the web interface, it should be done automatically.

    2 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…)
    1 comment  ·  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

  2. Have a free-text notes field for each server\instance

    A notes field can be used for any useful information such as business contacts, service hours or documentation links, etc.

    16 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…)
    1 comment  ·  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

  3. Ability to filter "TOP Queries" by login

    Often we want to filter queries not only per existing options (database, parent or query) but it's useful to be able to search for a specific login.

    Could you allow searching by login using "l:" or "login:"?

    6 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…)
    0 comments  ·  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

  4. Mask sensitive data from deadlock and top queries

    We want to let developers use SQL Monitor, but for that sensitive data has to be masked. Two places that come in mind where we can things like literals in WHERE clause etc are deadlock and top queries. This would ideally be combined with a security group which which the masking should apply.

    3 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…)
    0 comments  ·  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

  5. Monitor Cluster Shared Volumes

    Under the “Analysis” section, there are cluster metrics which include four different options relating to Cluster Shared Volume usage.
    • Used Bytes
    • Used %
    • Free Bytes
    • Free %

    If we click on the above, we can review our CSV’s to see whether we are approaching the drives maximum capacity.
    What isn’t included is the performance of the disk. For instance, under the Machine metrics section, the following is available:-

    • Disk avg read time
    • Disk avg write time
    • Disk read bytes/sec
    • Disk write bytes/sec
    • Disk transfers/sec
    • Avg disk queue length.

    However, these…

    10 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…)
    0 comments  ·  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

  6. “Longest Running Queries” in Redgate SQL Monitor Reports

    I need to show more “Longest Running Queries” in Redgate SQL Monitor Reports. The layout of the report is also a bit awkward, it seems if everything does not fit into the report.
    See attachment.

    7 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…)
    1 comment  ·  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

  7. Job Duration Unusual Alert should be 'AG aware' to avoid false positives

    We are using an AG for one of our instances.
    As you would expect we have the same SQLAgent jobs created on both instances in this AG, but we only want the job to execute on the primary.
    In SQLAgent the jobs on both nodes of the AG have a step at the beginning which checks to see if this is the primary instance.
    If it is the primary instance it will proceed to step 2 and execute the rest of the job.
    If it is not the primary instance the job will terminate.
    This all works fine - however…

    2 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…)
    0 comments  ·  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

  8. Expiring Certificates

    Would really helpful to have an alert for expiring certificates on a cert be it backup encryption ones or tde certs that are going to be expiring and we specifies how much notice we want given before the expiry

    5 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…)
    0 comments  ·  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

  9. Add date to legend when filtering across multiple days

    When we filter on the top graph across multiple days, on the legend below won't show the days, just the time.

    The image is the current case.

    What I would like is to have the days.
    Instead of "from 08:18 to 08:19"
    expected "from 18 Jun 08:18 to 19 Jun 08:19" or equivalent

    3 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…)
    0 comments  ·  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

  10. Being able to filter "TOP Queries" by any of the columns

    On the "TOP Queries" grid we can order it by any of the columns (besides "Database").

    I would like to be able to filter the rows by the amounts.

    Example:
    Filter queries where "Execution count > 100" same for other columns.
    Then apply the "order by".

    This way we can filter together with the "Enter search term" box.

    6 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…)
    0 comments  ·  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

  11. Estate Licensing - Align with Microsoft HA/DR Licensing policy

    Estate licensing appears to tally all licenses for servers in an WFC/HA config. 3 node cluster 4 cores, 12 licenses (when it should be 8). Please provide the process to identify an HA or DR node, which will allow the Redgate Estate portal to align with Microsoft SQL Licensing: https://download.microsoft.com/download/e/2/9/e29a9331-965d-4faa-bd2e-7c1db7cd8348/SQL_Server_2019_Licensing_guide.pdf.

    3 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…)
    0 comments  ·  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

  12. Schedule hourly reports to email out and base on groups

    I would like to be able to send hourly email report for example Failed sql agent jobs base on a group not just one server, covering certain period of time like 9-5 each day of the week Monday- Friday.

    4 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…)
    0 comments  ·  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

  13. Median from jobs - calculating Job duration unusual ONLY for sucess

    I have noticed that SQL Monitor calculate median from all jobs ragardles if it is failed or sucess...
    From my point of view it should analyse only jobs which finished success and calculate median from duration.
    I need to know when job succeded what is duration median and if it is ok or not.

    Please change job duration median to calculate from jobs which ended with sucess.

    3 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…)
    0 comments  ·  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

  14. Modifying of several alerts for specific entity could be more user friendly

    1) after change tree in left panel with all servers collapse and again should expand nodes down to place where I left
    2) color of changed records could be more visible, maybe some light background could be added

    4 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…)
    1 comment  ·  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

  15. be able to set top level notification settings through powershell module

    I want to be able to use Redgatesqm.ps1 to configure smtp server, default email list and other top level notification options.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  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

  16. Long Running Open SSMS Transaction

    Would be really helpful to have an alert that can alert on long running open SSMS transaction and the alert can return the user running it and query being run and on what server we often see it when users forget to commit or role back there transaction.

    4 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…)
    0 comments  ·  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

  17. Only Query Serverless Azure SQL Databases if they are Online and not Paused

    As mentioned in the below post, SQL Monitor will keep serverless Azure SQL databases from pausing and saving us the money they are supposed to. I would like the Azure SQL monitoring piece to be rewritten to use the Azure API to determine both if the Azure SQL DB is serverless or not and if it is AND paused, don't run any queries that would wake it. Yet if it is NOT paused, get info about it and update SQL Monitor.

    https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/45670060-exclude-serverless-databases-from-monitoring

    3 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…)
    0 comments  ·  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

  18. Uptime of my SQL server database servers

    I need to be able to account for yearly uptime for my SQL server estate and also receive proactive alerts when they are shutting down.

    4 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…)
    0 comments  ·  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

  19. Add database changes details based on the zoom range

    In the "Databases" section when selecting one, we would like to have a list of the database changes that happened based on the "zoom range" period.

    Right now I'm thinking based on the SQL Server error log

    Example:
    1 - Database Status changed. Online/Offline/Read-Only/Read-Write/etc
    2 - Compatibility Level changed - This will be great to co-relate some situations with the CL change.
    3 - Page Verify
    Etc

    In the end, any message that uses any of these texts:
    SELECT * FROM sys.messages
    WHERE text like '%Setting database%'

    This includes query store changes

    7 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…)
    0 comments  ·  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

  20. Ability to add notes to tracked queries

    When working in an environment with multiple people is typical that each person is tracking different queries to analyse ongoing changes/improvements.

    Being able to note something as "Tracked by Cláudio. Following FIX #1234" would be great.

    It will give us a clue on who is working on what and reach out to that person. Or just keep small notes during the analyses.

    5 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…)
    0 comments  ·  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
    under review  ·  Neil Turner responded

    A great suggestion. We are exploring this as part of a wider review into improving query tuning features.

← Previous 1 3 4 5 … 33 34
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)