J John Bailo Jul 26, 2006 #1 How do I monitor the number of open connections in Sql 2000? including ones opened by ADO and .NET processes?
How do I monitor the number of open connections in Sql 2000? including ones opened by ADO and .NET processes?
A Arnie Rowland Jul 26, 2006 #2 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
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
J John Bailo Jul 26, 2006 #3 Arnie said: One way is in Enterprise Manager. Select Management, Current Activity, Process Info. Click to expand... 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 said: One way is in Enterprise Manager. Select Management, Current Activity, Process Info. Click to expand... 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 Jul 26, 2006 #4 Yes -- Arnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous
Yes -- Arnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous
