Microsoft KB Archive/909636

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

Article ID: 909636

Article Last Modified on 12/4/2007

-

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:  Determine the maximum memory limit that is allocated for SQL Server. To do this, follow these steps:  Paste the following text into a text editor such as Notepad, and then save the file by using a &quot;.sql&quot; 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

 At the command prompt, type the following command:

osql -E -S \msfw -i  \ 

Note In this command,  is the file that you created in the previous step and   is the full path of the file that you created in the previous step.  Reduce the amount of physical memory that is allocated for SQL Server. To do this, follow these steps:  Paste the following text into a text editor such as Notepad, and then save the file by using a &quot;.sql&quot; 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)',

RECONFIGURE WITH OVERRIDE

USE master

EXEC sp_configure 'show advanced options', 0

RECONFIGURE WITH OVERRIDE

Note In this example,  is the value of the physical memory in megabytes (MB) that you want to allocate. For example, replace  with “512.”</li> At the command prompt, type the following command:

osql -E -S \msfw -i  \ 

Note In this command,  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.</li></ol>

Note The optimum physical memory allocation for SQL Server may vary for your system.</li></ol>

Additional query words: ISA Server 2004 MSDE Memory

Keywords: kbhowto kbtshoot kbprb KB909636

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.