Fog Creek Software
Discussion Board




Welcome! and rules

Joel on Software

Monitor connection pool...

Anyone know of a tool (preferably free) that let's you monitor the connection pool for a SQL Server database?

I'm doing stress testing for an app I wrote that's pretty database intensive and I want to monitor the database pool to make sure that all connections are being released back into the pool.

Thanks.

smallbiz
Friday, November 05, 2004

Nevermind...googled and found out how to do it with perfmon.

smallbiz
Friday, November 05, 2004

SQL Server Enterprise Manager, Management, Current Activity, Process Info is the easiest way to check this isn't it?

Any unexpected entries displayed long after the application has supposedly closed all of the connections is a sign that pooled connections are not being returned to the pool.

Mike
Friday, November 05, 2004

*  Recent Topics

*  Fog Creek Home