How many connections open?

  • Thread starter Thread starter Earl
  • Start date Start date
E

Earl

This has probably been asked before, but I didn't get the memo, so I'm
wondering how to find out how many connections in the "pool" are being held
open by SQL Server 2000.
 
There are performance counters for the number of connections that you can
examine using Performance Monitor.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
Greg is right. There are two types of Performance Counters that might be
interesting. I say might because one of them is notoriously buggy. You can
always look at the SQL Server General Statistics User Connections (and
Virtual Connections in 2005) on the SQL Server as these are reliable. These
counters won't tell you the state of the pools though. The .NET Data
performance counters are there too, but they have proven to be problematic
and unreliable. These are replaced in Yukon with a whole new set (with their
own issues... ) ;)

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top