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.
736 results found
-
Additional parameters for filtering Long-running query alerts
Long-running query alerts
Example: Creation of ability for you to filter the queries it alerts on based on a regular expression
Source Ticket:
https://redgatesupport.zendesk.com/hc/requests/65981Possible closely related feature request:
https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11123559-triage-and-configure-repeating-alerts-more-efficie7 votes -
add the table schema to alerts
On that alert (fragmented index), you see a table name. It would be helpful to see the schema to which that table belongs.
Medium Fragmented indexes
Raised on: XXXXXXXX > RedGateMonitor
Time raised: 26 Jun 2016 1:00 AM (UTC-04)
Details
Database name: RedGateMonitorTotal number of indexes: 332
Indexes above fragmentation threshold: 3Indexes last checked: 26 Jun 2016 1:00 AM
Fragmented indexes:
Index Table name Fragmentation(%) No. of pages
ClusterSqlServerServerWaitsUnstableSamplesIdCollectionDate ClusterSqlServerServerWaitsUnstableSamples 96 1175
ClusterSqlServerSqlProcessUnstableSamplesIdCollectionDate ClusterSqlServerSqlProcessUnstableSamples 96 3288
ClusterSqlServerTopQueriesUnstableSamplesIdCollectionDate ClusterSqlServerTopQueriesUnstableSamples 99 17584 votes -
Check the plan cache ad-hoc or on a schedule to report issues
implicit conversion,
scans,
lookups and the index that didn't have the columns include
missing indexes
Parameter sniffing
etc...
Report the issues based on impact number2 votes -
Custom metric: alert when value changed
I want to be alerted if someone creates or deletes a database. The metric itself is easy (select count(*) from sys.databases - executed for the master DB on all servers).
But in the alert setting I can only define that it should trigger if the new result is abover or below a set value but not for value changed (compared eigther to the previous value or the "baseline").
So I have to create two metrics / alerts for DB drop (below) and create (above) AND have to define / modify the number of databases as alert threshold for each server…
19 votesDaniel Rothig responded
-
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 votesDaniel 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 -
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
- Don't see your idea?