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.
711 results found
-
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 -
Custom metrics and alerts powershell cmdlet
Could there be a cmdlet to create custom metrics and alerts using Powershell
17 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 -
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 -
track blocking processes date/time by start time, not login time
in blocking tree, it shows old date/times for queries that are running. We found that it is using the login time of the spids (which could be held and sleeping for extended amount of time) instead of the start time of the executing process of that spid.
instead of using the login time, I recommend it uses the start time of the last execution of the query found in sys.dmexecrequest1 vote -
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
6 votes -
Suppress Specific Alerts
There are some alerts that get triggered at odd hours and I would like to be able to suppress just those specific alerts for a certain time frame. I'm afraid to suppress ALL alerts because something could get missed.
1 vote -
1 vote
-
1 vote
-
Search metrics on the Analysis page to enable quick way to add them
There are a lot of metrics in different groups on the Analysis page and searching for a single metric by scrolling through the list is becoming more and more tedious. Please create a way to search for the metric.
16 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 -
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 -
Export/Import Report configurations
I'm using RedGate SQL server with different clients. Since the environments are not connected I have to manually create Report configurations for each client which takes quite some time. Also, any change to the Report configurations has to be then deployed by cilcking. Some export to XML or something similar and import wia PowerShell API would be nice.
23 votes -
Export/Import Custom metrics/alert configurations
I'm using RedGate SQL server with different clients. Since the environments are not connected I have to manually create custom metrics/alert configurations for each client which takes quite some time. Also, any change to the custom metrics/alert configurations has to be then deployed by cilcking. Some export to XML or something similar and import wia PowerShell API would be nice.
15 votes -
Overlay Alerts on the Analysis page
Please add overlay alerts and annotations on the Analysis page. This would simplify the analysis and finding correlations.
16 votes -
Show/Hide metrics on Analysis page
Please add an option to show/hide selected metrics on the Analysis page. Something similar to the Reports graph would do.
13 votes -
Save metrics used on Analysis page and enable quick way to select them from GUI
I find myself selecting the same SQL metrics when monitoring or analyzing issues.
It would be nice if I could save metrics and settings for them and next time just select them from the drop-down.19 votes -
full
see the full SQL in deadlock Area. Today with long querries you can see only part of it
1 vote -
Have filter on failed SQL Server logins alert
I would like to edit the Failed SQL Server logins alert to exclude failed logins from a value like a host/IP address. We have our security guys trying to break in our SQL servers daily and it trips the failed SQL Server logins alert all the time and over alerts us.
1 vote
- Don't see your idea?