Click here to Skip to main content
12,396,149 members (62,726 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as

Stats

7.8K views
1 bookmarked
Posted

Twist in Performance counters for Connection pool settings

, 6 Aug 2010 CPOL
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.

You may also be interested in...

Comments and Discussions

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