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.
788 results found
-
Database name "like" filter for "Database Unavailable" alert
In our environment we have several systems (3rd party ETL/reporting packages) that create and drop databases as part of their normal operation.
Would be good if the "Database Unavailable" alert allowed configuring to ignore drops of database names either matching a "LIKE" filter or perhaps more advanced a regex filter.
16 votes -
Have a free-text notes field for each server\instance
A notes field can be used for any useful information such as business contacts, service hours or documentation links, etc.
16 votes -
Additional option on the Alert Suppression Windows
It would be great to have an additional option on the Alert Suppression Windows to have the ability to only stopping sending notification for new alerts and continue to send the notification for the end of alerts
I guess something like "Notification for new Alerts only (alerts will still be raised)"
The idea would be to receive the end of alert notifications for alerts that were ongoing when the alert suppression window started16 votes -
on the Query executions page add the SPID
on the query execution page for individual queries can you add the query SPID - on occasions such as blocking/stale session etc you need to find the query/last ran query by SPID rather than start/end time
16 votes -
SQL Monitor currently does not have customization on scheduling for custom metrics
SQL Monitor currently does not have customization on scheduling for custom metrics- only per min\5 min\hour basis.
the option to setup your own schedule could be given to users and setup your own frequency or metric collection.15 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 -
see the sql_handle under query details under top 10 queries
to find an execution plan in the plan cache when the plan is recreated
15 votes -
Set alert rules on specific AG nodes
Our AlwaysOn AG groups are backed up from the secondary node (the preferred node). Not Backed Up alerts still show for the primary node. We would like to be able to filter these out.
15 votes -
Include Top N Worst Performing Stored Procedures and Functions
At my organization, we do a lot of tuning at the stored procedure and function level.
I would like a tab similar to the existing top 10 queries tab, that lists the CPU utilization, memory utilization and IO consumption of the top 10 worst performing stored procedures, and another tab that lists the top 10 worst performing functions. For each of the fields I would like to see both the totals, and the percent of total during the specified time period.
This will allow us to identify the stored procedures and functions to tune, and once tuned, it will allow…
15 votes -
Exclude System Databases (and potentially other user databases) from backup alerts
We would like the ability to exclude system database from the backup alerts, as we do not back them up. We have a system in place to script out security and sql agent jobs/schedules for each of our systems nightly. We also have been leveraging the dbatools PowerShell stack as a way to automate server migrations and other automation activities. Also, our tier one systems are in availability groups. Lastly, we do not backup everything in our lower level environments, as we perform nightly database refreshes for the majority of our systems. However, we do have some testing databases that…
15 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 -
Send alert notifications at the central/parent base monitor
Context: We have a base monitor at our office connected to one or multiple base monitors at our clients environment.
Problem: Not all client base monitors are connected to the internet or opening an extra network port is a hard thing to get done. This makes it harder to setup alert notifications from that base monitor.
Desired solution: Send notification from the parent/central base monitor. This way we only have to set up notification on one central base monitor instead of multiple and use various notification types.
15 votes -
Ability to add notes to tracked queries
When working in an environment with multiple people is typical that each person is tracking different queries to analyse ongoing changes/improvements.
Being able to note something as "Tracked by Cláudio. Following FIX #1234" would be great.
It will give us a clue on who is working on what and reach out to that person. Or just keep small notes during the analyses.
15 votesA great suggestion. We are exploring this as part of a wider review into improving query tuning features.
-
Add CPU time to Individual query monitoring
Should be great if we can get CPU time column added to the new Query executions tab.
CPU time is in addition to logical reads/writes important when looking and performance of the different queries.
15 votes -
Azure Service Principal authentication (Client ID / Client Secret)
It would be highly beneficial for us if Redgate Base Monitor supported authentication via Azure Service Principals using Client ID and Client Secret across all Azure products, including Azure SQL Database and Azure SQL Managed Instance.
We are restricted to using Service Principals only and cannot rely on user-based authentication. Support for SPN authentication would allow us to fully automate the onboarding of new Azure SQL Databases and Managed Instances via Terraform, using our own modules, and register them in Redgate without any manual interaction. This would significantly improve scalability, consistency, and security in our Azure monitoring setup.
15 votes -
Alert statistics over time
I would like to see which alerts are firing more frequent over time.
It would be nice to be able to see alert statistics over time, tabluar or graphical.14 votesWe’re reviewing this and would appreciate any more context on what you would like to do with the information.
-
Capture cursor SQL for long running queries
It would be great if SQL Monitor would capture the SQL statement being executed for long-running cursors. Currently it shows "FETCH CURSORNAME001"
Cursor SQL can be found with this query when the cursor is still open:
SELECT c.sessionid,
c.cursorid,
c.properties,
c.creationtime,
c.isopen,
c.fetchstatus,
c.dormantduration,
s.logintime,
t.text
FROM sys.dmexeccursors (0) c
JOIN sys.dmexecsessions s
ON c.sessionid = s.sessionid
CROSS APPLY sys.dmexecsqltext(c.sql_handle) t14 votes -
Add an analysis metric for Total bytes sent/received over the network interfaces
There is an analysis metric that currently exists for Network Utilization, which I believe is calculated based on the total bytes sent/received over the network interfaces divided by the bandwidth of the network interface. It would be great to add the raw delta bytes/megabytes sent/received/total as a metric on the analysis and overview pages of Sql monitor.
14 votes -
Filter "Blocking Process" alert by User or Application or Database
We frequently get high-severity "Blocking process" alerts via email for a SSRS database that I'd like to ignore. We sometimes get so many alerts that the new SQL Monitor sends, "You've received more than 30 of these alerts in the past 24 hours so we're going to stop sending them for a while." Unfortunately the alerts caused by the SSRS database mean our Inbox is full of noise and we miss our important application database alerts.
Please add the ability to filter which User/Application/Database cause these alerts to be raised, similar to some other alerts that support Regular Expression filters.
14 votes -
check if there are any service packs or updates for my SQL Server instances
check if there are any service packs or updates for my SQL Server instances. This could then raise an alert to prompt me to investigate these updates.
14 votes
- Don't see your idea?