There are several perf counters that reflect usage. Fire up perfmon and look
at .NET CLR Data. Or use the PerformanceCounter class if you want run-time
stats within your app.
In any case, make sure you're properly disposing of connections as quickly
as possible after they're used, like:
using(SqlConnection con = new SqlConnection(...))
// use connection here.
Author, "Microsoft Visual C# .NET Core Reference", MS Press