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.
- or
38 results found
-
Being able to type the (graph) zoom range time
Sometimes is hard to quickly get to the time range we want to analyse.
It would be handy if we could have a "free text" time box to type:
Zoom range Start: 11:10
Zoom range End: 11:313 votes -
Enhance query tagging in monitior overview.
Add extra functionality to query tagging: allow colour coding of tags, add comment text to tagged queries, enable query tagging in postgresql (I am current using postgresql monitor v14.0.34 with server deployed SQL server, SQL Azure and PostgreSQL Aurora).
Is there any timeline for this?
3 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 -
2 votes
Hi, thanks for this suggestion.
We have added a button to the query plan that allows the full in-truncated text to be copied to clipboard.
We hope this improvement solves the suggestion so will mark it as completed. Please do let us know if you have any further feedback.
Thanks,
SQL Monitor Development Team -
Make it possible to mark a query to be tracked from the database menu
On the "Top queries" within the database menu, we can only "View estimated plan" and "Copy query text".
It would be handy to have here the "Track query" option too.
Nowadays, if I find it here, I need to filter on the top and only then I can "Track query"
3 votes -
Monitoring error (SQL Server data collection) - SAVE THE ERROR LOG
When one of these occurs it is 99.999% likely that, in the middle of the night, I will NOT jump out of bed, fire up the laptop, connect to the SQL Monitor Server and look at the SQL Monitor Error Log IN THE 5 MINUTES I HAVE BEFORE THE ENTRY IS LOST! May I cite the "Description" tab in SQL Monitor: "If the alert is still Active, or it Ended within the last five minutes, you can find out more information about its cause..." So we, ANYONE THAT IS, has a mere FIVE MINUTES to react to this before "see…
8 votesCompleted in SQL Monitor 5.0.3
-
add user editable notes in estate
Add the ability to add some basic text notes for each instance that can be viewed in the estate view. Want to keep some basic notes such as purpose of instance, application server dependencies, etc. Currently use external document to keep track of these.
2 votes -
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.…
4 votes -
Notification
Generate Notification Per Alert (optional) and Show in windows
when Browser is Close.
And then Send Text Message To User Mobile Number1 vote -
Sortable columns on the Alert Inbox (Grouped or ungrouped)
The Alert inbox should be sortable by column.
It would be much easier to focus on key items if the Alert Text column could be sorted. A straight alpha sort (Asc or Desc) would be great. So for instance a "Long-running query (731)" would sort before a "Long-running query (525)" and all of the "Long-running query" be easy to seledt and clear.2 votes -
Reduce the suggestions on how to fix queries when viewing Top 10 Queries
SQL Monitor pops up the text "x issues with this query". Addressing them could improve performance. It then lists some things that might have an impact (e.g. select * instead of listing just the columns that are required) but also lists other things that won't change performance (e.g. not specifying a schema name).
Can this list be reduced to just what is potentially performance related? Maybe have a 2nd field for best practices if that's considered improtant.
2 votes -
Have links on the Configuration/Alerts page look like links
The alert names don’t look like links, so I never tried clicking on them until recently. That does work, as does clicking on the Description. However, some styling (blue text or a blue underline) would make this feature more discoverable for oblivious people like me. 😊
1 vote -
see an administrative web-based log viewer
Having the ability to review logs in a web-based interface is useful for administrators of a tool so we can diagnose and remedy some problems without needing to reach out to support. The downside is the log needs to be filterable or multiple log files need to exist.
An example of a log that would be useful would be an email log. In the event an email fails to send, I'd like to know why without needing to download the entire log in a zip, extract the zip locally, and browse through it when I am looking for a specific…2 votes -
handle case insensitivity with regex
We can configure some alerts to be ignored based on names/objects that are matched using reguler expressions.
Regex is case sensitive, but to avoid having to put all possible combinations in the regex boxes, could that be handled internally by SQL Monitor - for example by uppercasing (or lowercasing) all text before comparing?1 voteHi,
SQL Monitor supports all standard .NET regex characters, and uses the IgnoreCase option. All regular expressions are therefore case-insensitive.
Thanks,
Neil Turner
(SQL Monitor product designer) -
I would like to give aliases to queries for easy recognition
I would like to be able to give an alias for a query text and have that alias show up on the top 10 list.
This to enable easy recognition of "known offenders". We have a lot of queries that are almost identical and drilling into each of them to check the where clauses to determine the actual query is getting tiresome.
1 vote -
Allow extended email addresses "xxx<myemail@yyy.com>" or custom prefixes for subject line
I send my alerts to a tech-staff group and would like to add specific text for end users to filter all SQL monitor emails against. Either allowing extended email address like "xxxmyemail@yyy.com"
or some global prefix that can be added to subject (or body for that matter). Right now I don't see any reference to redgate or sql monitor to distinguish it from other monitoring email I receive.1 vote -
On the Alerts Group Details > Blocking Process page, I want to see Start, End, and Blocked Process Count columns columns
I would like to see Start and End columns or a Duration column, along with a Blocked Process Count.
When displaying the Process tab on the detail page, it would be helpful for each blocked process to display as a collapsed line in a tree, each branch of which can be expanded. Each line should display the SessionId, Start and End or Duration, and the Application, Host, User, and the first (n) characters of the SQL fragment. It is great to have all the details available, but I currently get one huge page with no navigation for one blocker (see…
1 vote -
Add the ability to optionally fire a data gathering query if an alert fires
For example, https://sqlmonitormetrics.red-gate.com/suspiciouserrors/ (Detect Suspicious Errors Typical of a SQL Injection Attack)...
If suspicious activity crosses a threshold, it throws an alert. Great. Now what? I have an alert but no data to investigate without opening SSMS (or tool of choice) and running a query like this (I’m sure there are better ways but this works for an example)
SELECT CAST(targetdata asxml) AS targetdata
INTO #SuspiciousErrors
FROM sys.dmxesessiontargets xet
JOIN sys.dmxesessions xes ON xes.address=xet.eventsessionaddress
WHERE xes.name='MonitorSuspiciousErrors'
AND xet.targetname ='ringbuffer';SELECT
dateadd(mi,datediff(mi,getutcdate(),getdate()),xed.eventdata.value('(@timestamp)[1]','datetime2'))AS EventTime
, xed.eventdata.value('(data[@name="errornumber"]/value)[1]','int')AS ErrorNum
, xed.event…2 votes
- Don't see your idea?