SQLServer Handles

[jester777]

We seem to have a slow memory leak within SQL Server 7. We can see the memory working set for SQL slowly climbing but more obvious is the increase in handles created and used by SQL.
We can easily monitor the memory usage of SQL using the Win2K performance monitor. Unfortunately we cannot see anyway of monitoring the handles created by the SQL Server threads. Any idea how we can do this?

This is SQL7 SP3, Win2k SP2.

 

[vadimg]

The best tool for monitoring SQL Server activity is the Profiler (it comes standard with default server/client tools installation).
Pick the appropriate event classes and run a trace. That should be very helpful.

 

[jester777]

Thanks for the update but unfortunately the SQL Profiler does not allow us to monitor creation of new threads/handles. Profiler deals with the higher level access to databases rather than the workings of the SQL system as a whole.