You are an enterprise application developer. An ASP.NET application accesses a Microsoft SQL Server database. You discover that the application intermittently logs the following exception:
“System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.”
You need to identify an appropriate performance counter to ascertain that the exception is caused by the leaking connections.
Which performance counter should you monitor?
A.
.NET CLR Data\SqlClient: Total # failed connects
B.
.NET CLR Data\SqlClient: Peak # pooled connections
C.
.NET Data Provider for SqlServer\ NumberOfPooledConnections
D.
.NET Data Provider for SqlServer\ NumberOfReclaimedConnections