Suggestions
Welcome to the Redgate SQL Monitor feature suggestions list. Tell us how we can improve SQL Monitor by voting on these suggestions or by submitting your own ideas.
This is the easiest way to make an impact on SQL 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 SQL Monitor forum.
207 results found
-
See last backup of each type in Overview page
Currently the backup section in a database on the overview page shows the backups that happened in the selected range, and it only shows the last backup of each type that happens. We have a database that does full backups once a week and then differentials.
It would be helpful at a glance to see the status of the last backup of each type regardless of if it happened in the time window or not. Maybe hide the last differential if it happened before the last full.
6 votesWe have redesigned the Backups information to more clearly show the selected range it refers to, and also show when the last backups occurred prior to that. This can be seen in the latest version (8.0.25)
We hope this improvement completes the suggestion and will mark it as completed. Do let us know if you have any further feedback
-
see the dates in UK format in the Estate - Installed Versions tab
the release date and end of mainstream support date are both shown in USA format i.e. mm/dd/yyyy
7 votesDates are now shown as dd mon year e.g. 28 Sep 2022.
-
Dynamic Report names
It should be possible to have dynamic fields in the report name similar to the way Backup Pro implements backup names. So when the report is emailed the attachment could be easily saved without having to rename it.
For example "MyReportsBaseName<YYYYMMDD><HH:MM>"6 votesReleased in SQL Monitor v13.0.5.
-
Prompted for update to version 8.0.12 but website is a dead end
The "update" link in the SQL monitor console takes me to a "learn more" page with no link to an update EXE. I am referred to a zip file with a SQLBundle EXE which doesn't contain the Monitor, or an outdated version of SQL Monitor.
1 voteHi,
Thank you for reporting this, and apologies that you encountered it. We removed version 8.0.12 owing to a bug, and have since released 8.0.13.
I will close this suggestion, but if you require further assistance with this issue, please could you let us know using the support forum https://forum.red-gate.com/categories/sql-monitor-7
Kind regards,
Adam
SQL Monitor Development Team -
Exclude databases with state = 1 (RESTORING) in page verification alert
During a restore the page verification alert gets triggered, even when the database has CHECKSUM page verification. Please exclude database with state = 1 (RESTORING) in this alert! Thanks!
6 votesThanks for this suggestion.
Version 9.0.4 has now been released and the Page Verification Alert will no longer alert when a database is being restored.
We hope this works as you expected and will mark this as complete, but please do let us know if you have any further comments.
Kind regards,
SQL Monitor Development Team -
Alerts related to SQL Jobs should show the job name not the job Id
Process name: SQLAgent - TSQL JobStep (Job 0xECCD1234543A1FA439B02DE3CE12F139E : Step 1)
64 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 -
Overview database growth estimation
When planning new server we have to estimate how much space will be taken by database during life cycle of new SQL server and when SQL monitor watching server for us I would like to have possibility see following:
- Database file size portion
- Log File size portion and how much of that contain free space
- Estimated growth (as information in Alert)
- Summarized size per disk (if possible with how much space left)
- Have this available as summary tile in the report, so I can reactive this info as email.
Thanks and regards,
//Radek
1 vote -
TempDB unexpected growth
I think it would be a good idea to have information about what caused random sudden growth in tempdb. I know we can see the DB size chart but theres no way to know what caused it.
Information that would be nice to be captured:
Table name
What query created table
What user created table47 votesTempDB metrics are now available on the server overview page from version 11.0.
-
be able to report on deadlocks
Add the possibility to report on deadlocks. The information is stored in the database as an alert but it's currently not possible to report on alerts.
I'd like to see the occurrence of deadlocks over time, per database,...
32 votesA tile showing the top 5 most commonly occurring types of deadlock grouped by the pattern of locking within the deadlock is now available within 'Reports'.
-
SQLMonitor consider the SQL Server cluster name as an instance
SQLMonitor consider the SQL Server cluster name as an instance
9 votesThis can be set within Display settings ('Failover Cluster Name Display') for a SQL Monitor configuration.
-
Job duration taking too long - triggering WHILE job is still running
CONTEXT: If a job is taking a long time (outside of some predefined threshold), we want to be alerted about it. That’s often an actionable alert – we could decide to stop the job, we could let the users know that report XY will be late as a consequence etc. One step further is being alerted on the job STEP level as well.
PROBLEM: Current alert “Job duration unusual” is triggered AFTER the job completes, if it meets the alert's criteria. We need an alert to trigger WHILE the job (or job step) is still running, but the criteria is…
118 votesAs of v10.0.4 the Job Duration Unusual alert is raised while jobs are still running, so marking this as completed. Thank you very much for the feedback.
-
Email Reports as an attachment
I know that it is possible to email report on a schedule basis.
But it only sends a clickable Link to the report.Is it possible to send a PDF as an attachment on a schedule basis?
16 votes -
Group expensive queries by query hash
I would like to have a section where the query execution counters are aggregated per query_hash.
We use Dynamics Ax ERP and in order to avoid parameterisation issues we enabled passing company literals instead of parametres. This now leads to a single expensive query "taking up" as many of the top 10 query slots as there are companies executing this query.
Ideally it would be possible to show the top 10 query hash data on the top level and then drill into each sql handle and view the query statistics and history there.
9 votes -
Report Email Attachment Name
Name the pdf attachment something other than "AttachedReport".
The report has a title and a date which could be used to name the attachment. That would really simplify the process of saving the reports for baseline purposes.
e.g. "Server2ProcessUtilization20180308.pdf"3 votesReleased in SQL Monitor v13.0.5.
-
Notifications to Slack Only
Would be nice to have the option to send some alerts to slack only, at the moment the only option is to send to slack and email, or don't send to either.
7 votes -
Database File Usage Alert - Autogrowth
Database File Usage Alert : Please consider autogrowth! So far, this alert is of no help.
3 votesSQL Monitor v7.1.18 added an option to disable database file usage alerts when autogrowth is enabled. The setting can be found on the configuration screen for the database file usage alert.
Thanks for helping us improve this feature with your suggestion.
SQL Monitor Development Team
-
Setting Maintenance Window via API service
That would be very nice if there as an API service which we would use to set maintenance window for a given sql host or a group of hosts.
7 votesThanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Windows can be set-up using SQL Monitor, or via the API. Please see the example Scripts within Configuration for more details.
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
-
Allow the pinning of availability groups to the Global Dashboard
I'd like to see the status of my AGs on the Global Dashboard without having to find them inside the server. Would also nice to see stats on latency on this widget.
6 votes -
SQL instances which are part of Availability Group does show if it primary or secondary in Global Dashboard
When SQL instances which are in Availability Groups are being monitored, the global dashboard lists both the primary & secondary node.
However though it does have 'AG' badge but it does not say which is primary or secondary.
While looking at the SQL monitor it will key that we know upfront which is the primary instance and also when alerting it should say primary or secondary in the subject line.48 votes
- Don't see your idea?