Re: Slower MS SQL server

Mitch Wagers ( mwagers@ocsnet.net )
Mon, 08 Dec 1997 01:38:20 -0800

ARgh...your pagefile needs to be 30-45% MORE than your RAM amount on
anything over 96mb. Anything under 96mb needs to be 20-30% more.
So, set your pagefile to 160mb, maximum to 280mb, then reboot. This is most
likely your problem, a pagefile smaller than your RAM amount creates
excessive swapping.

At 10:31 AM 12/8/97 +0100, you wrote:
>SQL server assigned 48 MB right now.. if we add more it slows down the
>machine.
>
>The pagefile is 75MB inital upto 128 MB.
>
>Thomas
>
>Dale E. Reed Jr. wrote:
>>
>> On Mon, 8 Dec 1997, Thomas Kernen wrote:
>>
>> > Hello,
>> >
>> > since we upgraded our HP PPro 200 Mhz MS SQL server from 64 to 128 MB
>> > RAM and assigned the extra ram to the SQL server the response time seems
>> > slower. Any ideas why?
>>
>> But how much ram did you assign? Assigning too much can cause
>> excessive paging.
>>
>> Also notice that some intel machines has memory issues where they
>> can actually slow down after 64mb of memory, although if I remember
>> right the PPro should fix that.
>>
>> Dale E. Reed Jr. (daler@iea.com)
>> _________________________________________________________________
>> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
>> Internet Solutions for Today | http://www.iea-software.com
>>
>> ----------------------------------------------------------
>> RadiusNT Mailing List lists@iea-software.com
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>
>