Darrell Norton's Blog [MVP]

Sponsors

The Lounge

News

  • Darrell Norton pic

    MVP logo

    View Darrell Norton's profile on LinkedIn

    Currently Reading:

    weewar.com

Advertisement

Images in this post missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at imagehelp@codebetter.com
Performance Counter Consolidation - Another Plus for Yukon

While reading an article in SQL Server Magazine, I learned that the ADO.NET connection pool counters are on the system executing ADO.NET code.  SQL Server performance counters, on the other hand, are on the system with SQL Server.  Since most apps deploy with the database on one server and the web/business/data-access logic on another, this means these related performance counters are in different places.

But with the coming of SQL Server Yukon, if you use the System.Data.SqlServer namespace (instead of SqlClient) and run your data access code on the database server, all ADO.NET and SQL Server performance counters will be easily accessible on one system.  For system administration and management, this is a good thing.


Posted 06-25-2003 6:16 PM by Darrell Norton

[Advertisement]