Jeff Binkley
ASA Network Computing
R>well, 300 users isn't much of a load...
R>At 12:17 PM 12/8/97 +0100, you wrote:
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>>
R>>Thomas
R>>
R>>Mitch Wagers wrote:
R>>>
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>>> >> >
R>>> >> >What about the memory allocated to the SQL server.. how much
R>>> >> >sould that be?
R>>> >> >
R>>> >> >Thomas
R>>> >> >
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
R>>> >> >> be 20-30% more. So, set your pagefile to 160mb, maximum to
R>>> 280mb, 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
R>slows 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
R>>> >> >> >> right the PPro should fix that.
R>>> >> >> >>
R>>> >> >> >> Dale E. Reed Jr. (daler@iea.com)
R>>> >> >> >> __________________________________________________________
R>>> >> >> >> _______ IEA Software, Inc. | RadiusNT,
R>>> >> >> >> Emerald, and NT FAQs Internet Solutions for Today |
R>>> >> >> >>http://www.iea-software.com
R>>> >> >> >>
R>>> >> >> >> ---------------------------------------------------------
R>>> >> >> >- RadiusNT Mailing List lists@iea-software.com
R>>> >> >> > ----------------------------------------------------------
R>>> >> >> > RadiusNT Mailing List lists@iea-software.com
R>>> >> >> >
R>>> >> >> >
R>>> >> >>
R>>> >> >> ----------------------------------------------------------
R>>> >> >> RadiusNT Mailing List lists@iea-software.com
R>>> >> >
R>>> >> > ----------------------------------------------------------
R>>> >> > RadiusNT Mailing List lists@iea-software.com
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>> ----------------------------------------------------------
R>> RadiusNT Mailing List lists@iea-software.com
R>>
R>>
R> ----------------------------------------------------------
R> RadiusNT Mailing List lists@iea-software.com
R>
CMPQwk 1.42 9999