Suggestions

Welcome to the Redgate SQL Monitor feature suggestions list. Tell us how we can improve SQL Monitor by voting on these suggestions or by submitting your own ideas.

This is the easiest way to make an impact on SQL 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.

Exclude all offline data bases from the overdue backup alert as we do not have a need to backup an offline data base. For us if a data base is taken offline it's most likely because its been migrated to another server or no longer needed and will eventually be deleted.

It would be great if you could have an override on each alert to allow for a customised email setting just for that alert.
Currently an alert can have a different email address BUT it only uses the default settings, if I wanted to fine tune for that alert I can't.
Thanks, Steve

We have certain tools (mainly infosec related) that generate a lot of entries in the SQL server error log as part of their normal operation creating a lot of alerts. The only way to identify these and thereby determine that they are 'expected' is to go into each alert individually and mark it as read. The ability to ignore certain errors based on error number, severity or message would add a lot of value to this feature.

When showing more than one metric on a graph on the Analysis page, I fully understand that it is difficult to merge the units scales on the x axis. So what you get is each graph has it's 'own' x axis - and I get that - it makes sense when the units are incompatible (eg. percentage vs KB used vs batch/sec).

But when all the metrics are measure in the same units, it can create a visually confusing graph.

For example I'm looking at memory usage over time, so I've chosen Machine: memory used, SQL Server: total memory, SQL Server: target memory. On the face of it, it looks like SQL Server is using way more than target memory, and in fact more than the entire machine is using!! Only when you mouse over the graph and get the values do you see that the total memory is in fact just under target memory and fairly well below machine memory.

So I'd like it if the graph was more intelligent about this, and shared the x axis when it could. Not sure how you can handle this if there are a mixture of compatible and non-compatible metrics, but you've got some good UXers there who can bash this around!

When showing more than one metric on a graph on the Analysis page, I fully understand that it is difficult to merge the units scales on the x axis. So what you get is each graph has it's 'own' x axis - and I get that - it makes sense when the units are incompatible (eg. percentage vs KB used vs batch/sec).

But when all the metrics are measure in the same units, it can create a visually confusing graph.

For example I'm looking at memory usage over time, so I've chosen Machine: memory used, SQL Server: total memory, SQL…

When viewing an alert within the side-bar on the Overview page, clicking on the 'Go to the full details' arrow redirects the page to the intended alert. You have to then click back to see the overview page again.

It would be great for the ability to be able to open click through links on a new tab or window instead of the same window to prevent navigating away from the overview page.

We have a table in our administration database that contains usefull information for our management. This consists of multiple columns. It would be very helpfull to run a query in a tile in a report where the results of that query can be displayed. A bit like the long running query results in the reports but then with our own data from the administration database.

Would be great to offer sql monitor on a Saas model. $50 per server per month for example.
Purchasing software upfront is expensive for small/medium companies. This also offers more flexibility to add and remove licenses in line with how companies add and remove new servers.

It makes no sense for there to be Alert configuration settings for tempdb for Consistency Checks, Backups, and any other irrelevance.

If the ONLY reason for the existence of SSRS databases is because of Microsoft's idiotic requirement for SSRS to actually be configured in 2014 before permitting an in-place upgrade to 2016, there is no ACTUAL reason why one would care two hoots about the state of either SSRS DB on ANY instance affected by this "demand". OK, I have just 21 instances to drill down to SHUT UP ABOUT SSRS DATABASES!

Please provide a better way to manage SYSTEM databases (I do not regard SSRS databases as "real" USER databases, despite SQL's classification as such). I need global settings that apply to standard SQL-named databases, not the current drill down every instance paradigm that is significantly man-effort-wasteful.

It makes no sense for there to be Alert configuration settings for tempdb for Consistency Checks, Backups, and any other irrelevance.

If the ONLY reason for the existence of SSRS databases is because of Microsoft's idiotic requirement for SSRS to actually be configured in 2014 before permitting an in-place upgrade to 2016, there is no ACTUAL reason why one would care two hoots about the state of either SSRS DB on ANY instance affected by this "demand". OK, I have just 21 instances to drill down to SHUT UP ABOUT SSRS DATABASES!

When SQL instances which are in Availability Groups are being monitored, the global dashboard lists both the primary & secondary node.
However though it does have 'AG' badge but it does not say which is primary or secondary.
While looking at the SQL monitor it will key that we know upfront which is the primary instance and also when alerting it should say primary or secondary in the subject line.

CONTEXT: We have some databases with multiple filegroups, I’d be useful to be able to drill down from the DB level to the FG level on the “Total data file size” and “Total data file used” metrics.

PROBLEM: Not being able to slice totals by FG is problematic, since different FGs often have different capacity / performance requirements, different space used speed/patterns etc.

EXAMPLE SOLUTION: For “Total data file size” and “Total data file used” add an additional selector window after the database selector: a list of filegroups + an (All) option at the top. So, the selectors would be: machine->instance->DB->FG

CONTEXT: We have some databases with multiple filegroups, I’d be useful to be able to drill down from the DB level to the FG level on the “Total data file size” and “Total data file used” metrics.

PROBLEM: Not being able to slice totals by FG is problematic, since different FGs often have different capacity / performance requirements, different space used speed/patterns etc.

EXAMPLE SOLUTION: For “Total data file size” and “Total data file used” add an additional selector window after the database selector: a list of filegroups + an (All) option at the top. So, the selectors would be:…

When monitoring a vcenter deployment, it would be nice if the base monitor service could just delegate the credentials it is running as rather than entering them in the username and password boxes inside sql monitor.