Monitor .Net Core SqlClient Connection Pool counters in Azure

Kane Tao 1 Reputation point
2022-08-10T04:57:00.237+00:00

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!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,489 questions
{count} votes