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.
693 results found
-
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 -
Be able to set an Alert to escalate when it has been active for a certain amount of time.
I have a several different Jobs that fail periodically, once in a while is not a big problem but when they continue to fail over a period of time it does become a problem and I need to know. Likewise when I have an AG is slow to sync in the middle of the night when it is rebuilding all of the indexes of a 1.2TB database and syncing across to locations in 2 states I don't want to be paged, but if it is persistent through the day I do.
1 vote -
Showing Unlicensed and will not allow you to stop monitoring
I added a server that I needed to monitor for a couple hours. When I was done, I swapped out the license and attempted to pause the monitoring to remove the blue banner at the top:
You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts.
However, I was unable to pause the monitoring as it just refreshed the page, with the blue bar at the top, and the "pause monitoring" button still enabled and "resume monitoring" button still disabled. Ideally, there would be a way to say I don't want to monitor this server…
4 votes -
Analysis Graph Tab
This is about the Statistics for the Disk avg. read and write metrics.
There are times when based on the results for a server the statistics are presented in seconds. More often than not it will be 0.0, 0.2 sec, etc.
This is not very helpful, and I often find myself having to download the Export (csv) and get the average.It would be much more beneficial to just show all results in milliseconds, or present an option to the end user of seeing ms or seconds.
Thank you
3 votes -
Group alerts into a hierarchy
I want to be able to group alerts into a hierarchy so that for instance when a server goes offline, all of the other alerts generated such as instance unavailable are not generated.
3 votes
- Don't see your idea?