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
-
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 -
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 -
Identify and alert on heap fragmentation
Currently SQL Monitor does not have a way to identify and alert on heap fragmentation. I suggest you add this to the product.
I know having a heap is usually a bad idea and that heap maintenance is a pain (rebuilding a heap also rebuilds all the nonclustered indexes on it, SQL Server doesn't release a page of a heap table, and doesn't use free space in previously used pages unless you are doing deletes with TABLOCK hints), but there are some valid use cases for heaps.
14 votes -
I would like to be able to export/import all of my custom metrics that i have configured in my SQL Monitor. Is this at all possible?
We are migrating our SQL Monitor to a new server and i would like to avoid having to manually recreate all the custom metrics we have configured. Any suggestions would be most welcome.
14 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 -
Analysis graph exclude set times over long time range such as 28 days
It would be great to be able to set exclusion times such as the "maintenance windows" when index maintenance activities take place such as every day between 12pm-2am in our case. During these times disk queue length will be predictably high due to the maintenance activities taking place.
When viewing graph analysis for a 28 day period for disk queue length you see peaks which are from the maintenance activities and these events end up skewing the overview of BAU activity.
It would be great to be able to define an "exclusion time window" in the analysis report window to…14 votes -
Group sql server instances at the instance level, not at the server/cluster level
I would like to control the group that an individual sql server instance is in, rather then having to group things at the server/cluster level. The group views and control over alerting is great, but in the event that the same cluster/server hosts a dev and production instance, or multiple instances that are managed by different members of a DBA team,the usefulness really suffers.
14 votes -
Add support for Windows Server Core
Server Core has a lower attack surface, uses less RAM and disk space and is the default way to install Windows Server
14 votes -
Add counter [forwarded_record_count] to Analysis page
As you describe in this article: https://www.red-gate.com/simple-talk/sql/database-administration/sql-server-heaps-and-their-fragmentation/
forwarded-record-count From sys.dm-db-index-physical-stats
Please add forwarded-record-count to Analysis page
Thanks guys!
14 votes -
Activity monitoring for DDL & DML
Add an element that will track all DML/DDL activity within a SQL Server instance and log this to a tamper proof archive. If linked to performance trends this can corrolate performance to T-SQL executed against the instance.
This has scope for aiding with Compliance with PCI-DSS & SoX.
13 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
- Don't see your idea?