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.
718 results found
-
show client host name for queries in top SQL
In the TOP SQL, I see login and program name, but not client host name. It would be helpful to see the client host name, too.
9 votes -
Backup overdue alert - RegEx filter
I have many non-production databases on production SQL Instance, that make no sense to backup. I know I can turn this alert off one by one on each database. RegEx filter by database name would be help.
12 votes -
Monitor SQL Server running on AHV hosts
Whilst you have added the ability to monitor vmware hosts, I would like to be able to monitor other virtualization technologies. E.g. AHV (Nutanix)
6 votes -
Customize Estate Version Thresholds
On the estate tab, it would be nice to customize the thresholds that define the yellow and red state. For example, a server behind on one CU might be yellow, but others red.
5 votes -
See the last X weeks of User transactions/SQl statments ran on the server
Have a view in SQlMonitor that can be used to do a quick search on what querys a user has run on SQL Server over the last X weeks.
For our user case we would just need the data for the last two weeks but sure if storage allows user's would like to hold the data for longer.
This is to enable some auditing functionalty to quickly find what a user has ran for reporting.
e.g.
What did user1 run yesterday,
What was run and by who over the last hourThis could also help with finding performance issues. For…
7 votes -
Blocking process report does not display database name
I would like to see databasename and also starttime and endtime in the blocked process report. It qwould also bee good to be able to scale the picture in size.
7 votes -
Monitor Distributed Availability Group Metrics
Monitor Distributed Availability Group Metrics, currently there doesn't appear to be any metrics tied to distributed AG. Could be as simple as using the monitoring query her:
https://tracyboggiano.com/archive/2017/11/distributed-availability-groups-setup-and-monitoring/16 votes -
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 -
Monitor Resource Governor
Possibility to monitor Resource Governor Pools:
• Show statistics on pools
• Show workload of groups: cpu, io and memory18 votes -
"Index searches/sec"
Why in SQL Server metrics there is no “Index searches/sec”.
In your description for “Full scan/sec”, you mention “The ratio of Index searches/sec to Full scans/sec should generally be no more than 1000:1.”.
It would be very useful to have this counter without having to go through performance monitor under windows8 votes -
be able to move database to another server
Sometimes I need move database to another server. I did it last time and I lost access to historical data. Moving databases is very common practice.
I think it is a big disadvantage.3 votes -
Add waits, CPU, & IO to the "sort by" options on the Global Dashboard.
Currently there are only two choices to sort by for the Global Dashboard screen:
Name & Severity
It would be nice to add more options, as they are displayed in the tile view. The options of course would be waits, CPU, & IO.
25 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 -
Query Plan Regression
Ability to track queries and alert when query plan regresses or duration increased beyond a given threshold.
6 votes -
Add support for Windows Server Core
Server Core has a lower attack surface, uses less RAM and disk space and is the default way to install Windows Server
14 votes -
Raise an Event Alert when a database is dropped
There is currently no alert when a database is dropped or detached from a server. SQL Monitor should create an Event alert to record when the drop happened. Obviously this might be intentional (e.g. the alert you have now that records a database is offline), but it might be accidental or unknown to the DB team (E.g. a vendor drops their database).
Because it will (hopefully) be an intentional action, and quite probably no plan to ever re-attach the database, the alert should be an event alert rather than a normal alert (the normal alert would never end)
A similar…
6 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 -
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 -
Replication Monitor
Create a replication monitor type dashboard show status and current latency etc.
37 votes -
add more custom notifications
Execute HTTP Action :
This notification method executes a GET request or sends any POST, PUT, or PATCH data to a custom URL. You can execute specific actions on a web server or control any web service that accepts commands via one-time HTTP requests. Whenever a notification of this kind is triggered, the HTTP action is sent.Execute Program:
With this notification method, you can execute a script or a program as an external process. It can be a Windows executable file or a BAT, CMD, or PowerShell file. You can use EXE, COM, BAT, CMD, VBS, or PS1 files.
11 votes
- Don't see your idea?