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.
671 results found
-
create user permissions script
provide the sql to run for users to use during install to assign permissions to the back end database use and the monitored db use
obviously explain about the SysAdmin problem with your product
https://forum.red-gate.com/discussion/80787/required-permissions-changed-after-upgrade
https://forum.red-gate.com/discussion/80448/new-permissions-needed-for-monitoring
https://documentation.red-gate.com/display/SM7/Permissions7 votes -
Enhance Reports with additional Summary Tiles
Different Summary Tiles for example: Servers with lowest Page Life Expectancy, Servers with Highest Transactions/Second, Servers with Highest Disk Transfers/Second,
3 votes -
3 votes
-
Include Custom SQL Code in alerts
When creating custom alerts, I would like to be able to include information that can be retrieved by running a SQL query.
One example is using the pre-built Failed SQL login custom alert that is available to setup. The alert notifies when this event occurs, but it fails to include information like which login failed, etc.
It would be nice to be able to build part of the e-mail body in the alert to include some critical data that can be queries using T-SQL.
8 votes -
check if there are any service packs or updates for my SQL Server instances
check if there are any service packs or updates for my SQL Server instances. This could then raise an alert to prompt me to investigate these updates.
14 votes -
deadlock frame procname text missing final character
The SQL displayed under the frame procname for a deadlock is missing the final character of the SQL.
e.g: and #ttable.StartDate is nul
Should be
and #ttable.StartDate is null1 vote -
enhance Title on Analysis Graph Page with "machine metrics"; "machine name"; (all)
Simply add to existing title with the selection of dropdown boxes as "machine metrics"; "machine name"; (all).
So we don't need to scroll down or include the bottom boxes to know which machine and options are being displayed...
1 vote -
Sharing links
link share.. . past 24 hours link, you send it, and people click on it, still shows past 24 hours, not the 24 hours from when you shared it
1 vote -
Allow nested groups on the Overview screen
I have a structure of groups where the first level is environment (Production, Test, Development, etc) but then I have component as a second level (ETL, Application, Data QA, Sandbox). On the Overview screen, only the first level of the grouping is used, and therefore I have servers under 'Production' all bundled together and ordered by name across all the secondary groups. Would be good if the overview screen could show multiple groups somehow ... I understand there might be servers under the first level and the second level, and it might be weird for some customers ... but for…
13 votes -
pass
Platform as a service(PaaS) support on SQL Monitor
6 votes -
Would like to set SNMP trap eventtime in a localized time format, currently only CET time format (with trailing Z) is sent in a SNMP message
Would like to set SNMP trap eventtime in a localized time format, currently only CET time format (with trailing Z) is sent in a SNMP message
3 votes -
Alert statistics over time
I would like to see which alerts are firing more frequent over time.
It would be nice to be able to see alert statistics over time, tabluar or graphical.14 votesWe’re reviewing this and would appreciate any more context on what you would like to do with the information.
-
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.
-
Show sample aggregation values on Analysis graph
As you zoom out of a graph on the Analysis tab, the peaks and troughs become less obvious (I fully understand that and agree), but it would be beneficial to know roughly the level of detail at which the values have been calculated to show on the graph.
So for example at the most detailed level (say at Last 1hr) CPU usage is sampled every 15 seconds, zoom out to Last 6hr, and the points seem to be every 1 minute - so are 1 minute averages.If I come all the way out to a custom 60 day view,…
1 vote -
Show current data sizes on purging page
On the data purging page would it be possible to show for each of the data categories how much space each one is currently occupying.
Possibly even an 'oldest date' too? As this may be pertinent if the purge thresholds haven't yet been met.
On some environments I want to keep as much SQL Monitor data as possible and if it's a healthy server you may have very little alert data, and so want to keep more history than you do say, machine data.
It would also help in cases where the Repository database is growing, and you're not sure…
7 votes -
Blocking process alert based on number of descendants
While the alert for blocking process is great, it would be nice to be able to configure the trigger for number of descendants affected as well.
If a blocking process runs for 30 seconds and affects 10 people but the alert is configured for a one minute duration of the block it would obviously not let you know
5 votes -
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 votesWe’re currently working on adding the ability to send notifications to different recipients per level of alert, along with other notification changes. We’d really appreciate some early feedback to make sure we’re on the right track.
If you’re willing to take a look at our designs and give a bit more detail on your specific requirements, please reply to sqlmonitorfeedback@red-gate.com with ‘Notifications’ as the subject and I’ll send further details.
Thanks
Adam, SQL Monitor Development Team -
Save DMV Snapshots for Analyzing and monitoring changes
Idea is to save snapshots of DMV's so that the changes can be analyzed. For example sys.dmexecprocedure_stats shows only total, last and average elapsed time. It will be great to know how the average changed over a period of time.
Common use case: sysproperties
31 votes -
Add an option to schedule when custom metrics run against a given database.
Currently when a custom metric is executed can only be controlled by the frequency (daily, hourly, etc).
My primary purpose is for daily. I would like to schedule the time of day a daily metric is run per database, or at least server. The custom metrics I pull back are time sensitive so controlling when the metric is returned is a must.
A more advanced option to this would be going beyond simply choosing the time of day for daily runs, but rather the ability to build a custom schedule of run times. An example might be Custom Metric A…
54 votes -
Custom metrics to have their own individual data purging value
At the moment, we can only have a single value for data purging for all custom metrics.
I would like to be able to set a custom data purging interval for selected custom metrics as I'd like to track them over a longer period of time.
1 vote
- Don't see your idea?