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.
- or
724 results found
-
Offer integration with power bi
I've love the ability to integrate SQL monitor with Power Bi for building dashboards of analysis graphs. Since Power BI is offering a powerful way to setup dashboards with metrics users/managers care about this would be a great way to enhance many analytical report options by outsourcing the creation of those to users more and more, and offering the integration with power bi to make it easy to do.
SQL Sentry offers an integration with their cloud product to work with their metrics and Power BI in case you want to evaluate how it might be used. https://www.sqlsentry.com/Company/News-Article/20150505-power-bi-content-pack-sql-sentry
https://powerbi.microsoft.com/en-us/blog/monitoring-your-sql-sentry-data-with-power-bi/
20 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 -
Check the plan cache ad-hoc or on a schedule to report issues
implicit conversion,
scans,
lookups and the index that didn't have the columns include
missing indexes
Parameter sniffing
etc...
Report the issues based on impact number2 votes -
Login via https
Is there a configuration setting to force the SQL Monitor login page (or entire site, preferably) to https?
10 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 -
Additional parameters for filtering Long-running query alerts
Long-running query alerts
Example: Creation of ability for you to filter the queries it alerts on based on a regular expression
Source Ticket:
https://redgatesupport.zendesk.com/hc/requests/65981Possible closely related feature request:
https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11123559-triage-and-configure-repeating-alerts-more-efficie7 votes -
Configure Data Purge by Server/Instance or at least by Server group.
I would like to keep production server performance data for a month or more but the dev server data can be purged after a couple of weeks.
24 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 -
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 -
Monitor SSAS databases
I would like to be able to monitor SSAS cubes and data structures in the same fashion as SQL databases.
53 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 -
SQL Monitor self update (or one click update)
Instead of downloading and running a wizard, I would like to see a way for SQL Monitor to self update, or to have a 'one click' update button built in the interface.
29 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 -
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 -
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, this means that it would not alert on a trigger that is aimed to say that there is a long term issue
The alert we are attempting to create from this is to say that our data rate has dropped by over 25% over the past 5 minutes and has stayed there, there are 8 separate metrics from our system which would greatly benefit from this, as we had a 11 hour issue yesterday where the issue wasn't noticed, until someone manually looked at the graph 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 -
Filter disk space alerts for Quourum disks
Add a new criteria to the Disk monitoring, that allows me NOT to monitor disks that have less than X GB/MB of Total disk space.
13 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 the alert (for example trace on the medium level or higher of long running query, but not when just a low priority level)
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 -
Show a log of query activity
CONTEXT: When investigating a performance issue, I want to know what has been running
PROBLEM: SQL Monitor has rich query information on the overview screens, the performance diagnostics panels, and the query alerts, and the query trace in alert detail reports, but it's difficult to tie that information together
EXAMPLE SOLUTIONS:
- Implement a query log
- Show query information on the analysis graph45 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 vote
Daniel 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
- Don't see your idea?