says...
Quote:> Hi, I am experiencing problems with IIS 3.0 and SQL server 6.5.
> As they run on an NT server the system memory is increasing all the time.
> Over a period of a few hours the machine's memory usage goes from 59Mb to
> 290Mb without a particularly heavy load on the server!
> On the task manager the time that the cpu is in kernel mode is unusually
> high.
> I am currently downloading the NT4 service pack to see if a new version of
> IIS will help.
> Anybody have any immediate ideas for solving this problem?
Check the SQL Server settings "memory" and "set working set size". The
memory setting defines the maximum number of 2k pages you've told the
server it can grab. There's some good guidelines for this setting, but
from the hip I recommend about half the server's memory be allocated to
SQL Server.
If the second setting is set to false (0), which is the default, this
tells SQL Server not to grab all the memory from NT when it starts.
You'll notice memory usage gradually increases as SQL Server finds new
uses for it. It will take up to the memory setting, and won't give any
back. If this setting is set to true (1), all the memory is grabbed when
the server starts.
If you want to reduce the server memory requirements, lower the memory
setting. This will probably affect performance.
--
Ben McEwan, President, Geist, LLC
by