FIX: IIS Performance Degrades with a Bad Connection

Article translations Article translations
Article ID: 168250 - View products that this article applies to.
This article was previously published under Q168250
BUG #: 4636 (odbc3)
Expand all | Collapse all

SYMPTOMS

Microsoft Internet Information Server (IIS) version 3.0 may experience degrading performance when there is a bad connection in the ODBC connection pool and the backend database server for the bad connection is not available for connecting.

CAUSE

With connection pooling enabled, whenever IIS users try to connect to the same backend database server, the ODBC driver manager tests the existing connection in the pool before reusing the connection. If there is a bad connection in the pool and the backend database server for the bad connection is unavailable, the ODBC driver manager keeps testing the bad connection, and IIS essentially creates a thread for each attempted connection. The testing connection process takes time, and the IIS threads are also being generated continuously, which causes the performance to degrade.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Open Database Connectivity version 3.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft Open Database Connectivity, version 3.0. For more information, contact your primary support provider.

MORE INFORMATION

A new registry key and ODBC API have been introduced to avoid testing the connection continuously. The new registry key is under:
HKEY_LOCAL_MACHINE\Software\Odbc\ODBCINST.INI \ODBC Connection Pooling\Retry Wait
The Retry Wait registry key is a value of REG_SZ and the default value is 120 (in second). The value for the Retry Wait registry key can be set by calling ODBCSetTryWaitValue ODBC API. The ODBCSetTryWaitValue API takes a DWORD argument.

If there is a bad connection in the pool, the ODBC driver manager will attempt to connect before the connection can be reused for the first time. If the connection still fails, the ODBC driver manager returns the error and marks the connection with the time. From that point until the RetryWait value expires, the ODBC driver manager returns a failure without testing the connection.

Properties

Article ID: 168250 - Last Review: May 12, 2001 - Revision: 1.0
APPLIES TO
  • Microsoft Open Database Connectivity 3.0
Keywords: 
kbbug kbfix kbinterop kbprogramming KB168250
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.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com