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
753 results found
-
suspend
Hi,
I think it's very important to show Suspended status of a monitored host/instance should be shown in dashboard.
I had suspended monitoring on an instance and forgot to resume so I've missed monitoring for a while.
I suggest to show the state of monitoring (Active or Suspended) maybe graphically/iconic, in the dashboard and Server overview pages10 votes -
Export the analysis graphs to PDF and add printing support.
I would like to be able to print nice well formatted reports from SQL Monitor so that it can be shown to Management. I guess exporting to PDF could accomplish that.
13 votesPlease use our CSV export instead – Tools like Excel will help you visualise your results in a variety of ways
-
Click to open analysis from alert window
For some alerts, I like to see not only what happened before, but also what happened since. Some examples are disk space, or database file usage. The latter for example has a nice graph of the file usage up to the moment the alert triggered. But when I look at it the next day in the office, I also want to see what happened since - did the file continue to grow, has it been stable since, or was this a peak and is less space used now?
Currently that means going to the Analysis tab, selecting the correct server…4 votes -
Who ran the query and what time
I would like to see in sql monitor who was the person that ran the query and what time the query was run.
10 votes -
Analysis Thresholds
One of the things I like about the free PAL tool, is that you can specify thresholds for each performance counter. Therefore, you can have a customizable red line which appears on your graph to easily tell you if your disk latencies are over 25ms or your free memory is less than 5% - for example.
I would like to see something similar on the Analysis screen on SQL Monitor. I would like to specify for each machine, SQL Server or Custom metric a warning threshold and a critical threshold. This makes it easier to troubleshoot performance issues as…11 votes -
Jobs in calender formart so you can see when they are all schedualed.
It would be nice if you could see all jobs on the server. Perhaps in a calender format so that you can see when they are schedualed. It would be nice if you could drag and drop so that it changes start times. It would be nice if you could see the job history as well.
91 votes
Daniel Rothig
responded
We like the idea – if this idea gains traction, we’ll look into implementing something like this
-
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:…
5 votes -
Show a log of query activity
CONTEXT: When investigating a performance issue, I want to know what has been running
PROBLEM: SQL Monitor has rich query information on the overview screens, the performance diagnostics panels, and the query alerts, and the query trace in alert detail reports, but it's difficult to tie that information together
EXAMPLE SOLUTIONS:
- Implement a query log
- Show query information on the analysis graph45 votesThe Query executions feature in Redgate Monitor (available since 14.0.39 - documentation here) allows you to see the login, program associated with the query as well as the start/end times and CPU time, as well as various other information for sampled, as well as aborted or errored, queries.
This functionality uses extended events to sample queries over a specified time threshold of 1-5 seconds.
-
Filter Top 10 queries/waits by database
I would like to see the top 10 queries by database sometimes instead of the entire instance.
33 votes -
Block Specific Deadlocks by Lock Details
We've just updated to SQL Monitor 6. We was hoping there was a feature in this to change alert settings for Deadlocks with specific lock details rather than just all Deadklocks.
For example
we don't want email alerts on: Deadlock 'object: ReportServerTempDB.dbo.SessionLock, lock mode: Exclusive (X), index: IDX_SessionLockHowever we wish to receive emails when: Deadlock 'dbid: 6, object id: 72057594038845440, index id: (9bf78693a4b4)'
However this feature doesn't exist. Would be great to have added to an update in the near future!
42 votesThanks for this suggestion and the comments.
As previously announced, since version 8.0.22 (released November 13th, 2018) Deadlock (XE) alerts can now be filtered by database, login name & resource, and victimless (eg Exchange Event) deadlocks are excluded by default.
We are marking this as complete, but please do let us know if you have any further feedback.
Thanks,
SQL Monitor Development Team -
Use extended events instead of trace when trace initialized due to alert
I have seen a related idea https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/5717202-use-extended-events-for-deadlock-tracing-instead
However, I'm expanding this. If the SQL version is high enough the trace of current activity should be using extended events instead of a trace, this would reduce the total impact to the server performance while also expanding the available information.
98 votes
Daniel Rothig
responded
Thanks for the suggestion – we’ll monitor how popular it gets
-
Enter and assign purchased SQL licenses to VM hosts, VM or server
The new SQL licensing tab would even make it possible to detect unlicensed instances depending on listed availability or improper VM host movement rules.
6 votes -
Make software FIPS 140-2 compliant
Currently SQL Monitor is not FIPS 140-2 compliant
5 votes -
Add custom metrics to Overview(s)
Add the ability to choose what is displayed on the overview for a given server/instance - especially with the addition of custom metrics.
Even better would be to allow the addition of multiple overviews (aka Dashboards) and configure what each one displays.
25 votes
Daniel Rothig
responded
We like that idea – if it gains traction, we’ll prioritise it more
-
Group instances, not servers
For example: when I have a database cluster running multiple instances I would want have the possibility to put one instance in a development group and another instance from that same cluster in a different group. In this way managing alert settings etc on a group level becomes much more convenient.
37 votes -
Enhancement Request - Allow Redgate Monitor built-in report the option to suppress sending blank reports
When using Redgate Monitor's built-in report options.
Reports menu
-> Add a new report
-> Add Tile
-> Tile type
-> Summary Tile
-> Summary Tile
-> Logon Failures.When scheduling a report to send an email, if there are no logon failures, the report is still sent blank. It would be a great feature to have a way to suppress sending a blank report/email if there are no logon failures.
3 votes -
Add User Settings feature
Add a User Settings feature that will hold all user preferences, as different DBAs / users have different ways in using SQL Monitor. For example - (1) ability to display on the Overviews page only desired health levels (Critical, Warning, etc), or named group, or base monitor, or any combination, rather than load all servers from all groups from all base monitors. I really don't want to know that I have 265 healthy out of 275 servers - this will speed up loading of the Overviews page. (2) any other user preference.
4 votes -
Utilize SQL (or SQL-like) statements in filters.
Utilize SQL (or SQL-like) statements in the filters, specifically on the Overview tab to filter on server name. For example: '%sql%' AND '%prod%'
Currently you can only do 1 fuzzy logic search. Also, you cannot search just by one character.24 votes -
Integrate with Policy Based Management
It would be really good to integrate with Policy Based Management to raise status alerts in SQL Monitor, that way we could breakout more complex Instance status
9 votes -
Trend Analysis and Forecasting for Azure SQL Database capacity
A previous feature suggestion, https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11122308-forecast-and-plan-disk-database-capacity, was completed in 2018. However, it does not include storage for Azure SQL Databases or Elastic Pools. While we can alert on this, we get no trend analysis or forecasting.
Selecting All Disks and All Groups on the Estate | Disk usage page gets us "No disks match your filter criteria."
2 votes
- Don't see your idea?