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.
791 results found
-
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.
26 votes -
Custom metrics and alerts powershell cmdlet
Could there be a cmdlet to create custom metrics and alerts using Powershell
26 votes -
Add custom metrics to Overview(s)
Add the ability to choose what is displayed on the overview for a given server/instance - especially with the addition of custom metrics.
Even better would be to allow the addition of multiple overviews (aka Dashboards) and configure what each one displays.
25 votes
Daniel Rothig
responded
We like that idea – if it gains traction, we’ll prioritise it more
-
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.
25 votes -
Add waits, CPU, & IO to the "sort by" options on the Global Dashboard.
Currently there are only two choices to sort by for the Global Dashboard screen:
Name & Severity
It would be nice to add more options, as they are displayed in the tile view. The options of course would be waits, CPU, & IO.
25 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 -
Utilize SQL (or SQL-like) statements in filters.
Utilize SQL (or SQL-like) statements in the filters, specifically on the Overview tab to filter on server name. For example: '%sql%' AND '%prod%'
Currently you can only do 1 fuzzy logic search. Also, you cannot search just by one character.24 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 -
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 -
Service Level Agreement Metric Report
The following contract metrics are common to many US Government clients. It would be very helpful (and a real time-saver) if SQL Monitor had report that could provide the below listed SLA's in a monthly email to an editable distribution. The report should be .pdf or .xlsx format, with layout intended to communicate to executive audiences. The setup for the report should allow comparing baseline dates. Thanks in advance for considering this idea.
- List of database instances
- Database uptime
- Components that are reaching capacity
- Computer resources growth
- Reserve capacity
- Throughput I/O
23 votes -
Export options for "Head Blocker" diagram
The "Overviews | BLOCKING PROCESSES (TOP 10 BY TIME)" shows a really nice chart of the blocking chain. It would be useful if this could be exported to an image file and/or a CSV.
22 votes -
exclude databases from alerts with a named pattern
Some of our databases are named "XXX_Database", the "XXX" indicating that it should not be monitored. It would be nice to exclude those from alerts based on a given naming pattern.
22 votes -
Total data file size/used metrics - add filegroup level
CONTEXT: We have some databases with multiple filegroups, I’d be useful to be able to drill down from the DB level to the FG level on the “Total data file size” and “Total data file used” metrics.
PROBLEM: Not being able to slice totals by FG is problematic, since different FGs often have different capacity / performance requirements, different space used speed/patterns etc.
EXAMPLE SOLUTION: For “Total data file size” and “Total data file used” add an additional selector window after the database selector: a list of filegroups + an (All) option at the top. So, the selectors would be:…
21 votes -
Use error messages from SSIS catalogue
When a job fails, which is run from SSIS Catalogue, then the error message is basically "look in SSIS Catalogue", which is not very useful. I suggest using the error message from the [SSISDB].[catalog].[event_messages] view instead for these cases.
In our home made monitoring system we're checking the subsystem in sysjobsteps, then use the command from there to identify the dtsx package name and looking up the latest message from [SSISDB].[catalog].[event_messages] for that package for the error message.
21 votes -
Custom disk alerts in a cluster is lost when instance is moved to a new host
We often use customized disk alerts for larger disks i.e. instead of using the default alerts we might configure a High alert at 200 GB and a medium at 250 GB.
These custom alerts is not set on the instance level so when we move the instance to a new host the custom alerts will not follow the instance and the alert has to be set up again.
As our largest cluster is 9 node cluster with 23 instances and 3 disk each this cause us to configure these alerts at a maximum of 621 instead of 69 times. That…
21 votes -
Add Key Lookups to the SQL Server metrics
Though Page Splits and Full scans are useful metrics for index's, key lookups can be handy in finding areas where covering indexes are required and have been helpful in seeing where there is a regressed query from a bad plan - this would be a handy metric to have within the SQL Server metrics part of the main dashboard next to the other 2 mentioned.
21 votes -
Include instance-specific name (@@SERVERNAME) on alert mails
The alert mails for a SQL Server cluster contain the cluster name but not the actual instance virtual name. It would be nice if the mails contained the actual virtual name (as given by "select @@servername") so that the email contained all the details needed to connect to an alerting instance.
My cluster name (i.e. CLUST01) is a different IP than my virtual names (i.e. VIRTUALSQL01), which means that I can't connect to my "FOO" instance by "CLUST01\FOO" as the alert email seems to indicate. Instead I need to connect via "VIRTUALSQL01\FOO" which is not present anywhere in the alert…
20 votes -
Allow custom metrics to be optionally created as "event" alerts rather than default "continuous" alerts.
I have installed the "Used/available database space increased alert" which alerts when defined thresholds of used space have been exceeded. However, once activated, the alert remains in an active state with no additional notifications (easily missed). I'd prefer to have this metric run daily and notify each time a threshold is exceeded.
20 votes -
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 -
Filter Longest Running Queries Tile by Database
The Longest Running Queries Tile on the Reports screen would be more useful if we could target only one database.
20 votes
- Don't see your idea?