Jeff Binkley
ASA Network Computing
R>40MB was what I used to have. the idea of adding the Ram was to be
R>able to dedicate more memory to the SQL server. but I do so, I notice
R>the slowdown.
R>Thomas
R>Mitch Wagers wrote:
R>> I'd set it to about 28-32mb...40 might be ok...
R>> At 12:00 PM 12/8/97 +0100, you wrote:
R>> >currently 300 users, server running NT 4.0 sp3 + MS SQL 6.5 +
R>> >RadiusNT. HP PPro 200Mhz with 128 MB RAM + 2x 3.2 GB SCSI II HD's.
R>> >Pagefile set to 160MB, max 280Mb
R>> >Memory allocated to SQL 40 MB, if more (ex: 60 MB) then slowdown.
R>> >Rebooted twice since memory installed.
R>> >Thomas
R>> >Mitch Wagers wrote:
R>> >>
R>> >> NT uses a pagefile no matter how much RAM you have...
R>> >> How much traffic goes across the SQL? Users, etc...
R>> >> At 11:29 AM 12/8/97 +0100, you wrote:
R>> >> >Hmmm.. okay.. the machine is rebooting... but seems wired since
R>> >> >my server isn't evewn using all the ram.
R>> >> >What about the memory allocated to the SQL server.. how much
R>> >> >sould that be?
R>> >> >Thomas
R>> >> >Mitch Wagers wrote:
R>> >> >>
R>> >> >> ARgh...your pagefile needs to be 30-45% MORE than your RAM
R>> >> >> amount on anything over 96mb. Anything under 96mb needs to be
R>> >> >> 20-30% more. So, set your pagefile to 160mb, maximum to 280mb,
R>> then reboot. This is most
R>> >> >> likely your problem, a pagefile smaller than your RAM amount
R>> >> >> creates excessive swapping.
R>> >> >>
R>> >> >> At 10:31 AM 12/8/97 +0100, you wrote:
R>> >> >> >SQL server assigned 48 MB right now.. if we add more it slows
R>down the
R>> >> >> >machine.
R>> >> >> >
R>> >> >> >The pagefile is 75MB inital upto 128 MB.
R>> >> >> >
R>> >> >> >Thomas
R>> >> >> >
R>> >> >> >Dale E. Reed Jr. wrote:
R>> >> >> >>
R>> >> >> >> On Mon, 8 Dec 1997, Thomas Kernen wrote:
R>> >> >> >>
R>> >> >> >> > Hello,
R>> >> >> >> >
R>> >> >> >> > since we upgraded our HP PPro 200 Mhz MS SQL server from
R>64 to 128 MB
R>> >> >> >> > RAM and assigned the extra ram to the SQL server the
R>> response time seems
R>> >> >> >> > slower. Any ideas why?
R>> >> >> >>
R>> >> >> >> But how much ram did you assign? Assigning too much can
R>> >> >> >> cause excessive paging.
R>> >> >> >>
R>> >> >> >> Also notice that some intel machines has memory issues
R>> >> >> >> where they can actually slow down after 64mb of memory,
R>> >> >> >> although if I remember right the PPro should fix that.
R>> >> >> >>
R>> >> >> >> Dale E. Reed Jr. (daler@iea.com)
R>> >> >> >> ___________________________________________________________
R>> >> >> >> ______ IEA Software, Inc. | RadiusNT, Emerald,
R>> >> >> >> and NT FAQs Internet Solutions for Today |
R>> >> >> >>http://www.iea-software.com
R>> >> >> >> ----------------------------------------------------------
R>> >> >> >> RadiusNT Mailing List lists@iea-software.com
R>> >> >> >
R>> >> >> > ----------------------------------------------------------
R>> >> >> > RadiusNT Mailing List lists@iea-software.com
R>> >> >> >
R>> >> >> >
R>> >> >>
R>> >> >> ----------------------------------------------------------
R>> >> >> RadiusNT Mailing List lists@iea-software.com
R>> >> > ----------------------------------------------------------
R>> >> > RadiusNT Mailing List lists@iea-software.com
R>> >> ----------------------------------------------------------
R>> >> RadiusNT Mailing List lists@iea-software.com
R>> > ----------------------------------------------------------
R>> > RadiusNT Mailing List lists@iea-software.com
R>> ----------------------------------------------------------
R>> RadiusNT Mailing List lists@iea-software.com
R> ----------------------------------------------------------
R> RadiusNT Mailing List lists@iea-software.com
CMPQwk 1.42 9999