# active connections in Sql 2000

[John Bailo]

How do I monitor the number of open connections in Sql 2000?

including ones opened by ADO and .NET processes?

 

[Arnie Rowland]

One way is in Enterprise Manager.

Select Management, Current Activity, Process Info.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

 

[John Bailo]

One way is in Enterprise Manager.

Select Management, Current Activity, Process Info.

Is a process, the same as a connection?

For example, in a c# command, if I do

SqlConnection.Open()

on some string, would I expect to see a corresponding Process?

 

[Arnie Rowland]

Yes

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

 

[prabhupr]

You may try from Query Analyzer sp_who OR sp_who2