J
John Bailo
How do I monitor the number of open connections in Sql 2000?
including ones opened by ADO and .NET processes?
including ones opened by ADO and .NET processes?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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
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
J
John Bailo
Arnie said: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?
A
Arnie Rowland
Yes
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
P
prabhupr
You may try from Query Analyzer sp_who OR sp_who2