You may experience high memory usage on an ISA Server 2004-based computer that logs messages to an MSDE database (909636)


The information in this article applies to:

  • Microsoft Internet Security and Acceleration Server 2004, Standard Edition
  • Microsoft Internet Security and Acceleration Server 2004, Enterprise Edition

SYMPTOMS

You may experience high memory usage on a Microsoft Internet Security and Acceleration (ISA) Server 2004-based computer that is configured to log messages to a Microsoft SQL Server Desktop Engine (MSDE) database.

CAUSE

Microsoft SQL Server uses the available physical memory to optimize MSDE insertion and query processes. SQL Server is designed to release physical memory as soon as there is a request for physical memory from other processes that are running on the computer.

Note This behavior by SQL Server does not affect the regular operation of other processes on the ISA Server 2004-based computer.

STATUS

This behavior is by design.

MORE INFORMATION

Although this behavior does not affect the regular operation of other processes, you may want to limit the amount of physical memory that is allocated for SQL Server. To do this, follow these steps:
  1. Determine the maximum memory limit that is allocated for SQL Server. To do this, follow these steps:
    1. Paste the following text into a text editor such as Notepad, and then save the file by using a ".sql" extension. For example, save the file as "checksqlmemory.sql."

      USE master
      EXEC sp_configure 'show advanced options', 1
      RECONFIGURE WITH OVERRIDE

      USE master
      EXEC sp_configure 'max server memory (MB)'

      USE master
      EXEC sp_configure 'show advanced options', 0
      RECONFIGURE WITH OVERRIDE

    2. At the command prompt, type the following command:

      osql -E -S ServerComputerName\msfw -i Path\checksqlmemory.sql

      Note In this command, checksqlmemory.sql is the file that you created in the previous step and Path is the full path of the file that you created in the previous step.
  2. Reduce the amount of physical memory that is allocated for SQL Server. To do this, follow these steps:
    1. Paste the following text into a text editor such as Notepad, and then save the file by using a ".sql" extension. For example, save the file as "setchecksqlmemory.sql."

      USE master
      EXEC sp_configure 'show advanced options', 1
      RECONFIGURE WITH OVERRIDE

      USE master
      EXEC sp_configure 'max server memory (MB)', MaxServerMemory
      RECONFIGURE WITH OVERRIDE

      USE master
      EXEC sp_configure 'show advanced options', 0
      RECONFIGURE WITH OVERRIDE

      Note In this example, MaxServerMemory is the value of the physical memory in megabytes (MB) that you want to allocate. For example, replace MaxServerMemory with "512."
    2. At the command prompt, type the following command:

      osql -E -S ServerComputerName\msfw -i Path\setchecksqlmemory.sql

      Note In this command, setchecksqlmemory.sql is the file that you created in the previous step and Path is the full path of the file that you created in the previous step.

    Note The optimum physical memory allocation for SQL Server may vary for your system.
Modification Type:MinorLast Reviewed:11/10/2005
Keywords:kbhowto kbtshoot kbprb KB909636 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.