ITPUB

Sep 12, 2016 · Databases

Diagnosing SQL Server Connection Pool Exhaustion with sp_who2

When a timeout error occurs because the connection pool is full, you can use sp_who or sp_who2 to list active SQL Server sessions, interpret sleeping processes, understand ADO.NET pooling behavior, and employ SQL Server Profiler to pinpoint why connections are not being reused.