ISA MSDE and the memory throttle

On November 13, 2005, in Allocated Memory, by

You may experience high memory usage on an ISA Server 2004-based computer that logs messages to an MSDE database:
http://support.microsoft.com/?id=909636


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.



You may?  How about you will.



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.



Well it does in a SBS network… the annoying Allocated Memory alerts you get drives the network admin insane.


 


STATUS


This behavior is by design.



Who’s design?  Certainly not someone running ISA on SBS for sure.


 


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:


 


Trust me.. you will WANT to limit the memory


Follow these SBSized instructions to do so … from the www.smallbizserver.net web site — How to limit the amount of Ram ISA logging takes:


(That site tends to move things around… search the blog for “allocated memory” and you’ll find the steps)


http://msmvps.com/blogs/bradley/archive/2005/05/22/48500.aspx

 

2 Responses to ISA MSDE and the memory throttle

  1. Dale says:

    That link to that article is dead. Could you please document the steps in your blog?