Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 316757 - Last Review: March 9, 2006 - Revision: 2.2
BUG: SqlClient connection pooling that uses integrated security is slower than OleDb
This article was previously published under Q316757
This article refers to the following Microsoft .NET
Framework Class Library namespace:
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.
CAUSE
Microsoft is researching this problem and will post new
information in the Microsoft Knowledge Base as it becomes available.
STATUS
Microsoft has confirmed that this is a bug in the Microsoft
products that are listed at the beginning of this article.
MORE INFORMATION
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.
REFERENCES
For additional information about ADO.NET, click the article
number below to view the article in the Microsoft Knowledge Base:
313590Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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://kbalertz.com/Feedback.aspx?kbNumber=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:
APPLIES TO
- Microsoft ADO.NET (included with the .NET Framework)
- Microsoft ADO.NET 1.1
| kbtshoot kbbug kbnofix kbsqlclient kbsystemdata KB316757 |
Retired KB Content DisclaimerThis 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.
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please