# 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" <ja*****@texeme.comwrote in message
news:mJ******************************@speakeasy.ne t...

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

including ones opened by ADO and .NET processes?

[John Bailo]

Arnie Rowland wrote:

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
"John Bailo" <ja*****@texeme.comwrote in message
news:M-******************************@speakeasy.net...

Arnie Rowland wrote:

>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?

[prabhupr]

You may try from Query Analyzer sp_who OR sp_who2

Arnie Rowland wrote:

Yes

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

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"John Bailo" <ja*****@texeme.comwrote in message
news:M-******************************@speakeasy.net...

Arnie Rowland wrote:

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?