The custom metric addition is a little cumbersome, especially for different metric cntr_types (see: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-performance-counters-transact-sql?view=sql-server-ver15)

It would be very helpful to have a configuration page where I could select other metrics to collect.

Hi,
I suggest you to introduce an analysis for the resource Governor

Thanks for your suggestion Brendo.

Regards,
Priya

It seems that this is not possible with the custom metric solution.

Hi James. I don't know exactly what perfmon counters you are interested in, but if they are available through SELECT * FROM sys.dm_os_performance_counters, then from version 3.0 of SQL Monitor, you will be able to Analyse this data by using the Custom Metrics feature.
Custom Metrics can collect, alert and analyse on data retrieved through T-SQL. If you are interested in trying this out, we have an Early Access Program (EAP) which you can download here http://www.red-gate.com/products/dba/sql-monitor/eap-download
Thanks, Fiona

Hi Joe,

Thanks for your suggestion. We agree this would be beneficial and it is something we've considered and will take a look at again. For the record, I've added your comment to issue SRP-305.

Thanks again for the feedback.

It would be very beneficial to show CPU utilization by core. On modern CPUs, the aggregate does not give enough information. We had one thread taking 100% of 1 core, but it was hard to notice since it was averaged with the other 15 cores