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
-
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 -
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.
17 votes -
Schema name in the Indexes tab and Top procedures tab on the overview page
In SQL server it is possible to have indexes with the same name on different tables. It is also possible to have tables with the same name on different schemas. Therefore, you can have indexes with the same names on tables with the same names on different schemas. The same is true for stored procedures.
Since there is no data on the index and stored procedure's schema in the Indexes tab and Top procedures tab on the overview page, one does not know which exact SP or index is in the table.
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 -
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 -
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.
16 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
- Don't see your idea?