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
-
global dashboard should handle multi-level groupings
Currently the global dashboard presents the SQL instance tiles according to their top-level group. So if I have 3 servers grouped such as:
App1
Prod
Svr1
Dev
Svr2
App2
Prod
Svr3it will present these under 2 groups: App1 and App2. This is fine if you're viewing all servers.
However when I filter the view to only show servers in the App1 group, I'd like the tiles to be grouped using the next level of grouping if there is one (in this case "Prod" and "Dev")
18 votes -
Customize Disk Space alert for C: drive on all servers
SQL Monitor allows me to set global settings for Disk Space alerts, and then override for a complete server group, for all disk of one single server, or for a specific disk.
What I want is to have different settings for the system drive (C:) as compared to the other drives, Currently I need to set this for each individual C: drive, so one change per server.
Please make it possible to specify global settings (applying to all disks on all servers), and then add an override for C: on all servers.
18 votes -
Monitor Resource Governor
Possibility to monitor Resource Governor Pools:
• Show statistics on pools
• Show workload of groups: cpu, io and memory18 votes -
See disk percentage free/used to Machine overview page
It would be useful to see disk percentage free/used on the machine overview page next to the used / allocated column. This would give us a quick idea of how full the machine's disk is percentage-wise without having to do the math elsewhere.
17 votes -
View queries against specific database in real time
View all running queries against a specific database with the details of the query and its duration.
This will help in monitoring a specific query in any particular time
17 votes -
Allow custom metrics to only run on primary node of an AG
Allow configuration of a custom metric to only run on the primary node of an availability group.
17 votes -
I would like to be able to enter a sql handle and see the history of query time and plans
I would like to be able to enter a sql handle or query hash and see the history of query time and plans in the zoomed time frame.
17 votes -
Alerts for suspect_pages
We would like to see alerts for suspected pages.
Errors Recorded in suspect_pages Table
The suspectpages table contains one row per page that failed with an 824 error, up to a limit of 1,000 rows. The following table shows errors logged in the eventtype column of the suspect_pages table.
Error description eventtype value
823 error caused by an operating system CRC error or 824 error other than a bad checksum or a torn page (for example, a bad page ID) 1
Bad checksum 2
Torn page 3
Restored (The page was restored after it was marked bad)…17 votes -
see sessions from sys.dm_exec_requests in top 10 queries
I never see commands like BACKUP DATABASE or ALTER INDEX in top 10 queries and got the message from support that the information is taken from sys.dmexecquerystats
As it is now it is hard to track down where heavy I/O comes from if it is for example index maintenance or backup.
I think RedGate should record all commands from sys.dmexec_requests and join in the execution plans where they exist and other stats if needed17 votes -
Custom metrics and alerts powershell cmdlet
Could there be a cmdlet to create custom metrics and alerts using Powershell
17 votes -
Provide Mobile version of Alert Monitoring Screen
It may be just me (since no one sle has yet to suggest this) but a mobile friendly version of SQL Monitor for the ALERTS tab would be of great benefit. Currently I check the ALERTS on my SMART PHONE which has a screen waaaayyyy to small to do this but since I have no tablet option I have no other choice.
A mobile option at login to SQL Monitor would let those with smaller sized computing devices acccess the ALERTS tab so as to monitor/check in on their SQL Monitor instance remotely.
Thanks
16 votesThere are currently no plans for a SQL Monitor mobile app. We hope to improve the experience when using SQL Monitor on a mobile device. However at the moment we can’t give a timescale for when this might happen.
-
When a custom metrics targets specific databases then only those database should be listed on the Analysis tab
Currently a custom metric is listed in the left most list box and the databases are in the right most. Some custom metrics are specific to a single database or a specific group of databases.
In either of these cases the database list in the last list box could be filtered to be only the databases that the metric relates to. This would save clicks and shorten the time taken to get to view the analysis trace.
16 votes -
Go to next alert once cleared
If you're clearing a few a alerts and need to review each one, it would be great if clicking cleared then loads the next alert.
16 votes -
filter the queries to see in the top queries and long running queries section
In top queries and long running queries section, I can see the queries executed by the db system but I want to filter out such queries.
16 votes -
Monitor Distributed Availability Group Metrics
Monitor Distributed Availability Group Metrics, currently there doesn't appear to be any metrics tied to distributed AG. Could be as simple as using the monitoring query her:
https://tracyboggiano.com/archive/2017/11/distributed-availability-groups-setup-and-monitoring/16 votes -
Overlay Alerts on the Analysis page
Please add overlay alerts and annotations on the Analysis page. This would simplify the analysis and finding correlations.
16 votes -
Search metrics on the Analysis page to enable quick way to add them
There are a lot of metrics in different groups on the Analysis page and searching for a single metric by scrolling through the list is becoming more and more tedious. Please create a way to search for the metric.
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 -
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
- Don't see your idea?