Memory Usage Increases When Querying an Access 97 DB w/ ASP (177226)

We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.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

SYMPTOMS

When you use Active Server Pages (ASP) to connect to an Access 97 Datasource, memory usage may increase and ASP pages may take a long time to complete requests.

The memory usage level may return to normal after the number of connections to the ASP pages decreases.

CAUSE

By default, an Access 97 Datasource has two parameters that affect system performance: MaxBufferSize and Threads. The default value for the MaxBufferSize parameter is 512 and the default value for Threads parameter is 3.

RESOLUTION

To improve performance and minimize memory usage, configure these parameters as follows:

Open the Control Panel (click Start, point to Settings and then click Control Panel.
Click the ODBC Control Panel tool.
In the ODBC Datasource Administrator, click the "System DSN" tab.
Select an Access 97 DSN and click Configure.
In the ODBC Microsoft Access 97 Setup dialog box, click Advanced on the right of the screen.
In the Set Advanced Options dialog box, select the MaxBufferSize parameter. In the Value of MaxBufferSize box, enter 8192.
Select the Threads parameter. In the Value of Threads box, enter 20.
Click OK to commit the changes and close the Set Advanced Options dialog box. Click OK to exit the ODBC Microsoft Access 97 Setup dialog box.
Quit the ODBC Datasource Administrator.

MORE INFORMATION

The recommended values of MaxBufferSize and Threads (8192 and 20) are resource dependent and should work in most cases. If the symptoms do not improve under high load, increase the value of these settings to utilize available resources.