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.
773 results found
-
Be able to schedule a maintenance window with the possibility to use an offset.
Be able to schedule a maintenance window with the possibility to use an offset. Say every 3rd tuesday of the month + 12 days.
5 votes -
A way to showcase all SQL Statements running for a specific time frame
A way to showcase all SQL Statements running for a specific time frame. This is will be helpful to investigate any issue that occurred in the past.
5 votes -
be able to switch support for cloud-features and off based on company needs
Some companies still operate on-premises only, others operate only for Amazon RDS xor Azure. Having all these cloud-database features enabled clutters the user interface and I'd rather like to enable/disable such support through configuration options like
[ ] enable Amazon RDS
[ ] enable Azure SQL
[ ] enable Azure Instance
...
[ ] enable Oracle/xxx/yyy features5 votes -
Word Wrap Alert Comments
Super minor detail, but it would be a more pleasant experience if I didn't have to use a scroll bar to read comments on Alerts. If it were word wrapped in some manner it would make the user experience better for me.
5 votes -
Monitor repliction
Monitor replication (same as replication monitor)
5 votes -
Provide a report on queries with suggestions on improving performance
When viewing the top 10 queries, we can see suggestions on what may improve the performance for the specific query. Can this functionality be summarized in one report per database to suggest and what indexes could assist with improving performance.
I would like to see:
SQL Query, Query statistics, Query plan, Suggestion(s)(similar to top 10 but more extensive.)
Also provide searching capability to look for any suggestion that relates to a specific object.
This will assist DBAs to specifically drill into a specific issue query and provide instant suggestions on what can be done to improve performance for that…
5 votes -
Fix the column headers for the Top Queries when scrolling
On the Server Overview "Top Queries" section, it would be helpful if the header row of the table didn't scroll off the screen. I keep scrolling back up to work out if I'm looking at reads/writes/CPU Time/etc.
5 votes -
alert when database was created / dropped
It would be nice to have a build in alert when someone (e.g. a vendor) created or dropped a database.
Reasons:
- you may want to delete old backup files (if dropped) or have to modify / delete some maintenances
- you'll make a manual full backup of the new DB so that log-backups could be taken by your backup solution
- maybe you have to add the new DB to monitoring (as DLM Dashboard), backups (and have to consinder its the disk space at the backup drive) or an Excel-Sheet with a list of your databases :-)Real-Live-Example:
I…5 votes -
TempDB Percentage Free Space Monitor/Alert
Common practice is to put TEMPDB files on a dedicated disk and size TEMPDB to fill the entire disk.
When TEMPDB grows unexpectedly it can quickly use all the space on the disk and is a common cause of SQL Server issues.
We have great observability about TEMPDB issues in SQL Monitor now but no default alerts.
We have some metrics we can alert on such as TEMPDB Free Bytes, but a literal value is not much use in a mixed environment where some servers have 1TB+ TempDB databases and some have only 30GB.
We collect a custom percentage free…
5 votes -
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.
5 votes -
see a greater time range in the Overview
Often customers would like to see a broader overview, eg a whole week or a classic working week (Mon-Fri). It would be great if we can extend the overview to 5 or even 7 days.
5 votes -
compare query metrics across instances
I would like to be able to compare query metrics across SQL Server server instances.
We have a number of environments - Dev / QA / UAT / Production
the data generally increases in volume and gets more "real" the further up the chain we go which can mean something that performs well against the "small data" on the dev server can become an issue when it hits UAT which has real volumes of data
It would be useful to be able to compare a query across instances so if we release a feature which comprises of a number of…
5 votes -
Make configuring alerts easier
Currently we have several instances grouped into three top-level groups and then several subgroups underneath. This structure allows us to set alerts at the group level and then drop instances in and out of that defined set.
If we select a group and configure an alert setting, when the page refreshes it does not return back to that same sub-group, instead opting to go back to the very top 'All Servers' level which if not spotted can mean you then select the next alert to configure and inadvertently change the setting for all servers.
This seems like basic functionality but…
5 votes -
Custom Metrics are specific to a base monitor without a way to copy them
I have to create all custom metrics and alerts 3 times, once in each base monitor. And there is no way in the UI to copy from one to another.
I guess this makes sense because each base monitor only knows about the groups and targets it has. But it would be a great enhancement if the UI supported copying the custom metrics from one base monitor to another.
5 votes -
File Usage per File Group within the DB
Want to be able to set database file usage per drive level on the server level. But there are many times when a vendor created db, they have multiple data files mdf/ndf and have them set to limits. So i was wondering can we get even more granular. I want to be able to drill down to the database and select a particular file group and say ignore this drive, it has meet its capascity and even though its 100% filled data is no longer being written there. And the reason behind that is there can be multiple data files…
5 votes -
Grant access to the Security Auditing features to a specific user role or user group
As a DBA, I wish to grant access to the Security Auditing features (Permissions changes and Configuration compliance) to our security team. I do not wish the security team to have full administrator access to the Redgate Monitor installation as they are not DBAs and neither interested in nor responsible for any other parts in Redgate Monitor.
At the moment, only Redgate Monitor administrators have access to the above enterprise security features in Redgate Monitor. From a separation-of-duty perspective, the security team should not have full access as administrators to the Redgate Monitor installation.
5 votes -
Link to alert within Teams notification
I would like to see a direct link to redgate monitor alert within the teams notification. At the moment I have to search for the alert in the WebUI manually instead of clicking a direct link like it is in a mail notification with "View full alert details" button.
5 votes -
Option to exclude custom metric from Analysis Graph page
When setting up a custom metric, have the ability to exclude it from the Analysis Graph page. E.g. I set up a metric that checks the AutoUpdateStatistics setting for each database and then creates an alert if a database is set to OFF for this setting.
It is however not needed in the Analysis Graph page as it is purely an alert.4 votes -
How about a custom metric or alert to return data in character value as opposed to just numeric scalar or NULL
I want to have a function much like profiler to collect login data, who logged on & be able to filter on the data collection, for instance, if I only want to see when domain\me connects to the sql server, I would like to track that information. I am aware this can be done with profiler, but I would really like to have the ability to use one tool.
4 votes -
Alerts with and/or (boolean) logic
To determine performance problem b it is needed to monitor several counter values at once. For example when counter x and counter y and counter z are all below 10 then you have a memory problem. I would be nice to contruct that kind of logic to get true performance alerts.
4 votes
.png){kind=link}
- Don't see your idea?