DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 216950 - Last Review: July 7, 2008 - Revision: 3.1

This article was previously published under Q216950
We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 7.0 running on Microsoft Windows Server 2008. IIS 7.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:
http://www.microsoft.com/technet/security/prodtech/IIS.mspx (http://www.microsoft.com/technet/security/prodtech/IIS.mspx)
For more information about IIS 7.0, visit the following Microsoft Web site:
http://www.iis.net/default.aspx?tabid=1 (http://www.iis.net/default.aspx?tabid=1)

SUMMARY

ODBC Connection Pooling enhances the performance of database connections in Active Server Pages (ASP) applications. By default, the performance counters for Connection Pooling are disabled. This article describes the counters and how to enable them.

MORE INFORMATION

To enable the performance counters, follow these steps:
  1. Open Control Panel.
  2. Double-click the ODBC icon.
  3. Click the Connection Pooling tab.
  4. In the PerfMon section, select Enable.
  5. Click OK.
In Performance Monitor, the following counters will now be listed under the ODBC Connection Pooling object:
  • Connections Currently Active: The current number of connections being used by applications.
  • Connections Currently Free: The current number of connections available for connection requests.
  • Connections Sec/Hard: The number of connections made to data sources per second.
  • Connections Sec/Soft: The number of connections from the pool per second.
  • Disconnections Sec/Hard: The number of disconnects made to data sources per second.
  • Disconnections Sec/Soft: The number of disconnects from the pool per second.
For more information on Active Server Pages and ODBC connection pooling, see the following articles in the Microsoft Knowledge Base:
ARTICLE-ID: 169470  (http://support.microsoft.com/kb/169470/EN-US/ )
TITLE: INF: Frequently Asked Questions About ODBC Connection Pooling

TITLE: HOWTO: Enable or Disable Connection Pooling in IIS 4.0

ARTICLE-ID: 164221  (http://support.microsoft.com/kb/164221/EN-US/ )
TITLE: INF: How to Enable Connection Pooling in an ODBC Application

ARTICLE-ID: 166083  (http://support.microsoft.com/kb/166083/EN-US/ )
TITLE: INF: How to Enable Connection Pooling in an OLE DB Application

ARTICLE-ID: 176056  (http://support.microsoft.com/kb/176056/EN-US/ )
TITLE: INFO: ADO/ASP Scalability FAQ

APPLIES TO
  • Microsoft Internet Information Server 2.0
  • Microsoft Internet Information Server 3.0
  • Microsoft Internet Information Server 4.0
  • Microsoft Internet Information Services 5.0
Keywords: 
kbhowto KB216950
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support