Monitor .Net Core SqlClient Connection Pool counters in Azure
I am trying to get to the .Net Core SQLClient (Microsoft.Data.SqlClient, not the Framework version) counters for an application hosted in Managed Service Fabric .
We have a DataCollection rule setup for the VMSS, but I am not sure what the root for the Performance counter would be.
All the counters are documented here:
https://learn.microsoft.com/en-us/sql/connect/ado-net/event-counters?view=sql-server-ver16
For example,
\SqlClient\number-of-pooled-connections
would be the counter to add, but I don't see it in the list and have no idea if "\SqlClient" is correct.
Thanks for any help!