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 — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!
If you have any questions visit the Redgate Monitor forum.
683 results found
-
Easily identify which base monitor is hosting a monitored SQL Server host
In a multi-base monitor configuration it is a bit cumbersome to identify which base monitor is hosting a given entry on the overview page. Yes, one can search all the SQL Server host machines on each base host, but that takes time. It would be better to have an entry in overviews that identifies where it is hosted.
5 votes -
Have a way to exclude Deadlock alerts based on the T-SQL or Proc name
I would like to exclude alerts for deadlocks based on a procedure name or other T-SQL, just like I can do for LRQ and other alerts. Please see http://productsupport.red-gate.com/hc/requests/170766
1 vote -
show sql related windows event log entries
Rather than going through all Windows event log entries looking for SQL related events on every monitored server, it would be good to have them displayed on the server screen along with the SQL Error log entries.
1 vote -
1 vote
-
Extend field width of Server Selector field on top of Dashboard to be the same width as the Drop Down
Go to Dashboard; Overview tab; drill down to one of the servers. On top of this next form (Server Host Metrics form) is the Server Selector field with a Drop Down list box. When you select the down arrow key to open the List Box the width of the List box is about twice the width of the Server Selector field. Is it possible to make the width of the Selector field the same as the drop down or make it user defined/variable? Right now it's around 27 chars. We have long server aliases/names so if extended, it will help…
1 vote -
Clear Select Alerts from Dashboard when ended
I'd like the ability to close alerts from the Latest Alert board if they are ended. A checkbox in Alert Configuration to self-close alerts once Ended would be good to have
Eg: I have certain 5-minute jobs that fail once a day if their corresponding run completes I'd like the Alert to clear itself.I can configure the Alert Ended to send email notification stating its ended but it still stays active on the Alerts list in SQL Monitor.
10 votes -
Monitor Azure SQL Read Scale-out Database
I would like to monitor the Read Scale-out Azure SQL DB that gets created when on Business Critical tier.
We are moving our Read queries to this database using "ApplicationIntent=ReadOnly" specified in the connection string. SQL Monitor allows to configure the primary for monitoring but provides no options to add a connection string when adding a server so am unable to add the secondary read-only DB for monitoring.26 votes -
Record queries terminated by the client
We use an ADO client with a query timeout of 30s by default.
These queries are not being captured by SQL Monitor. If they were, it might highlight the cause of why they are taking so long.
For context, we have a query that regularly takes a couple of seconds to execute, but every hour or so exceeds the 30s timeout and we would really benefit from SQL Monitor to capture those to help diagnose why.
1 vote -
Prevent Active Directory lockout from a single failed attempt to log into the dashboard
If the user mistypes their password when trying to log into the SQL Monitor dashboard, their Windows account gets locked out in Active Directory. This happens on the first failed attempt, so presumably there's an automatic retry happening.
(This ticket is similar to https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/16845169-keep-from-locking-account-when-registering-server, but that one is for the server monitor login and this is for the dashboard user's personal login)
7 votesHi,
Thanks for flagging this. Can you please raise the issue with support so that we can investigate further? You can do so via by going to: https://productsupport.red-gate.com/hc/en-us
Thanks,
Neil Turner
Design lead – SQL Monitor -
Display parameter list in the query plan form
It would be great to be able to see the parameter list from the query plan in the "Query Plan" form without having to download the plan and traversing the XML file.
It would save time troubleshooting problematic queries.
4 votes -
Create custom user roles
We would like to create custom roles to grant granluar access to specific functions/features in RedGate SQL monitoring console. Currently, permissions can be granted on monitored objects not on functions except using existing Reporting and Viewer only roles. There is no option to grant Estate access to selected team members or groups.
3 votes -
Ability to export backup history detail for providing audit information easily.
possibilities I can think of that might help to add are each backup having it's own export button when the backup history graph is expanded out, including the backup history on the current excel sheet or possibly having a summary report for it in the Reports section
1 vote -
Ability to export backup history detail for providing audit information easily.
possibilities I can think of that might help to add are each backup having it's own export button when the backup history graph is expanded out, including the backup history on the current excel sheet or possibly having a summary report for it in the Reports section
0 votes -
I use SQL Monitor every day and use the failure reports for SQL Agent jobs, it is most useful. However, when there is an issue with an SSIS
I use SQL Monitor every day and use the failure reports for SQL Agent jobs, it is most useful. However, when there is an issue with an SSIS package that is automated via SQL Agent I have to leave SQL Monitor and go to SSMS. It would be really handy if SQL Monitor could read the SSIS errors. Is this something that is in the road map or could be put in please? Thanks.
13 votes -
I would like alert sounds.
Every product I have used in the past allowed for an Alert sound that you could turn off and on. I get that this is annoying to some people but for certain alerts I like to have a sound on them because I am not LOOKING at RedGate or my email, but I always have RedGate open. So setting any High alerts to a certain sound let everybody in the office know that there was an issue.
3 votes -
Resizing Reports
It would be quite good if you could edit the size of the report and stretch to make it easier to read. Currently (may be an option to) the data over a 7 days period for example is condensed.
1 vote -
DatabaseName custom message parameter addition for Custom Webhook messages
I would like to share with the developers the alerts for the different databases we have in the same server instance. I noticed for custom webhook messages. It looks like the option was there (like monitoredEntity.azureSqlDatabaseName).
One of the SQL instances we have is a shared instance with multiple databases so the owner of the database can know exactly what database is failing
Right now I have the following custom message
{
"text": "{{alert-severity}}: An alert of type \"{{alert-name}}\" has been \"{{alert-status}}\" for {{alert-target-name}}.\r\nVisit {{alert-url}} for details."
}
Where I cannot specify which database is that alert for. I consider…
1 vote -
Connect to Azure database via express route
Currently I'm only able to connect to Azure SQL Server (PaaS) via internet and URL servername.database.windows.net.
We have a direct connection to our Azure environment via Express Route. Therefore I want to use this also for the monitoring, but per default SQL Monitor uses external URL.
3 votes -
Get notification for when a SQL Agent job is in a retry state
Hi, it would be really useful if SQL Monitor could identify when any currently executing job steps are in a retry state. We have many such jobs and the time lost whilst they are in such a state is frustrating as if we had notification we could take action. I appreciate I can roll my solution but would be nice if SQL Monitor could do it :)
1 vote -
Get notification for when a SQL Agent job is in a retry state
Hi, it would be really useful if SQL Monitor could identify when any currently executing job steps are in a retry state. We have many such jobs and the time lost whilst they are in such a state is frustarating as if we had notification we could take action. I appreciate I can roll my solution but would be nice if SQL Monitor could do it :)
0 votes
- Don't see your idea?