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 — 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 Redgate Monitor forum.
683 results found
-
Re-fire alert notification if alert stays active
My initial problem was that an alert that was still active was marked as cleared, but I wanted the alert to 're-appear' as essentially it hadn't been fixed.
This then led me to thinking about any alerts that can move from Active to Ended. It would be useful to configure these is such a way that if they stay Active for a given period, then they re-fire. I understand that is what the multiple thresholds can be used for (especially if the thresholds define time periods) but in this case I may already be at High, there is no further…
28 votes -
Be able to customize sql agent job failure notifications turn on/off at the specific sql agent job level
Be able to customize sql agent job failure notifications turn on/off at the specific sql agent job level.
7 votes -
Comments in alerts list
Show the comments or at least the first 50 symbols of a comments in the Alerts list.
8 votes -
Exclude offline databases from backup alerts
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.
23 votes -
save list of top 10 queries to excel
I would like to be able to save the list of top 10 queries to excel to deliver to developers in different sort orders
7 votes -
Support for showing multiple metrics with the same units on Analysis Graph
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…
26 votes -
Save the deadlock graph as pdf
I would like to be able to save the deadlock graph as pdf or maybe be able to send the page as an email
6 votes -
ssis
SQL Monitor currently does not monitor the execution of SSIS Packages.
It would be extremely useful if SQL Monitor would monitor the execution of the SSIS packages like it does the execution of SQL Jobs
E.g.
Alert if the SSIS Package Execution Fails
Alert if the SSIS Package is taking longer than normal to Execution
Alert if the SSIS Package fails to start41 votes -
Run a custom SQL script when an alert is raised
We use SQL monitor very heavily for our SQL and application monitoring, what we would like is for each alert to be able to define a custom sql script to run when the alert is raised, the output of this sql should be included in the alert.
This would allow us to do things like capture whoisactive when blocking occurs or other application specific things and make responding to alerts MUCH easier.
60 votes -
upgrade without reentering credentials
When you run an upgrade, there should be an option that just uses the current service credentials (i.e. leaves everything as is) instead of having to re-enter them.
60 votes -
Allow custom metrics to only run on primary node of an AG
Allow configuration of a custom metric to only run on the primary node of an availability group.
14 votes -
I would like to see PROCESSES TOP 10 BY Memory.
I would like to see PROCESSES TOP 10 BY Memory.
13 votes -
Add exclusions to Job Failing alerts
When a user deliberately stops a job while it's running, it fires a job failed alert. Add exclusion regex so we can add something like "The job was stopped prior to completion by User...." to ignore these.
14 votes -
Just like you can configure multiple alert thresholds for: JOB DURATION UNUSUAL ALERT you should be able to do so for: JOB FAILING ALERT
This would allow notifications for failed jobs to be sent to different functional recipient(s) (e.g. Dev vs. Support vs. Ops teams) based on key words and other criteria.
2 votes -
Enable extended events per server
Currently, enabling the use of extended events is a global setting.
It would be great if this could be enabled per server, to avoid well-documented issues (https://support.microsoft.com/en-us/help/2878139/fix-using-dbghelp-dll-version-4-0-5-error-is-logged-in-sql-server-2012) between extended events and older versions of SQL Server (namely SQL 2008 which is still in extended support until 2019)
15 votes -
Monitor Log Shipping
SQL Monitor should be able to give me metrics on log shipping latency for native or SQL Backup Pro Backups
3 votes -
Notification Profiles
It would be nice to have different notification profiles. For example, I'd like to have a notification profile for business hours vs. after hours.
For business hours, I'd like to be notified when certain alerts happen, but during after hours, I would only like to know about if there is a system down issues.It would be nice to have some kind of alert escalation system like this. So if I want certain alerts to alert me only when the High threshold has been reached after hours, but any other alerts during business hours.
24 votes -
Exclude queries from top 10 queries
I would like to be able to exclude specific queries from Top 10 Queries. We use SQLQueryNotificationService which means our top 10 queries based on duration are always showing these queries as they have a waitfor. I would like the ability to exclude items from the top 10 queries.
Typical query I would like to able to exclude:
WAITFOR(RECEIVE TOP (1) messagetypename, conversationhandle, cast(messagebody AS XML) as message_body from [SqlQueryNotificationService-07e6439b-8276-45aa-963f-bed011b3ef2f]), TIMEOUT @p2177 votes -
Long Running Query Duration for Specific Queries
It would be really useful is this feature came into Live!
We have a number of queries that run on our SQL servers. We are aware these normally run for a long period of time (5-10 minutes) and do not want to exclude these from being alerted to us. Rather than changing the Long Running Query threshold for all the queries within the server we would like to be able to do it for these specific queries that take that little bit longer than others.
23 votes -
scroll through the overview graph and zoom in/out
It would be a lot easier if we could scroll through the overview graph and zoom in/out. For instance, on Monday morning I need to inspect a long (2 to 3 day) ETL job with 4 main parts. Currently I have to select the last timestamp I like to see in the graph and then select "Last 2 days". Then I can drag the sliders to highlight the area I want to investigate.
It would be easier to click the graph and drag it left/right and use the mouse wheel to zoom in/out
1 vote
- Don't see your idea?