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.
710 results found
-
allow more configuration options for the 'Job duration unusual' alert
The 'Job duration unusual' alert is based off of the last ten runs of a job. I think allowing a configurable number of runs to be a baseline or better yet, the last x runs at the same time of day would be ideal.
36 votes -
Have audible alerts on SQL Monitor
It would be very helpful to have a configuration setting to make alerts audible (something like a beep or alarm ring). In the office we have a screen that displays the SQL Monitor where the alerts are only noticed when people look at the screen, which is not very often.
An audible alert of 'red' alerts would prompt us to action them straight the way.
32 votes -
Monitor if all SQL Server related Windows services are running, especially Redgate SQL Backup Agent.
I have found that backup jobs fail, due to SQL Backup service not running. Knowing that the service has stopped would be a great metric to have. This could then be extended to monitor other Windows services.
9 votes -
SQL Monitore: I would like to see the response time I/O of database files.
SQL Monitore: I would like to see the response time I/O of database files. Currently it is showing only on instance level but how can I see response time of a particular
database.11 votes -
I only have one SQL Server, take me to the instance Overview instead of global dashboard
I only have one SQL Server instance, instead of seeing one small bit of info and having to click that in the new global dashboard, take me directly into the instance so I can get relevant info on first login/site visit. Think about your design when we just have one server.
5 votes -
Group / Sort custom metrics
We have a lot of custom metrics and the current interface is not robust, being able to group / sort metrics in folders or in a tree would be very useful. Also the selection box in the analysis tab is not large enough to navigate a useful number of custom metrics
5 votes -
Baseline machine metrics across cluster failovers
CONTEXT: Using the Analysis graph for historical performance analysis of machine metrics on a cluster that failed over at least once
PROBLEM: Machine metrics are collected per node. Baselines of only one node can be shown at a time, and so no baseline view of performance on the "active" component can be synthesised.
EXAMPLE SOLUTIONS:
• Enable multiple simultaneous baselines
• Implement synthetic (bimodal) baselines across cluster nodes
• Provide synthetic metrics for entites on the "active" component of a clusterWhat do you think about these solutions? Got another idea? Let us know in the comments!
18 votes -
Jobs in calender formart so you can see when they are all schedualed.
It would be nice if you could see all jobs on the server. Perhaps in a calender format so that you can see when they are schedualed. It would be nice if you could drag and drop so that it changes start times. It would be nice if you could see the job history as well.
83 votes
Daniel Rothig
responded
We like the idea – if this idea gains traction, we’ll look into implementing something like this
-
add the table schema to alerts
On that alert (fragmented index), you see a table name. It would be helpful to see the schema to which that table belongs.
Medium Fragmented indexes
Raised on: XXXXXXXX > RedGateMonitor
Time raised: 26 Jun 2016 1:00 AM (UTC-04)
Details
Database name: RedGateMonitorTotal number of indexes: 332
Indexes above fragmentation threshold: 3Indexes last checked: 26 Jun 2016 1:00 AM
Fragmented indexes:
Index Table name Fragmentation(%) No. of pages
ClusterSqlServerServerWaitsUnstableSamplesIdCollectionDate ClusterSqlServerServerWaitsUnstableSamples 96 1175
ClusterSqlServerSqlProcessUnstableSamplesIdCollectionDate ClusterSqlServerSqlProcessUnstableSamples 96 3288
ClusterSqlServerTopQueriesUnstableSamplesIdCollectionDate ClusterSqlServerTopQueriesUnstableSamples 99 17581 vote -
I wish the mouse wheel did not automatically modify the date scale in the Analysis graph.
I can't count the number of times I have unintentionally messed up a graph with the mouse wheel. It is quite annoying to me.
6 votes -
Alert Stats on the new Cards
Those new cards look very nice, BUT, they do not show anything about the alerts raised on the instance!
That's a shocking omission, IMO.
Please add something that shows the alerts, like the old Overview page did, like counts by severity, with colors!
3 votes -
Click on CPU part of the server block on global dashboard (version 5.2) leads me to serveroverview instead of graph
I would suspect to go to the graph (analysis tab) after I click on the CPU part of a serverblock (in Global Dashboard), instead of the server overview
1 vote -
Develop SQL Server Agent Job Status Alert
Add a new SQL Server Agent alert to monitor the status of a job. The ability to alert when a job is running longer than a specified time or has not run within a specified time. The current alert will only notify you after the job has stopped. This does not help when a job is hung.
12 votes -
allow analysis graphs to update with realtime data without having to manually refresh them
We have SQLmonitor analysis graphs running on wallboards to show us data that is useful to us, but we continually need to click the button to "jump to present", as the timeline does not update as more data is collected to show the most recent history. We want the graph to move automatically to match the current time of day.
Maybe a "play" button that would allow thye display to automatically refresh the graph along the timeline and a pause button should you want to drill deeper into a certain time period when investigating issues. Having the graph update automatically…19 votes -
Save and Export/Import sql monitor settings
Setting up custom alerts and servers is quite a bit of work. For example some jobs are more important than others. A different set of people get notified for some jobs. I have setup custom alert settings on many of the jobs this way. recently I had to move monitoring host to a different server and replicating same settings took me a lot of time. hence need ability to be able to export settings from one server and import to another. May be this will work through the monitoring database but I had to change the database from 2008 to…
65 votes -
Quick view of whether Agent is up on all monitored servers
If I go to the Configuration > Monitored servers tab, I can quickly see if all SQL Servers are up and running. It would be nice to also be able to quickly see if all SQL Server Agent services are up and running.
3 votes -
Allow trace to be set at the individual alert level and severity
SQL Trace can highly impact the performance of the server. I can't benefit from trace right now as it's set on any alert to launch a trace.
Other monitoring tools, for instance Sql Sentry, allow the individual alert to be configured with settings for trace.
For example: A long running job might benefit from a trace, while a "dbcc checkdb " hasn't been run in a long time should not trigger a trace. This increases storage and server load for no benefit.
Please look into allowing traces to be configured based on the alert AND the severity level defined on…
6 votes -
Control Alerts Using Metadata
CONTEXT: We have a maintenance and backup solution which uses SQL Server as a backend to determine what databases to perform the tasks against, and at what time.
PROBLEM: Some databases do not have maintenance tasks running against them, but still have alerts which appear in SQL Monitor for them (e.g. Index Fragmentation). I don't want to manually exclude these from SQL Monitor, as the number of databases fluctuates, particularly on our testing and development environments.
EXAMPLE SOLUTIONS:
- Provide a means of easily enabling/disabling/changing alerts dynamically using a stored procedure.1 voteDaniel Rothig
responded
For your usecase I recommend modifying the maintenance window metadata instead:
UPDATE s SET MW_IsEnabled = 1, —or 0 to enable alerts again MW_Start=0, —midnight MW_Duration=864000000000, —24 hours MW_Monday = 1, MW_Tuesday =1, MW_Wednesday=1, MW_Thursday=1, MW_Friday=1, MW_Saturday=1, MW_Sunday=1 FROM [settings].[SqlServers] s INNER JOIN [settings].[Clusters] c ON c.Id = s.ParentId WHERE c.Name = ‘hostname’ AND s.Name = ’’ —Set to SQL Server name or leave empty for unnamed instancesA restart of the base monitor service will be required after the change
-
Alert based upon trend data
We want to be able to alert when a value changes dramatically over a period of time. so if a system returns 110,105,112,40,38,52
to eye ball that on a graph I can see there is a problem, however that may be at the peak time of the day and 38 might be a reasonable value for in the middle of the night, so having a threshold of a low value is not appropriate, the comparison mode of query for this situation would report a change of
-5,+7,-72,-2,+14in here there is one large drop but then it is running stable,…
3 votes -
Add alerting for replication performance
Include an alert to monitor replication performance. i.e based on the latency reading that you can view in Replication Monitor. The counters for this are "SQL Server Replication LogReader: Delivery Latency" and "SQL Server Replication Dist.: Delivery Latency". I'd like to be able to set the alert priority based on this.
75 votes
- Don't see your idea?