Performance counters SqlConnection vs ODBC vs OLE DB

  • Thread starter Thread starter John S
  • Start date Start date
J

John S

I'm trying to monitor connection pooling in a web app on our development web
server. The connection string is a .Net SqlConnection string. I'm trying to
monitor connection pooling via the .Net CLR data SQLClient counters but I am
not seeing any connections being made in the pools. (pooling is on by
default) Why am I not seeing any of the counters?

I did see a reference someplace that said the counters would only show
connections made by an ODBC connection string. Can anyone confirm this?


Thanks

John
 
Hi, did you ever get a response to this? I am also experiencing the same
issue using the .NET Oracle data provider. Can the number of connections in a
pool be determined programmatically?
 
Each data provider implements performance counters differently (if they do
so at all). SqlClient exposes these counters but they don't work very well.
They have been dropped in ADO 2.0 and replaced with entirely new counters. I
do not know what Oracle has exposed as far as counters. I would, however
expect them to appear with the other counters using the Performance
Monitoring tool (Windows Admin tools) if they exist at all.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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