Add additional perfmon counters
It would be useful to have configurable perfmon counters available in "Analysis" above and beyond the out-of-the-box counters.
For SQL Server perf counters, you can create a Custom Metric against sys.dm_os_performance_counters. For Machine perf counters, you have to use CLI at the moment
Peter Daniels commented
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.
I suggest you to introduce an analysis for the resource Governor
Thanks for your suggestion Brendo.
brendo bongers commented
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 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