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.
697 results found
-
Search through (closed) alerts for a string.
It would be great if we could search closed alerts for a string. For example I want to see all the alerts that have included a particular view in the query text.
(Also include comments in the search)
69 votes
Daniel Rothig
responded
We’re looking into this – no ETA at the moment
-
More options for Custom Metric Frequency
Would it be possible to have a custom option for the Custom metric gathering, as it stands the data can be collected at intervals of 1,5,10,30,60,1440 minutes
it would be nice to be able to select a custom value and values less than a minute, the standard metrics that are gathered appear to be gathered every 20 seconds which isn't an option here
Thanks for your time and concideration
Ste9 votesDaniel Rothig
responded
Note that you can currently hack an arbitrary “seconds” value into the SQL Monitor database – but changing the Custom metric configuration via the UI will reset the collection interval to one of the default values.
-
Add an analysis metric for Total bytes sent/received over the network interfaces
There is an analysis metric that currently exists for Network Utilization, which I believe is calculated based on the total bytes sent/received over the network interfaces divided by the bandwidth of the network interface. It would be great to add the raw delta bytes/megabytes sent/received/total as a metric on the analysis and overview pages of Sql monitor.
14 votes -
Alerts for high virtual log file count
Alert on high transaction log virtual log file count. Also being able to configure the thresholds to be alerted on.
4 votes -
Correct Database file usage alerts with In-Memory/Filestream Filegroups
The Database file usage alerts in V 8.2 are great, however they do not work correctly with Filestream filegroups. per https://forum.red-gate.com/discussion/comment/153592 they are not supported.
Please either add support for these filegroup types or disable them by default so we are not spammed by alerts for something that's not valid.
Thanks,
-Luke.6 votes -
Add 'Details' column to the Alert inbox between Object and Unread column
Add 'Details' column to the Alert inbox between 'Object' and 'Unread' columns
6 votes -
Show when a Windows/SQL patch was applied
The current SQL Estate Monitor will show activity for a specific server and has the ability to show when code for example was deployed. I mentioned at the recent SQL in the City in London that it would be good to see any kind of patching that had been applied to that server as well. Get quick eyes on anomalies after a windows update or SQL patch.
2 votes -
Capture cursor SQL for long running queries
It would be great if SQL Monitor would capture the SQL statement being executed for long-running cursors. Currently it shows "FETCH CURSORNAME001"
Cursor SQL can be found with this query when the cursor is still open:
SELECT c.sessionid,
c.cursorid,
c.properties,
c.creationtime,
c.isopen,
c.fetchstatus,
c.dormantduration,
s.logintime,
t.text
FROM sys.dmexeccursors (0) c
JOIN sys.dmexecsessions s
ON c.sessionid = s.sessionid
CROSS APPLY sys.dmexecsqltext(c.sql_handle) t14 votes -
Analysis graph exclude set times over long time range such as 28 days
It would be great to be able to set exclusion times such as the "maintenance windows" when index maintenance activities take place such as every day between 12pm-2am in our case. During these times disk queue length will be predictably high due to the maintenance activities taking place.
When viewing graph analysis for a 28 day period for disk queue length you see peaks which are from the maintenance activities and these events end up skewing the overview of BAU activity.
It would be great to be able to define an "exclusion time window" in the analysis report window to…14 votes -
Allow maximum number of email notifications in a 24-hour period alert to be sent to another email address
Currently if too many alerts for a particular object are received an alert email is sent noting that no more emails will be sent. I want to be able to specify that email is sent to a different address than the default.
For example, we may get a large number of deadlocks. after the first 150 the alert emails are silenced. We configure deadlock alerts go to our normal email address because generally they aren't urgent, however when 150 or more are received there is a definite problem that needs to be reviewed. That should go to our pager email…
9 votes -
Add a summary tile for deployments to a database
I'd like to see a summary tile for deployments to a database by SQL Compare and SQL Change Automation.
Also it would be good if alerts can be created for these events.3 votes -
See who is using SQL monitor
Before I upgrade SQL Monitor I'd like to see who is logged in/using it so I can inform them.
2 votes -
Search for SPID for specific Date and Time
I would be a good idea to have a functionality in SQL Monitor to search for SPID for specific Date and time. This will help us to review what query run by who on given date and time.
1 vote -
rss
RSS Feed, can it be exposed so logon to SQL monitor isn't needed
1 vote -
Notification
Generate Notification Per Alert (optional) and Show in windows
when Browser is Close.
And then Send Text Message To User Mobile Number1 vote -
Change unable to connect error messages to include DNS issues
Added a server via IP address as it's in a remote DC, test ran fine. After clicking Add to monitor the server, SQL Monitor resolved the IP to the cluster name, and attempted to add the 2 cluster servers via name (which is great, much easier to recognise servers via name than remember the IP), however SQL Monitor failed to connect, with WMI errors, RPC Server unavailable etc.
These errors were misleading, as the real reason it wouldn't connect is that the server couldn't resolve the DNS names. Adding them to Hosts file sorted it straight away.
Connecting should attempt…3 votes -
provide a scale on the analysis graph when monitoring disk reads and writes
provide a scale on the analysis graph when monitoring disk reads and writes
1 vote -
on the overview, monitored instances be able to choose which groups to show
It is possible to choose one or all groups on the monitored instances overview. I would like to be able to select more than one group to show or deselect some groups that I do not want to see.
3 votes -
Provide a direct link to the base monitor download
When installing updates, only the SQL Monitor web service link is initially provided. In order to get access to the SQL Monitor base monitor download one has to first install the the SQL Monitor web service. This process slows down upgrade time and extends the "broken state" time in a multi-base monitor configuration.
Please provide a direct link to the base monitor download without requiring an initial WebService monitor install.
4 votes -
Have database sessions displayed with the networking info from sys.dm_exec_connections(SqlServer)
Having a window of session connection information, especially using the network info per session as seen in the sys.dmexecconnections view from SqlServer would be very helpful. This also helps in associating network latency waits with the actual app session(s).
4 votes
- Don't see your idea?