memory question

Hi ,
we have one server with 1 GB of RAM and 500 MB is
pagefile.
Sever is not dedicated to SQL Server since there is also
Microsoft transaction server running and IIS4.
SQL Server connsumes aproximatelly 980 MB and mts alone
around 20 MB.
Thant means that mts has to go to the pagefile.
SQL Server is configured to dinamically adjust the amount
of memory used based upon demand.
Should I configure it to use fixed amount of memory or
that's bad idea ?
This is production server.
Thanks very much!SQL Server uses an algorithm that continually monitors the paging of the OS.
If SQL Server can take some benefits of getting more memory from the OS it
allocates more memory while the paging is tolerable.
In general this algorithm is efficient finding the correct amount of memory
to be allocated. If you think this amount is bigger than you wish it is
reasonable to limit the SQL Server's memory. Just take in mind that the
amount of memory allocated by the SQL Server is not arbitrary.
"Mirna" <anonymous@.discussions.microsoft.com> wrote in message
news:33d701c3fd62$475c4ec0$a001280a@.phx.gbl...
> Hi ,
> we have one server with 1 GB of RAM and 500 MB is
> pagefile.
> Sever is not dedicated to SQL Server since there is also
> Microsoft transaction server running and IIS4.
> SQL Server connsumes aproximatelly 980 MB and mts alone
> around 20 MB.
> Thant means that mts has to go to the pagefile.
> SQL Server is configured to dinamically adjust the amount
> of memory used based upon demand.
> Should I configure it to use fixed amount of memory or
> that's bad idea ?
> This is production server.
> Thanks very much!