Add support for the new Azure SQL Hyperscale PaaS solution

Redgate Monitor still does not appear to fully support Azure Managed Instances. As our primary business is about to move across solely to Azure Managed Instances, this is now a seriously high priority for us.

We are heavy users of Redgate Monitor for our business, so this is now starting to be become a bit of a worry for us.

Utilize SQL (or SQL-like) statements in the filters, specifically on the Overview tab to filter on server name. For example: '%sql%' AND '%prod%'
Currently you can only do 1 fuzzy logic search. Also, you cannot search just by one character.

SQL Monitor should be able to support Enterprise Single Sign-On using SAML. Is this on the roadmap?

Enable SQL Monitor to add AWS RDS instances as monitored servers

I found a custom metric for a single long running job. However, what we need is a way to alert for SQL Agent jobs that are running beyond a designated time (similar to the long running query metric built in). The "unusual duration" alert doesn't quite do what we need. Hopefully someone knows how to make this a custom metric. If not, consider a feature request!

Please include the name of the stored procedure (where applicable) in the report of "Longest running queries".
Currently I need to use SQL Search to find the procedure that includes the query.

You can do a LEFT OUTER JOIN sys.objects using object_id to find the name (object_name) of the originating stored procedure.

We have several windows clusters and AlwaysOn clusters. It would be very helpful to see on the overview page which node is active.

It can be easily done by adding a color to the AG icon on the tile.

I know that it can be seen on the cluster overview but I really think it belongs on the Overview page.

Linux is the future of sql server. If you've not deployed SQL 2019 AlwaysOn on Kubernetes I'd highly suggest you do. The install is lightning fast compared to clunky Windows installers of the past. I really feel like Redgate is taking a slow poison by not getting on this sooner. Honestly most of the metrics in sql monitor come from the internals of sql. All we really need from Linux is probably free disk space and cpu.

You currently can alias IaaS instances but the option does not show up if it is a PaaS instance.

Just freed-up 55GB on tempdb drive. F5 on the Estate page, Disk Usage tab, and SQM still says 11GB. Clearly WRONG!

Give us the ability for FORCE a disk usage re-calc.

Highlight full table scans on big tables, so these can be investigated

It could be these tables have grown, so initially they were ok, but now they aren't

The per server overview includes a graph of wait ms/s. I want to be able to set an alarm threshold based on Core Count and wait ms/s - If the server is waiting for more than 30% of total available cycles then raise an alarm

E.g. Server has 24 cores, and therefore 24,000 ms/s of available waits

Wait ms/s = 10,000 - 10,000 / 24,000 = 41.7% - ALARM
Wait ms/s = 2,500 - 2,500 / 24,000 = 10.4% - No alarm

It would be great if we could schedule an emailed report of the disk usage estate section.

I would like to be able to customize alerts by job. For instance, I have many jobs that run multiple times per hour. If it fails once or twice, I don't want to be alerted about it. However, if it fails 3+ times in a row, I want to be alerted.

Wire up Notifications to MS Teams (in addition to Slack)

There are some databases (including the RedGateMonitor database) that i do not want to see reported with alerts. I want the ability to omit certain databases entirely from the scope of monitoring and leave all other databases on that machine in the scope of monitoring/alerts.