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.
796 results found
-
track blocking processes date/time by start time, not login time
in blocking tree, it shows old date/times for queries that are running. We found that it is using the login time of the spids (which could be held and sleeping for extended amount of time) instead of the start time of the executing process of that spid.
instead of using the login time, I recommend it uses the start time of the last execution of the query found in sys.dmexecrequest1 vote -
Exclude System Databases (and potentially other user databases) from backup alerts
We would like the ability to exclude system database from the backup alerts, as we do not back them up. We have a system in place to script out security and sql agent jobs/schedules for each of our systems nightly. We also have been leveraging the dbatools PowerShell stack as a way to automate server migrations and other automation activities. Also, our tier one systems are in availability groups. Lastly, we do not backup everything in our lower level environments, as we perform nightly database refreshes for the majority of our systems. However, we do have some testing databases that…
15 votes -
1 vote
-
1 vote
-
Create custom user roles
We would like to create custom roles to grant granluar access to specific functions/features in RedGate SQL monitoring console. Currently, permissions can be granted on monitored objects not on functions except using existing Reporting and Viewer only roles. There is no option to grant Estate access to selected team members or groups.
6 votes -
full
see the full SQL in deadlock Area. Today with long querries you can see only part of it
1 vote -
Have filter on failed SQL Server logins alert
I would like to edit the Failed SQL Server logins alert to exclude failed logins from a value like a host/IP address. We have our security guys trying to break in our SQL servers daily and it trips the failed SQL Server logins alert all the time and over alerts us.
1 vote -
Enable Multi-Factor Authentication for login screen
MFA is rapidly becoming a security standard. Redgate provides a map of the entire companies estate - which would be interesting to an attacker, it would be good if security could be tightened on that login process.
23 votes -
Monitor individual CPU cores and not just avg CPU as a whole
AVG CPU is not enough of an indication of how things are going - There could be an entire numa node maxed at 100% while other nodes are almost idle and it will drag the avg down.
As per here: https://forum.red-gate.com/discussion/comment/162141#Comment_162141
13 votes -
Have ability to configure alerts to be active for various periods.
I have multiple alerts (including custom alerts) on serves. I would like to configure alerts to have different thresholds for diffident periods (weekday/ weekend) OR (mornings / evenings ) OR other periods.
Like log sizes on weekends (mostly due to index maintenance) can be much higher than weekdays.
Current "alert suppression windows " applies to a host and to all alerts on it and not to specific list of alerts.
1 vote -
DatabaseName custom message parameter addition for Custom Webhook messages
I would like to share with the developers the alerts for the different databases we have in the same server instance. I noticed for custom webhook messages. It looks like the option was there (like monitoredEntity.azureSqlDatabaseName).
One of the SQL instances we have is a shared instance with multiple databases so the owner of the database can know exactly what database is failing
Right now I have the following custom message
{
"text": "{{alert-severity}}: An alert of type \"{{alert-name}}\" has been \"{{alert-status}}\" for {{alert-target-name}}.\r\nVisit {{alert-url}} for details."
}
Where I cannot specify which database is that alert for. I consider…
4 votes -
Connect to Azure database via express route
Currently I'm only able to connect to Azure SQL Server (PaaS) via internet and URL servername.database.windows.net.
We have a direct connection to our Azure environment via Express Route. Therefore I want to use this also for the monitoring, but per default SQL Monitor uses external URL.
3 votes -
Display parameter list in the query plan form
It would be great to be able to see the parameter list from the query plan in the "Query Plan" form without having to download the plan and traversing the XML file.
It would save time troubleshooting problematic queries.
4 votes -
ERRORLOG tab on Alerts
When we are viewing an alert, it would be nice to have a view into the ERRORLOG at that point in time. If we could have the option of adding an ERRORLOG tab under the Performance Data section on each alert, that would be handy.
3 votes -
Add a Description field in the Databases section
Dashboard, drill down to the Databases Screen. In that section, there are currently 4 fields or columns - Name, Availability, Transactions/sec, Database size. Will it be possible to add another string field to store a high level description of the database; this will be really useful for our users. Can the new field comes after the name, be 200-300 characters in length and can be a pop-up if a mouse pointer hovers over it. Many thanks.
1 vote -
3 votes
-
Separate notification option for both Medium and High Severity alerts
It would be better to have Separate notification options for both Medium and High Severity alerts instead of a single distribution for both Medium and High severity alerts so that separate group get notifications depending on the severity of the alert.
12 votes -
Have a way to exclude Deadlock alerts based on the T-SQL or Proc name
I would like to exclude alerts for deadlocks based on a procedure name or other T-SQL, just like I can do for LRQ and other alerts. Please see http://productsupport.red-gate.com/hc/requests/170766
1 vote -
show sql related windows event log entries
Rather than going through all Windows event log entries looking for SQL related events on every monitored server, it would be good to have them displayed on the server screen along with the SQL Error log entries.
1 vote -
1 vote
- Don't see your idea?