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.
240 results found
-
get a report on my server inventory
For MSFT licensing purposes, I would like to have a report from SQL Monitor across all my registered servers that tells me enough information to work out my licensing requirements. For example, which version of SQL Server is installed, which edition, how many CPUs it is installed for, any information about the Windows licensing, whether it is on a virtual machine (and how many sockets, etc) ... you get the idea.
Currently, the reports only allow for a very limited amount of information to be added, and they have to be in summary tiles or charts. Maybe this could be…
33 votesThe SQL Server Licensing page within the ‘Estate’ section (see attached) shows licensing information for monitored servers.
-
export selected alerts
it would be nice if we could export selected alerts (for instance full deadlocks related information) to forward to our "partner" so they can analyse the problem.
21 votesThanks for this suggestion. SQL Monitor 10 now makes it easier to create and share reports of recent types and severities of alert. 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).
Thanks,
SQL Monitor product team
-
deadlock
Add the ability to customize deadlock alerts. I want to able to ignore alerts if the deadlock was on table XXXXX or produced by stored procedure YYYYYY
or have different alert levels depending on the database and table.45 votesThanks for this suggestion. We will close this now as there have been no new comments since we released the new filters.
However, please do raise new suggestions for anything you feel hasn’t been addressed, so we are able to consider them as we continue to improve SQL Monitor.
Thanks,
SQL Monitor Development Team -
Add the calling module/process in "Blocking process" alerts
In the Details tab of a Blocking Process alert the process name of the blocking process is included. It would be very useful if this was included in the "Blocked process" info on the processes tab. This would assist us in working out what it is that the blocked process is trying to access because the SQL fragment is often too generic to be useful.
13 votesFrom version 12.1.28 this information is provided.
-
Email reports monthly
I just upgraded to SQL Monitor V7 and it's great being able to have custom metrics in reports. We have a metric that records how many customers are notified in a monthly process (runs overnight on the 1st of the month). We need a way to send out this report via email on the 1st of every month (current options are only to send it weekly)
10 votesThe ability to email reports on a monthly schedule has now been released.
Please make a new suggestion if there are any areas of the reporting you think could be improved.
Kind regards,
SQL Monitor Development Team -
set the default email recipient per level
I'd like to be able to override the default email recipient "per level", in the same way alerts can be configured.
This would make it much easier to manage in a case where monitoring responsibilities are delegated for a specific server or group of servers.
16 votes -
Exclude queries from top 10 queries
I would like to be able to exclude specific queries from Top 10 Queries. We use SQLQueryNotificationService which means our top 10 queries based on duration are always showing these queries as they have a waitfor. I would like the ability to exclude items from the top 10 queries.
Typical query I would like to able to exclude:
WAITFOR(RECEIVE TOP (1) messagetypename, conversationhandle, cast(messagebody AS XML) as message_body from [SqlQueryNotificationService-07e6439b-8276-45aa-963f-bed011b3ef2f]), TIMEOUT @p2189 votesTop query search (available since version 11.2.9) supports NOT and '-' operators, so you can exclude queries from the Top Queries view. See more in the documentation here.
-
Sortable System Processes Grid
On the Alert Details page, it would be nice if I could sort the grid under the "System Processes" tab. It currently shows processes sorted alphabetically by name. I would like to sort it by CPU or memory utilization to see top consumers. I currently have to copy the data to a spreadsheet to do that.
10 votesThis suggestion, allowing the system processes grid in alert details to be sortable, was completed in Version 6.0.18 – apologies for not updating at the time.
Thanks for the suggestion – please reply if you feel it needs further attention.
Kind regards
SQL Monitor Development Team -
suspend
Hi,
I think it's very important to show Suspended status of a monitored host/instance should be shown in dashboard.
I had suspended monitoring on an instance and forgot to resume so I've missed monitoring for a while.
I suggest to show the state of monitoring (Active or Suspended) maybe graphically/iconic, in the dashboard and Server overview pages10 votes -
Historical graph of how one query/Stored procedure is performing now compared to 2 months back
Choose from top 50 of worst queries and check what is the difference now compared to the stats in the past in graphical view and create custom reports with graphical view
30 votesThank you for this suggestion. A graph showing a query’s history was added to the Server Overview Top Queries table in Version 7.1.11 in November 2017. This allows you to see a query’s performance over time, view its execution count, duration, reads, and writes, and the points in time a query’s plan changed.
We will close this suggestion, but please do raise another suggestion if you have other specific improvements you’d like to see.
Kind regards,
Adam
SQL Monitor Development Team -
improve speed when navigating through the GUI
It takes quite sometime to navigate across the screens on V6.0 would be a welcome relief if we have performance improvement on the UI
1 voteThanks for raising your suggestion. We’ve made a number of performance improvements over recent releases. Whilst we will continue to make improvements, hopefully this meets your expectation regarding this suggestion, so I will close this issue.
If you have any specific issues or suggestions around performance, please reply to this or raise another UserVoice suggestion so we can investigate.
Thanks
Adam -
Specify a "details" query for custom metric
When I define a custom metric it would be super-helpful to be able to see some details that gave rise to the metric value. For example, I have one for "count of failed SQL logins in the last 10 mins". But to find out which logins failed, I have to go run queries in SSMS.
I'd like to be able to define a "details" query on the custom metric, the results of which are captured at time of collection, and are then available from the alert.
76 votesFrom version 14.10.0 you can now specify a SQL query to provide additiona information when a custom alert is raised for a custom metric.
For SQL Server and Postgres, this is a separate query specified when defining the custom alert as described on this documentation page. Oracle custom metrics work slightly differently and this is the optional third alert_detail_text column as described on this documentation page.
-
I want to be able to document in SQL Monitor why an alert is set a certain way.
On the alert configuration screen for any alert, at any level I would like to see a comment type box where I can enter in the box the reason the alert is set as it is.
For example if I have disabled the backup overdue alert for a particular database I would like to be able to save that reason in this comment box. Or if I have changed the disk space usage for a particular drive on a server different than the default I want to be able to document the reason why.
I want to see this box…
21 votesThank you for this suggestion, it makes sense to want to record why certain configuration changes have been made.
We released this enhancement in version 8.0.10 (in July this year – apologies for delay in updating this suggestion).
I will mark this suggestion as Completed, but please do reply if you have any further feedback.
Thanks,
SQL Monitor Development Team -
Sort or Filter Monitored Servers
In Configuration -> Monitored servers I would like to sort and filter the servers and have the grouping functionality applied to this screen. This would make it easier to find my server that I want to put a maintenance window on.
38 votesMarking as completed - the Monitored Servers page now includes filtering based on server name, tags and status.
-
Add AM PM or military time to alert times since they aren't listed
Process login time: 3 Nov 2016 09:00
Query start time: 3 Nov 2016 09:00
Would either want them in military time, or listed w/ AM PM so I know when they occurred1 voteClosing as this has been available since 6.0.7
You can find this option on Configuration > Display settings. Please let us know if this is not working as you expect.
Thanks -
See more detail on Failed Agent Jobs
Present the detailed Step error message for Agent Job Failures. Currently shows the Job message, but not the error from the step that actually failed. This requires the user to open SSMS and drill down to find what caused the failure, instead of getting a head start from SQL Monitor.
53 votesThanks for the suggestion and votes. This was completed in version 7.1.2. I will close this – please let us know if you believe there are further improvements we could make.
Kind regards,
SQL Monitor Development Team -
to see 24-hour clock affecting times on graphs
I see the setting and it is set and in most places it is used but not in the time axis on graphs in analysis.
6 votesWe have just released version 7.1.3, available from Check for Updates, which fixes this issue.
Thanks for the suggestion, and for your patience,
Adam
-
Allow option to exclude Integrity Check Overdue Alert for read only databases
An alert configuration option should allow
a database status to be checked when querying for last good integrity checks and read_only databases could be excluded from the alert. Even when integrity checks are performed on read only databases, the last checked date is not updated resulting in unnecessary alerts in most cases.8 votesThanks for this suggestion.
Version 9.0.7 has now been released and adds the ability to exclude read only databases from Integrity Check Overdue and Fragmented indexes alerts.
We will mark this as completed, but please do raise a suggestion if you would like to see further improvements.
Thanks,
SQL Monitor Development Team -
Disable Chat functionality
It would be nice to have an Option to disable the built in chat functionality. I understand this is a quick easy method for obtaining feedback from the user community. The issue I have is that this is not an "Approved Chat Client" according to my info sec unit.
Having the ability to turn it off allows me to satisfy their requirements while still allowing this to be enabled for other users to quickly interact and provide feedback to RedGate.
6 votesAfter upgrading to SQL Monitor 6.0.8 or later you can now disable the intercom chat feature.
After upgrading navigate to the following file C:\Program Files\Red Gate\SQL Monitor\Web\Website\web.config
and amend the line
intercom enabled=“true”
to be false, then restart the website.
Further details can be found here:
https://forums.red-gate.com/viewtopic.php?f=205&t=80218&sid=76afdd87b11da381fcb31901d658270a#p143776Thanks for your patience with this issue,
SQL Monitor Development Team -
Block Specific Deadlocks by Lock Details
We've just updated to SQL Monitor 6. We was hoping there was a feature in this to change alert settings for Deadlocks with specific lock details rather than just all Deadklocks.
For example
we don't want email alerts on: Deadlock 'object: ReportServerTempDB.dbo.SessionLock, lock mode: Exclusive (X), index: IDX_SessionLockHowever we wish to receive emails when: Deadlock 'dbid: 6, object id: 72057594038845440, index id: (9bf78693a4b4)'
However this feature doesn't exist. Would be great to have added to an update in the near future!
42 votesThanks for this suggestion and the comments.
As previously announced, since version 8.0.22 (released November 13th, 2018) Deadlock (XE) alerts can now be filtered by database, login name & resource, and victimless (eg Exchange Event) deadlocks are excluded by default.
We are marking this as complete, but please do let us know if you have any further feedback.
Thanks,
SQL Monitor Development Team
- Don't see your idea?