Suggestions
Welcome to the Redgate Monitor feature suggestions list. Tell us how we can improve Redgate Monitor by voting on these suggestions or by submitting your own ideas.
This is the easiest way to make an impact on Redgate 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 — the Redgate Monitor team will often stay quiet initially about new suggestions to see what you have to say!
If you have any questions visit the Redgate Monitor forum.
- or
724 results found
-
know who ran SQL Compare and what changed
within SQL Monitor when it flags that SQL Compare ran, it would be good to be able to see who ran the job and what was changed. Currently the job is flagged in SQL Monitor but there seems to be no further details other than what database it ran on.
3 votes -
Show current RPO
Show current backup RPO and allow us to click the graph to see specific databases under each RPO grouping (>15 minutes, >30 minutes, etc).
5 votes -
Cluster Roles that have been renamed should no longer have an entry with the old name
Over the last year and a half I have migrated several SQL FCI's to new windows clusters, new hardware, windows and SQL versions. To accomplish this with minimal downtime I had to setup the cluster roles ahead of time with everything ready to go prior to doing a final tlog backup/restore and rename of the cluster instances. This has worked well for us however SQL Monitor creates a new server record when the instance is renamed and never gets rid of the original name of the the new instance. This has left me with SQL Monitor still showing this nonexistent instance with no way to remove it. This in-turn is now showing up as an instance that needs to be updated, when actually my entire environment is current.
Over the last year and a half I have migrated several SQL FCI's to new windows clusters, new hardware, windows and SQL versions. To accomplish this with minimal downtime I had to setup the cluster roles ahead of time with everything ready to go prior to doing a final tlog backup/restore and rename of the cluster instances. This has worked well for us however SQL Monitor creates a new server record when the instance is renamed and never gets rid of the original name of the the new instance. This has left me with SQL Monitor still showing this nonexistent…
1 vote -
Limit the number of backup entries listed for Estate Backup details
When viewing the backup details of a database in the Estate Backup view, the number of backups listed severly impact the usability. It seem to retrieve all backups done and stored in the SQL monitor DB or in msdb. As we have frequent log backups, this list is very long and heavy to retrieve and display.
1 vote -
Find Queries / Stored Procs whose Performance has Decreased Over Time
In preparation for changing the database compatibility level for our primary database to 2014, we would like to see which queries and stored procedures are performing poorly after the switch is made in the staging environment. While I can do this to a limited extent by looking at top queries in Red Gate Monitoring, I was wondering if there was an automated way to alert on this. For example, alert on any stored procedures / queries that appear in the top 100 costliest queries by duration / CPU usage, whose average duration / CPU usage has more than doubled since a particular date (in this example, the date of the cut over)
In the general sense it would also be helpful to have this type of alerting in place at the stored procedure level, to see if any change in stored procedure functionality led to a significant decrease in performance.
In preparation for changing the database compatibility level for our primary database to 2014, we would like to see which queries and stored procedures are performing poorly after the switch is made in the staging environment. While I can do this to a limited extent by looking at top queries in Red Gate Monitoring, I was wondering if there was an automated way to alert on this. For example, alert on any stored procedures / queries that appear in the top 100 costliest queries by duration / CPU usage, whose average duration / CPU usage has more than doubled since…
28 votes -
Log Alert Action Activity
Please store activity such as who clears alerts and when for the alert details.
Also, it'd be nice to have an overall auditing of who changed what when on various other parts of the website.
3 votes -
Baseline data within report graphs
It would be useful if I can include baseline data (as in Analysis section) within reports and their graphs.
3 votes -
Add custom alerts with exiting out of the box metrics
I would like to create custom alterts on existing out of the box metrics. I want to set an alert if for example PLE is going under a certein threshold. Without creating an additional custom metric.
4 votes -
FORCE "Estate" refresh re Actual Disk Space
Just freed-up 55GB on tempdb drive. F5 on the Estate page, Disk Usage tab, and SQM still says 11GB. Clearly WRONG!
Give us the ability for FORCE a disk usage re-calc.
9 votes -
Add "When File Grew" Drilldown to the new Estate page, Disk Usage
The new Estate page is already proving useful, but today not as much as it could be...
tempdb LOG suddenly grew to twice its normal size, and we have yet to trace why. It may have gone unnoticed but for SQM issuing a LOW DISK SPACE Alert!
Please add a drilldown for DB files that show the times, and quantities, for growth. A sparkline chart would help, too, as a visual cue. for the last 30-days, perhaps.
Thanks for continuously making SQM more useful.
3 votes -
Customize Alerts on the Overviews Page
Allow for the customization of the Alerts in the Alerts section on the Overviews Page.
These customized alerts would be independent of the settings for the Alerts tab. That way Alerts would just be customized for the Overviews Page.3 votes -
Define limit of the specific job alert.
problem : a job is running in every 2 mins and failed due to any reason .it will fire multiple alert ,I would like to restrict the limit of the specific failure
solution :as we work in the shifts , I want it should not come more then 3 time which is in 8-9 hours duration .when I am setting the limit then it will impact to all server not the specific one . whereas I would like to check this monitor based on the time and then fire the alert
3 votes -
Estate Disk Usage Emailed Report
It would be great if we could schedule an emailed report of the disk usage estate section.
11 votes -
Allow custom DML script deployments to show on SQL Monitor (like SQL Compare)
Write now, when you deploy with SQL Compare it puts this wonderful little tick mark in SQL Monitor to show the deployment location and time. We would like the ability to do this with SQL Multi Script or even manually via manual deployments.
3 votes -
Filter out Long Running Query alerts based on wait type
We have a 3rd party product that has a SQL Database. It has something in it that loads data RBAR (Row-By-Agonising-Row). The query gets all the data in about 3 seconds and then sits waiting on ASYNCNETWORKIO for ages (close to 40 minutes).
We don't want to exclude the application from all long running query alerts, and the query is different everytime which would make it hard to filter based on regex (and not filter other queries we care about).
We'd like a way that we can not raise a long running query alert if it's waiting on ASYNCNETWORKIO
We have a 3rd party product that has a SQL Database. It has something in it that loads data RBAR (Row-By-Agonising-Row). The query gets all the data in about 3 seconds and then sits waiting on ASYNCNETWORKIO for ages (close to 40 minutes).
We don't want to exclude the application from all long running query alerts, and the query is different everytime which would make it hard to filter based on regex (and not filter other queries we care about).
We'd like a way that we can not raise a long running query alert if it's waiting on…
11 votes -
date format
I'd like to have an ability to set date format according to the country where the monitored SQL server is in, e.g. USA where date format is MM/dd/yyyy vs UK as dd/MM/yyyy. Also, why not to read and set date format off of the monitored server? Please make it configurable and country compliant so to speak..
Thanks,
Yuriy4 votes -
Group sql server instances at the instance level, not at the server/cluster level
I would like to control the group that an individual sql server instance is in, rather then having to group things at the server/cluster level. The group views and control over alerting is great, but in the event that the same cluster/server hosts a dev and production instance, or multiple instances that are managed by different members of a DBA team,the usefulness really suffers.
14 votes -
SQL Agents Job Display Time Windows that Jobs are executing
The SQL Agent Jobs screen is a great way to track all jobs across all monitored servers. I think it would be helpful to see the gaps of time that no job is running to help determine maintenance windows and also make sure that the jobs are properly spaced out.
13 votes -
Performance graphs on disk space alert page
When we get to the disk space alert details it shows -as with all alerts- a bunch of performance graphs like CPU utilization, disk queue length etc... I think the most relevant graph is missing for this particular case. It would be much more interesting to get a quick glance of the disk space growth over the last 24 hours or couple of dyas for example
1 vote -
Estate Backup Emailed Report
I really like the new backup feature in the estate section; however, I would love to have this emailed on a scheduled basis. If the email could have a graph like the first sheet and the spreadsheet attached, it would be great.
43 votes
- Don't see your idea?