Select the product you need help with

BUG: SqlClient connection pooling that uses integrated security is slower than OleDb

Article ID: 316757 - View products that this article applies to.

Retired KB Content Disclaimer

This article was previously published under Q316757

This article refers to the following Microsoft .NET Framework Class Library namespace:

System.Data

Expand all | Collapse all

SYMPTOMS

Microsoft SQL Server .NET data provider (SqlClient) is slower than OLE DB .NET data provider (OleDb) when you use connection pooling with integrated security.

Back to the top | Give Feedback

CAUSE

Microsoft is researching this problem and will post new information in the Microsoft Knowledge Base as it becomes available.

Back to the top | Give Feedback

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

Back to the top | Give Feedback

The SQL Server .NET Data Provider uses its own protocol to communicate with SQL Server. It is lightweight and performs well because it is optimized to access SQL Server directly, without adding an OLE DB or Open Database Connectivity (ODBC) layer.

The OLE DB .NET Data Provider communicates to an OLE DB data source through both the OLE DB Service component (which provides connection pooling and transaction services), and the OLE DB Provider for the data source. So the slowness in connection pooling should be negligible when compared to other performance benefits when you use SQL Server .NET Data Provider to connect to SQL Server.

SQL Server .NET Data Provider is recommended for applications that use Microsoft SQL Server 7.0 or later. OLE DB .NET Data Provider is recommended for middle-tier applications that use Microsoft SQL Server 6.5 or earlier, or any OLE DB provider that supports the OLE DB interfaces.

Back to the top | Give Feedback

REFERENCES

For additional information about ADO.NET, click the article number below to view the article in the Microsoft Knowledge Base:

313590

(http://support.microsoft.com/kb/313590/EN-US/ )

INFO: Roadmap for ADO.NET

For additional information about .NET Data Providers, click the article number below to view the article in the Microsoft Knowledge Base:

313590

(http://support.microsoft.com/kb/313590/EN-US/ )

INFO: Roadmap for .NET Data Providers

For more information about Connection Pooling, see the Microsoft .NET Framework SDK Documentation, or browse to the following MSDN Web site:

Connection Pooling for the SQL Server .NET Data Provider

(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconconnectionpoolingforsqlservernetdataprovider.asp)

Back to the top | Give Feedback

Properties

Article ID: 316757 - Last Review: March 9, 2006 - Revision: 2.2

APPLIES TO

Microsoft ADO.NET (included with the .NET Framework)
Microsoft ADO.NET 1.1

kbtshoot kbbug kbnofix kbsqlclient kbsystemdata KB316757

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top | Give Feedback