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
747 results found
-
date format
I'd like to have an ability to set date format according to the country where the monitored SQL server is in, e.g. USA where date format is MM/dd/yyyy vs UK as dd/MM/yyyy. Also, why not to read and set date format off of the monitored server? Please make it configurable and country compliant so to speak..
Thanks,
Yuriy4 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 -
be able to extract all alerts at once rather than extracting for individual alerts via API
Redgate Monitor API currently allows users to extract alert details for individual alert types. We need an API endpoint that can extract alert details for all alert types instead of calling the API multiple times.
10 votes -
Should have feedback on missing index, its great know that I have a slow running query but some possible hints on how to improve them.
Should have feedback on missing index, its great know that I have a slow running query but some possible hints on how to improve them,
the infomation is avalible in SQLServer version 2005 onward in the following DMV
sys.dmdbmissingindexdetails
sys.dmdbmissingindexgroupstats
sys.dmdbmissingindexgroups
sys.dmdbmissingindex_columnsSo I still have to go off and check.
Overtime as database grow in size and data distribution of the tables changes therefore indexing requirements change, so unless you monitor these DMV's you may not notice that an index may be…34 votesThe missing indexes DMVs are not an exact science, so we’ve decided against presenting sometimes-helpful, sometimes-disasterous tuning advice in SQL Monitor.
However I’m confident that SQL Server itself will continue to evolve as a tuning platform, leaving SQL Monitor free to look at the bigger picture.
-
Support Individual query monitoring in Azure SQL Database
This sounds like a useful feature. I wish it was available for my environment.
7 votes -
Have a standard metric for Data space used
There is currently an out of the box metric or Log Space Used, but there isn't an equivalent Data Space Used.
I get that it's a bit trickier if you have multiple data files, (even just adding them up as one metric). We have databases that we want to pro-actively allocate space for but it's hard to do without a metric to tell us when it's getting full.
8 votes -
Support for showing multiple metrics with the same units on Analysis Graph
When showing more than one metric on a graph on the Analysis page, I fully understand that it is difficult to merge the units scales on the x axis. So what you get is each graph has it's 'own' x axis - and I get that - it makes sense when the units are incompatible (eg. percentage vs KB used vs batch/sec).
But when all the metrics are measure in the same units, it can create a visually confusing graph.
For example I'm looking at memory usage over time, so I've chosen Machine: memory used, SQL Server: total memory,…
29 votesFixed in version 14.1.0
-
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 -
Define limit of the specific job alert.
problem : a job is running in every 2 mins and failed due to any reason .it will fire multiple alert ,I would like to restrict the limit of the specific failure
solution :as we work in the shifts , I want it should not come more then 3 time which is in 8-9 hours duration .when I am setting the limit then it will impact to all server not the specific one . whereas I would like to check this monitor based on the time and then fire the alert
3 votes -
Configure Alert-Ended messages at alert type level
in the global settings I can configure, that I want to receive deescalation mails when an alert ended (e.g. CPU went back to normal, Server available again ...).
For many alerts this makes sense, but for other alerts not so much or not for everybody (e.g. deadlock alerts, the custom failed-logins alert, job-failed alerts...).
So it would be nice, if I could configure this (as most other options) at least at alert type level or better down on group / server / database etc.
6 votes -
Alerting on Autogrowth Events
Alerting on Autogrowth Events, some environments set the file size of their databases and would like to be alerted if autogrowth occurs since that indicates abnormal behavior
3 votes -
Environment specific Reports
As we have option to create different reports on SQL Monitor, We would like to have the option to create the reports as per environment (Dev,UAT,Prod) for Disk Space,Server Downtime etc. It will be more feasible if we can get a filter to create reports for the specific environment.
1 vote -
Add Top Waits info for PostgreSQL
Re: PostgreSQL Monitoring
Please add the ability to show wait stats by wait type as you have for SQL Server.
3 votes -
Suppress Notifications until turned back on
There are times where we are configuring and testing an instance or cluster and want to monitor it, but would like to prevent notifications being fired while keeping alerts - having the ability to suppress the notifications until we turn it back on would be handy and take less administration overhead than configuring the alerts for each instance/cluster
13 votes -
Include drive letter in subject and body of disk space alert email
It would be helpful to know which drive (by letter) the alert information detail is about in the email. The drive letter should be included in the subject line such as Disk space | ServerName | E:\ as well as in the body of the email. This information helps identify the problem drive without having to go to SQL Monitor for that information.
15 votesThis enhancement will be in the next version of SQL Monitor
-
Few suggestions:
• Display the Job Name (character string) instead of hexadecimal value (SQLAgent - TSQL JobStep (Job 0x442BC6B49DA6FC41A98697F8C2F68956 : Step 1)
• In alerts configuration: Be able to exclude Long-Running query alerts (or any type of alert) for a specific time frame. For example: between 11:00PM and 5:00AM
• When selecting an alert details view, create a link to be able to come back to previous alerts summary screen instead of selecting Overviews link and then again narrowing down to alerts summary by server let’s say…80 votesHi, because these are multiple suggestions and it’s not clear who has voted on what, I am going to have to close this suggestion.
If you are interested in the Job Name request, please open a new suggestion for this
If you are interested in the Time frame suggestion, please vote on: http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11122008-suppress-performance-related-alerts-during-mainten
If you are interested in returning to the Alert Inbox from the details view, this has been implemented in SQL Monitor 3.3
-
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 -
suppress emails during maintenance window
Allow the ability to suppress all alert emails during a maintenance window. Right now we have ~65 SQL servers and during windows when the OS team is patching and rebooting the servers we can receive 100's of emails as the servers go up and down. It would be great if we could set a schedule or at the very least a single use window when emails don't get sent.
2 votesThanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Please see What’s New in SQL Monitor 10 for more details (https://www.red-gate.com/hub/product-learning/sql-monitor/whats-new-in-sql-monitor-10).
We hope this meets requirements and will mark it as completed. Please raise further suggestions for any improvements you would like to see.
Thanks,
SQL Monitor product team
-
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 -
SQL Agent jobs with a 'cancelled' status are incorrectly flagged as 'Job failing' in the Alert Inbox
With Always On related SQL Agent jobs, an initial job step is added to check whether the target database is Primary/Secondary on the cluster node. If 'Primary', then continue with subsequent job steps, if 'Secondary' then stop and do not attempt any further job steps. In circumstances where the job is stopped the last run outcome is shown as 'Canceled' - however, SQL Monitor shows these particular status jobs as 'Job failing' in the Alert Inbox. The job hasn't really failed and has been stopped in a controlled way. Can the status of these job be correctly identified please?
11 votesThanks for this suggestion, and for the additional comments which helped us decide quickly what solution to implement.
Version 9.0.13 released 23rd May includes a new Job cancelled alert (off by default) and stops the existing Job failing alert being raised for cancelled jobs.
We hope this meets requirements and will mark it as closed, but please do raise further suggestions for any improvements you would like to see.
Thanks,
SQL Monitor Development Team
- Don't see your idea?