SQLConnection pool size and active connection count in C#

c# count connection-pooling sqlconnection
phoad picture phoad · Aug 11, 2014 · Viewed 9.8k times · Source

In C# it is possible to enable/disable Connection Pooling by using "Pooling=True" and "Max Pool Size=XY" in connection string.

Like: What is maximum allowable value of "Max Pool Size" in sql connection string

Is it possible to ask how many connections to SQL server is active and what is the current pool size programmatically?

Answer

Vlad Rudenko picture Vlad Rudenko · Jun 6, 2015

You can use NumberOfActiveConnections or NumberOfPooledConnections ADO.NET performance counter:

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/performance-counters

Related questions

Getting a count of rows in a datatable that meet certain criteria

I have a datatable, dtFoo, and would like to get a count of the rows that meet a certain criteria. EDIT: This data is not stored in a database, so using SQL is not an option. In the past, I've …

Read More
Lists: Count vs Count()

Given a list, which method is preferred to determine the number of elements inside? var myList = new List<string>(); myList.Count myList.Count()

Read More
Count the number of times a string appears within a string

I simply have a string that looks something like this: "7,true,NA,false:67,false,NA,false:5,false,NA,false:5,false,NA,false" All I want to do is to count how many times the string "true" appears in that string. …

Read More