Click here to Skip to main content
Click here to Skip to main content

Tagged as

Twist in Performance counters for Connection pool settings

, 6 Aug 2010
Rate this:
Please Sign up or sign in to vote.
Twist in Performance counters for Connection pool settings
Hi,
 
Last week i was doing a bit search in terms of connection pooling behavior. Hence i wanted to set the counters related to connection pooling.
 
Initially i set all the counters from the '.Net CLR Data' category. and at the end i was surprised that, it was not capturing anything. Then i did some more investigation and found that those counters are only for .Net 1.0 and 1.1 and Microsoft kept those set of counters for backward compatability.
 
For ADO.NET 2.0 those counters wont work, and MS added a new set of counters under '.Net Data provider for SQLServer' - for SQL server and '.Net Data provider for Oracle' - for Oracle database.
 
Hence be proactive, before setting the counters related to connection pool.
 
More detailed information about this you can find at
 
http://msdn.microsoft.com/en-us/library/ms254503.aspx

 

http://blogs.msdn.com/b/angelsb/archive/2004/08/02/206470.aspx

 
I hope this helps!.
 
Regards,
-Vinayak

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Vinayaka Krishna Shenoy
Architect MindTree Ltd
India India
Motivated achiever who guides organizations in applying technology to business settings, provides added value, and creates project deliverables in a timely manner. An experienced Technical Consultant, have successfully led large project teams of more than 20 people from requirements gathering to implementation and support using C#, .NET ,ADO.NET, ADO.NET Entity Framework,ASP.NET,ASP.NET MVC, WCF and SQL Server.

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web02 | 2.8.140821.2 | Last Updated 6 Aug 2010
Article Copyright 2010 by Vinayaka Krishna Shenoy
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid