At 12:00 PM 12/8/97 +0100, you wrote:
>currently 300 users, server running NT 4.0 sp3 + MS SQL 6.5 + RadiusNT.
>HP PPro 200Mhz with 128 MB RAM + 2x 3.2 GB SCSI II HD's.
>
>Pagefile set to 160MB, max 280Mb
>Memory allocated to SQL 40 MB, if more (ex: 60 MB) then slowdown.
>
>Rebooted twice since memory installed.
>
>Thomas
>
>Mitch Wagers wrote:
>>
>> NT uses a pagefile no matter how much RAM you have...
>> How much traffic goes across the SQL? Users, etc...
>>
>> At 11:29 AM 12/8/97 +0100, you wrote:
>> >Hmmm.. okay.. the machine is rebooting... but seems wired since my
>> >server isn't evewn using all the ram.
>> >
>> >What about the memory allocated to the SQL server.. how much sould that
>> >be?
>> >
>> >Thomas
>> >
>> >Mitch Wagers wrote:
>> >>
>> >> 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
>> >> >
>> >> >
>> >>
>> >> ----------------------------------------------------------
>> >> RadiusNT Mailing List lists@iea-software.com
>> >
>> > ----------------------------------------------------------
>> > RadiusNT Mailing List lists@iea-software.com
>> >
>> >
>>
>> ----------------------------------------------------------
>> RadiusNT Mailing List lists@iea-software.com
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>
>