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.
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 — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!
If you have any questions visit the SQL Monitor forum.
-
Have more retention periods for the data retention settings.
Right now on the data retention settings screen, there is only a drop down with a static list of ranges to keep data. It would be useful if these could be more granular, like being able to set both the number and interval (month,day,year). At a minimum, it would be nice if there were options between 1 year and indefinitely.
5 votes -
Provide AAD authentication mode to connect to Azure SQL server apart from username and password authentication.
Provide AAD authentication mode to connect to Azure SQL server apart from username and password authentication.
Because if Azure SQL is set to AAD authentication only for security reasons in any organization, username and password to add new Azure SQL server/DB under SQL Monitoring doesn't help.
17 votes -
Add Query Impact metrics into analysis graphs
Add the ability to report on Query Impact metric in the analysis section to monitor trends.
3 votes -
azure overview
Azure SQL databases display differently than SQL server databases on the overview page, which makes them difficult to see. And even with the Azure SQL databases, there are further differences if the databases are members of elastic pools or not.
Please change the Overview Page to either a) show them more consistently, since there's no other indication of what's different.
or b) rearchitect the way Azure SQL DBs are displayed on the overview page so it's clear they are Azure SQL and that would also give you the ability to show them whatever way makes the most sense for the…3 votes -
To show top server Process memory usage
Under the "Processes", it would that we can sort the top memory usage as well. There are times we got alert that the server memory usage is high and we need to know what other OS processes is utilizing the server memory other than SQL.
1 vote -
"Take Screenshot" Feature in Analysis Section
I have the need very often to take screenshots for non-technical management slideshows.
Could you add a button in the analysis panel to take a screenshot of the analysis timeline?
I would like to obtain something like this (with a single click)
https://images4.imagebam.com/c4/e9/b5/MEC1R73_o.png
Thank you
1 vote -
proxy use
We have internet access through proxy. I need SQL Monitor to work through this. for example download latest update
1 vote -
can use proxy
We have internet access through proxy. I need SQL Monitor to work through this. for example download latest update
1 vote -
Have option to keep the base instance name in display for availability groups
We have the option to choose between Windows cluster name and FCI network name for FCI. However, in an Availability Group scenario, every instance is being show by the cluster name first, which is obviously the same for all of them. This makes it difficult to identify the correct one when you need to look at a specific instance. Would like to add this as a configuration option so that clustered AG servers we can also choose whether to use cluster name or instance name as display
3 votes -
Geeting listener name in AG info
Would it be possible to get the SQL Server AlwaysOn AG listener name in the SQL Monitor dashboard?
3 votes -
Add alias with powershell module
We install our sql server automatically via powershell, so we also add them there to the monitoring. We would like to safe us work, by giving the server a custom alias while adding to the monitoring as it can be done through the website.
6 votes -
Increase SQL Monitor email Alerts to larger than 400 KB
We have some alerts for important servers that require you to login to SQL Monitor to see the full details because they exceed 400 KB. The alert currently reads:
"Details
Details omitted because they exceeded 400KB. Please log into SQL Monitor to view them.
View full alert details
Configure alert"Please increase this value so that we can see the full alert details within an email instead of having to login to SQL Monitor to see them.
Thank-you!
3 votes -
Create a threshold for how many times a job can fail before raising an alert.
We have jobs that fire every minute, or every 5 minutes - similar to heartbeat jobs. If the job fails once or twice, we don't care. If it fails 10 times in a row we do care.
10 votes -
For the "Job failing" alert, add the ability to exclude job categories
The "Job failing" alert currently has the ability to exclude jobs based on job name and owner. It would be very useful to also have the ability to exclude jobs based on the Agent Job Category.
2 votes -
Update the password of the account with powershell module
I do not want to use the base monitoring account, to monitor the different databases. So I need to use a separate account for that. In order to regularly be able to rotate the password of this account, I would need the PowerShell module be updated with a function to update the password.
3 votes -
Data Export
Export the top querys list with detail as excel file or can be mail to another person.
1 vote -
Select custom date range in Estate - SQL Agent Jobs
Would like to be able to view SQL Agent Jobs between dates. Currently you can pick from Day - Week - Month but it would be really good to have "Custom" also which allows you to select start and end date.
44 votes -
Disk space alert
The disk space alert can be configured on Server-Level as a host machine alert, but the alert is fired for every Instance on that host.
As example, we have 5 instances on a sever, each instance has it's own drive, e.g.
instance1 on drive d:
instance2 on drive e:
instance3 on drive f:
etc.If one instance, e.g. instance2 on drive e: is filling up it disk, the alert is fired for all instances. We would like to see an alert only for the instance that is affected and not 5 alerts.
1 vote -
Fragmented Indexes
Would like to add row count and fill factor to the alert as depending on how many rows there are depends on whether a reaction is needed
Fragmented indexes:
Index Table name Fragmentation(%) No. of pages1 vote -
Central configuration of child base monitors from the parent/central base monitor
Context: We have a base monitor at our office connected to one or multiple base monitors at our clients environment.
Problem: To configure the base monitor at our clients location, we need to connect to that base monitor. In order for us to reach that base monitor we have a to connect through multiple VPN's and steppingstones, which makes a simple click a time consuming action for us.
Desired solution: We want to be able to configure a child base monitor from our central base monitor at our office. For example adding a member tot a group or check on…
19 votesWe will soon be exploring how to make it easier to configure multiple base monitors.
- Don't see your idea?