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.
663 results found
-
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
6 votes -
View stats for queries across databases and / or servers
Given that one has multiple similar databases, recieving the same queries, having same indexes and so forth. Currently one are able to view top-queries on server and database level, but what would be very valuable is to see the same information across databases on a server and across servers where one would then match the query on a content of the query itself. Then one could pinpoint globally what queries that has high io / cpu / ... even tough they on a individual db-level is not "high"
1 vote -
Create smaller timeframes on the server overview page.
Currently if you dive into the overview page of a certain server the default timeframe is 24 hours, you can narrow this into 12,6,3 and 1 hour.
I would like to have the opportunity to narrow it down into minutes.like a custom time frame. This helps to do a more clean investigation.
3 votes -
Monitor Partitioned Tables in SQL Server
Be able to monitor and alert on sql paritioned tables. Such as if a retention of a table is 30 days and it retains data greater then 30 days, I should be able to get an alert. Be able to get alert on things like if older partitions are not merging or new partitions are not splitting or data being stuck in one partition...etc Able to see growth and changes in the partitions...
3 votes -
Remember the Filter Layout
On the Alert Inbox it would be nice to be able to re-arrange the filters and for the options to be remembered no matter where I login.
1 vote -
Exclude serverless databases from monitoring
Need the ability to exclude serverless databases from scanning. The purpose of using serverless is to suspend when not in use, drastically reducing costs. Currently these databases are "kept awake" by SQL Monitor and never go to sleep. This is a deal-breaker for use on some of our servers...
3 votes -
SQL Monitor to Authenticate Directly with Office 365, Exchange Online
Hello, it would be great if SQL Monitor could authenticate directly with Office 365 rather than having to use an on-premises SMTP server. Exchange Online is probably the most widely used email service for business and the application is unable to successfully authenticate with it. Thanks.
3 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 -
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.
16 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 -
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.
85 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 -
Webhook notification for HIGH only or High/Medium only
Just like you can do with email notifications, would like the ability to send WebHook notifications for only HIGH, or ONLY HIGH and MEDIUM alerts.
6 votes -
Data Export
Export the top querys list with detail as excel file or can be mail to another person.
1 vote -
save monitoring data of a specific day
When having performance related issues on environments we'd like to be able to "save" the data of a specific day or days in order to do a proper root cause analysis, even over a longer period of time.
Due to aggregation of data we're now seeing issues arise that after a certain period we're no longer able to access detailed monitoring data of that day through SQL Monitor. Being able to access this data in SQL Monitor helps us correlate this data against other monitoring systems even after aggregation.
Our suggestion would be to add a save button for a…4 votes
- Don't see your idea?