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.
671 results found
-
Have a parameter for status/severity colour
when using slack notifications messages are automatically coloured red/green for failed, ended.
Like a lot of companies we're migrating to Microsoft Teams and whilst we can use the Webhook stuff to reproduce most of the slack alert for Teams we're not able to colour code the alert based on status. Having a new parameter for status-colour and severity-colour would really allow us to clean this up.
2 votes -
Have a custom message added to alerts
When an alert is emailed, I want to place an action (possibly including an html link) as a comment on the alert.
This would allow the recipient of the alert to solve the issue directly.
6 votes -
Add filtering to the Top 10 Queries/Waits lists
So first, this is a request for more general filtering than the 2 requests I see already exist for filtering by database (which I believe you can get to by clicking the database name further down the page, but would certainly be more convenient on the top 10 lists directly).
The primary use case that I was looking to do but couldn't was sort by averages, but set a minimum execution count. The goal being to find my worst queries that are not just one off things that aren't likely to be repeated. I think there would be a LOT…
9 votes -
Have the option to capture parameters from queries
Presumably this would require having the trace enabled and you wouldn't necessarily want to be capturing every parameter on every query so there probably needs to be some logic around choosing what to keep. This would obviously help track down parameter sniffing problems along with other troubleshooting of the exact scenario you are trying to look at.
This is different from the suggestion listed here:
https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/41237467-display-parameter-list-in-the-query-plan-form(And that one should also be implemented and would be a valuable time saver)
8 votes -
Activate the alert suppression on a database level
In our production environments we'd like to be able to suppress all alerting on a database level.
For instance, if a database is to be retired, it will go into an automatic offline state for 2 weeks before it's actually deleted. During this period SQL Monitor keeps returning with a High Alert level warning that the database is not available.
Yes it's possible to manually disable this alert just for this database. However if we want automatic ticketing to kick in on this alert type we'd need to able to create a maintenance window before hand in order to prevent…7 votes -
Overviews Alert Severity Colours
When I go to the overviews page the servers have different alert levels represented by a colour and a symbol. I would like the choice of colours to be easier to identify for colour blind people, so the healthy, low and medium have colours that are almost identical to colour blind people as the contrast is so similar: https://personal.utdallas.edu/~melacy/pages/2D_Design/Itten_ColorContrasts/ColorWheel02.png
2 votes -
Customize alerts at the host level in a windows cluster
Currently you cant customize host level alerts at the host level only at the windows cluster level.
A few scenarios where this is needed :-
Always-on cluster where one node is for the application and you have a read-only secondary for reporting. I need to be alerted for the application node for high CPU, but the report server is usually often hits 100% CPU during business hours.
Multi node regular failover cluster with different application owners. 3 nodes, app1 lives on node1, app2 lives on node2, node 3 is a passive node for both. Alerts for app1 need to go…
6 votes -
Monitor SQL Server Analysis Services
It would be really nice if we could monitor SSAS Instances with the SQL Monitor.
7 votes -
Integrate query store with monitor to find regressed queries
Query store already tracks regressed queries. Integrating this into the monitor and having the ability to alert on this would be extremely useful in having early notifications on when a query goes bad before application or system issues come up
5 votes -
Shorten the focus window from 15mins to 1min
I want to be able to apply a shorter timescale to the focus window, 15mins is far too long on a very busy system.
I would like to be able to put a start / end date/time instead of selecting a time and then x hours before that
4 votes -
Add Database Filtered in Top 10 Queries\Wait Section
Can you Add Database Filtered in Top 10 Queries\ Wait Section.
We have more than 500 databases in instance . If you add Databases filtered than we will very helpful.5 votes -
Control the delay before getting "Error on Base Monitor"
We have perhaps a unique use case where one of our Base Monitors is at a remote site with a very high latency (700+ ms). Monitoring works surprisingly well since one of the later updates but unfortunately we are getting regular “Error on Base Monitor” emails (10+ per day) even though the connection itself is stable (just very slow).
We would like to be able to control the delay before that error is raised, I’m guessing that slightly increasing this "timeout" would fix all our issues.3 votes -
Trace schedule
Could the new "Trace" feature have a schedule as well as an on/off? If not this then how about a third option "Trace until date/time"?
Thanks
6 votes -
Easily identify which base monitor is hosting a monitored SQL Server host
In a multi-base monitor configuration it is a bit cumbersome to identify which base monitor is hosting a given entry on the overview page. Yes, one can search all the SQL Server host machines on each base host, but that takes time. It would be better to have an entry in overviews that identifies where it is hosted.
5 votes -
Availability Group alert details
It would be great to see the server name in the mail body which is affected by the alert. Currently it is only in the subject. EG: Raised on detail i the mail body contains the primary replica, the affected unreachable replica is only in the subject.
1 vote -
I use SQL Monitor every day and use the failure reports for SQL Agent jobs, it is most useful. However, when there is an issue with an SSIS
I use SQL Monitor every day and use the failure reports for SQL Agent jobs, it is most useful. However, when there is an issue with an SSIS package that is automated via SQL Agent I have to leave SQL Monitor and go to SSMS. It would be really handy if SQL Monitor could read the SSIS errors. Is this something that is in the road map or could be put in please? Thanks.
13 votes -
Configure Different Emails for alert levels
Allow for customization of emails for alerts at each alert level, so that I can send to different emails for each alert level.
So that I can send High alerts to one email address, medium alerts to another email address, etc…
57 votes -
Add the ability to optionally fire a data gathering query if an alert fires
For example, https://sqlmonitormetrics.red-gate.com/suspiciouserrors/ (Detect Suspicious Errors Typical of a SQL Injection Attack)...
If suspicious activity crosses a threshold, it throws an alert. Great. Now what? I have an alert but no data to investigate without opening SSMS (or tool of choice) and running a query like this (I’m sure there are better ways but this works for an example)
SELECT CAST(targetdata asxml) AS targetdata
INTO #SuspiciousErrors
FROM sys.dmxesessiontargets xet
JOIN sys.dmxesessions xes ON xes.address=xet.eventsessionaddress
WHERE xes.name='MonitorSuspiciousErrors'
AND xet.targetname ='ringbuffer';SELECT
dateadd(mi,datediff(mi,getutcdate(),getdate()),xed.eventdata.value('(@timestamp)[1]','datetime2'))AS EventTime
, xed.eventdata.value('(data[@name="errornumber"]/value)[1]','int')AS ErrorNum
, xed.event…2 votes -
sql estate email out option
It would be great if you could set up an email routine to email out reports from the Estate tab. E.g. the backups tab would be useful to email out an export of the screen.
2 votes -
Different email addresses for different thresholds
Although you can specify different thresholds for High, Medium and Low alerts, they all end up at the same email address or slack channel. It would be useful to be able to change this so highs went to one address, mediums to another etc.
31 votes
- Don't see your idea?