William
Sun Jan 23 14:47:34 CST 2005
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.
__________________________________
"Anant East" <AnantEast@discussions.microsoft.com> wrote in message
news:88A1130F-940D-4EB7-94E9-A18053CD4B05@microsoft.com...
> 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?
>
> "John S" wrote:
>
>> 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
>>
>>
>>