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.
791 results found
-
add more custom notifications
Execute HTTP Action :
This notification method executes a GET request or sends any POST, PUT, or PATCH data to a custom URL. You can execute specific actions on a web server or control any web service that accepts commands via one-time HTTP requests. Whenever a notification of this kind is triggered, the HTTP action is sent.Execute Program:
With this notification method, you can execute a script or a program as an external process. It can be a Windows executable file or a BAT, CMD, or PowerShell file. You can use EXE, COM, BAT, CMD, VBS, or PS1 files.
11 votes -
Be able to run a query (or powershell) in response to an alert
Be able to run a query (or powershell) in response to an alert.
This would automate some responses, but also want to be able to send the RESULT of a script in the email that goes out, ie Alert to say Schema changes have been made where the email actually includes the schema changes.11 votes -
Under Estate section: display last date/time server and/or instances on each server were restarted
I want to know what SQL Server Services are running/stopped on each server and be able to alerted if said servers are stopped.
11 votes -
Exclude serverless databases from monitoring
Need the ability to exclude serverless databases from scanning. The purpose of using serverless is to suspend when not in use, drastically reducing costs. Currently these databases are "kept awake" by SQL Monitor and never go to sleep. This is a deal-breaker for use on some of our servers...
11 votes -
Ability to filter "TOP Queries" by login
Often we want to filter queries not only per existing options (database, parent or query) but it's useful to be able to search for a specific login.
Could you allow searching by login using "l:" or "login:"?
11 votes -
Include SQL comments in Top Queries search
I use Entity Framework Core to interact with a SQL Server database, which comes with the ability to "tag" queries with extra searchable information for troubleshooting purposes.
This extra information is in the form of SQL comments, like so:
-- SPARK: PartyRepository.PartySearch
It would be very valuable to be able to search for this data, but unfortunately it appears that comments are excluded from Top Queries search, even though the data is there in SQL Monitor query data.
11 votes -
group similar queries
I have queries which are created by string concatenation in a legacy product.
These queries differ by some IDs in a IN clause.In SQL monitor, these queries are all shown as different queries in the "top queries" section.
I would like that all those similar queries are shown as one query in the "top queries" section so that I can better find long running/problematic queries.
11 votes -
Option to filter(replace) sensitive SQL from alerts displayed/recorded
Similar regex functionality to how processes/queries can be excluded from an alert but to hide or better yet not record sensitive SQL/SQL fragments
10 votes
Daniel Rothig
responded
Good idea – thanks!
-
Login via https
Is there a configuration setting to force the SQL Monitor login page (or entire site, preferably) to https?
10 votes -
Monitor Azure SQL DWH
It'd be great to be able to monitor performance of queries on Azure SQL DWH, as there are a number of DMV's available to track usage. Also, the ability to see on the Dashboard what DWU level the Azure DWH instance is running on would raise value and awareness of the cost of it, at that point.
10 votes -
Search SQL Monitor Long Running Query Alerts By User Running Query
It would be very useful to search the Long Running Query alerts for a user? The alert text that is displayed in the GUI and in the alert emails list the user running the query. I have Monitor set up to only send the alert emails for my HIGH category. But, when I want to do analysis or documentation, I would love to find all of the alerts Low, Med or High, that are attributed to a specific user or a group of users. Is that possible? To filter the list in the UI to only show alerts from a…
10 votes -
Set up multiple custom alerts for a single custom metric
For some custom metrics, the ideal number is not a fixed number. (E.g. ideal number of VLFs depends on log file size). In those cases I write a custom metric that returns a "percentage of ideal number". I like to be warned both when the actual number is too high and when it is too low so I would like to set up two custom alerts for this.
This is currently not possible without creating a copy of the custom metric, which of course wastes resources. Please consider adding the option to set up multiple custome alerts for a single…
10 votes -
export metrics data to csv (or table) with configurable granularity and option to get cumulative data
The analysis page allows exporting data to csv for a certain metric, e.g., a database counter, but we cannot control the granularity nor whether data for all databases should be cumulative or not.
I would like to get data with the granularity produced by the 15 minute time range, i.e. seconds, but for a larger date range and preferably cumulative for all databases or a set of databases.
10 votes -
Allow for the conversion of time to to HH-MM-SEC in the Duration column on the Server Overview Page
Its difficult to always have to convert milliseconds, so it would be very handy if this conversion was an option to be included.
10 votes -
Monitor database total space usage not by individual data files.
I have many databases that we are monitoring for space which have multiple datafiles. Usually most the datafiles are full but at least 1 of the files is able to autogrow. Sometimes autogrow has reached its max limitation and sometimes we have turned it off once the file reached the largest size we will allow it. Our goal is to monitor so the database does not run out of space. We currently get alerts for the files that are full, we know some are full, we aren't worried about them, we still have 1 or 2 files we allow to…
10 votes -
Clear Select Alerts from Dashboard when ended
I'd like the ability to close alerts from the Latest Alert board if they are ended. A checkbox in Alert Configuration to self-close alerts once Ended would be good to have
Eg: I have certain 5-minute jobs that fail once a day if their corresponding run completes I'd like the Alert to clear itself.I can configure the Alert Ended to send email notification stating its ended but it still stays active on the Alerts list in SQL Monitor.
10 votes -
Who ran the query and what time
I would like to see in sql monitor who was the person that ran the query and what time the query was run.
10 votes -
“Longest Running Queries” in Redgate SQL Monitor Reports
I need to show more “Longest Running Queries” in Redgate SQL Monitor Reports. The layout of the report is also a bit awkward, it seems if everything does not fit into the report.
See attachment.10 votes -
Monitor Cluster Shared Volumes
Under the “Analysis” section, there are cluster metrics which include four different options relating to Cluster Shared Volume usage.
• Used Bytes
• Used %
• Free Bytes
• Free %If we click on the above, we can review our CSV’s to see whether we are approaching the drives maximum capacity.
What isn’t included is the performance of the disk. For instance, under the Machine metrics section, the following is available:-• Disk avg read time
• Disk avg write time
• Disk read bytes/sec
• Disk write bytes/sec
• Disk transfers/sec
• Avg disk queue length.However, these…
10 votes -
Only Query Serverless Azure SQL Databases if they are Online and not Paused
As mentioned in the below post, SQL Monitor will keep serverless Azure SQL databases from pausing and saving us the money they are supposed to. I would like the Azure SQL monitoring piece to be rewritten to use the Azure API to determine both if the Azure SQL DB is serverless or not and if it is AND paused, don't run any queries that would wake it. Yet if it is NOT paused, get info about it and update SQL Monitor.
10 votes
- Don't see your idea?