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.
711 results found
-
Exclude a database, instance or the entire alert based on an actual alert
It would be a nice feature to be able to click on an alert and get the option to exclude future alerts:
1 - for this specific database
2 - for this specific instance
3 - for this specific alert3 votes -
Show login or user in the Top 10 Queries
Include login or user id information in the Top 10 Queries. This could help identify if a user is running an ad-hoc query.
48 votes -
compare different times in analysis graph
We have upgraded SQL and changed servers for one system It would have been nice to compare in the same graph different timeslots and different machines
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 -
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 -
Sort top queries by logical reads, or cpu usage.
Same idea that is already being done with duration. These are the 3 aggregates most commonly used. Being able to sort by avg vs total would be ideal. Performance Reports in SSMS can do this, so that idea.
1 vote -
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 -
bring Failed SQL Agent Jobs to the front
Show Failed SQL Agent Jobs at the first. Currently its behind (graphic)
For us its important to see the Failed Jobs.
6 votes -
Only Alert Database File Usage on one copy of a database in Availability Group
When monitoring all instances of an Availability Group, the Database File Usage alerts on every instance. This just adds extra noise. It would be great if instead of alerting on each copy it just alerted once on the availability group somehow.
3 votes -
Set Maintenance Window by Group
We do maintenance by class of server (DEV, QA PRD) and update an entire group during one maintenance window. It would be nice to be able to select a group like "Production" and set one maintenance window instead of setting it for each server. And since we do maintenance on the second Sunday for one group and the third Sunday for another we can't set a window and forget it. We have to set it before the weekend there will be work done and then clear it on the following Monday. More scheduling flexibility would be a wonderful addition.
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 -
Estate Page - Disk Usage - Show Actual with Allocated
There's plenty of real-estate to include a column for database file rows that shows the true "USED" space, not the Allocated space.
Right now, SQM is predicting data drive exhaustion at 16 days hence:
Fake "Used": 5,634.5 GB Capacity: 5,959.4 GB Fake "% Used": 95% Time until full: in 16 daysSadly, Untrue, from a "Used" perspective - only true from an Allocated perspective!
When I drill into that drive, THIS is the truth:
Used: 4,752.6 GB Capacity: 5,611.7 GBPlease promote this "USED" as a higher-level total, and use it as a projection - i.e., retain a history of…
4 votes -
shortened neat sharing links for graphs etc
shortened neat sharing links for graphs
3 votes -
Configure Alert-Ended messages at alert type level
in the global settings I can configure, that I want to receive deescalation mails when an alert ended (e.g. CPU went back to normal, Server available again ...).
For many alerts this makes sense, but for other alerts not so much or not for everybody (e.g. deadlock alerts, the custom failed-logins alert, job-failed alerts...).
So it would be nice, if I could configure this (as most other options) at least at alert type level or better down on group / server / database etc.
6 votes -
full table scans
Highlight full table scans on big tables, so these can be investigated
It could be these tables have grown, so initially they were ok, but now they aren't
3 votes -
Alarm based on cumulative wait ms/s
The per server overview includes a graph of wait ms/s. I want to be able to set an alarm threshold based on Core Count and wait ms/s - If the server is waiting for more than 30% of total available cycles then raise an alarm
E.g. Server has 24 cores, and therefore 24,000 ms/s of available waits
Wait ms/s = 10,000 - 10,000 / 24,000 = 41.7% - ALARM
Wait ms/s = 2,500 - 2,500 / 24,000 = 10.4% - No alarm5 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…
11 votes -
Monitor Hyper-V hosts
https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2936441-identify-if-virtualization-hosts-are-congested is closed, so I'm opening a new suggestion - please add the ability to monitor Hyper-V hosts, similarly as we can currently monitor VMware hosts.
19 votes -
Force re-check of index fragmentation alert
The index fragmentation alert is checked only once per week, because of the load is causes on the system. I am fine with that.
However, I would like to have the option to force an immediate re-check for a specific database - for instance by adding a "re-check" button to the alert window.SCENARIO: The index fragmentation check runs on Saturday and triggers an alert on one database. On Monday I check the alert but I know that the weekly index defragmentation job runs on Sunday, so it is likely that the problem is already fixed. But I like to…
13 votes -
export the overview page
The reporting is very limited and provides less detail that the overview and estate pages. We need to be able to export the overview and estate pages easily. Also need to be able to report on the Top queries and top waits.
8 votes
- Don't see your idea?