Jeff Binkley
ASA Network Computing
R>Hmmm.. okay.. the machine is rebooting... but seems wired since my
R>server isn't evewn using all the ram.
R>What about the memory allocated to the SQL server.. how much sould
R>that be?
R>Thomas
R>Mitch Wagers wrote:
R>> ARgh...your pagefile needs to be 30-45% MORE than your RAM amount on
R>> anything over 96mb. Anything under 96mb needs to be 20-30% more.
R>> So, set your pagefile to 160mb, maximum to 280mb, then reboot. This
R>> is most likely your problem, a pagefile smaller than your RAM
R>> amount creates excessive swapping.
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 down
R>> >the machine.
R>> >The pagefile is 75MB inital upto 128 MB.
R>> >Thomas
R>> >Dale E. Reed Jr. wrote:
R>> >>
R>> >> On Mon, 8 Dec 1997, Thomas Kernen wrote:
R>> >> > Hello,
R>> >> > since we upgraded our HP PPro 200 Mhz MS SQL server from 64 to
R>> >> > 128 MB RAM and assigned the extra ram to the SQL server the
R>response time seems
R>> >> > slower. Any ideas why?
R>> >> But how much ram did you assign? Assigning too much can cause
R>> >> excessive paging.
R>> >> Also notice that some intel machines has memory issues where they
R>> >> can actually slow down after 64mb of memory, although if I
R>> >> remember right the PPro should fix that.
R>> >> Dale E. Reed Jr. (daler@iea.com)
R>> >> _________________________________________________________________
R>> >> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
R>> >> Internet Solutions for Today | http://www.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