HOWTO to limit the amount of memory for ISA Server 2004 SP2

Submitted by hswong3i on Thu, 2006/02/23 - 01:54

what's happened to my server ??
sqlservr.exe can use up to 2xxMB of memory !?
so what is this ??
sqlservr - sqlservr.exe - Process Information

ok so why it use up such many of memory ??
ISA SQL Instance Using a Lot of Memory

and here is the final solution to fix it:
You may experience high memory usage on an ISA Server 2004-based computer that logs messages to an MSDE database

will this setting be reset after reboot ??
i don't even know that
and i will test it out later

here i post the related .sql file
i have limit the sqlservr.exe to use only 32MB ram
see how to use these files in the above linkage


Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <h1> <h2> <h3> <h4> <h5> <h6> <em> <strong> <code> <del> <blockquote> <q> <sub> <p> <br> <ul> <ol> <li> <dl> <dt> <dd> <a> <b> <u> <i> <sup> <acronym> <pre> <img>
  • Lines and paragraphs break automatically.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • Images can be added to this post.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.