Re: Slower MS SQL server

Thomas Kernen ( tkernen@deckpoint.ch )
Mon, 08 Dec 1997 12:47:21 +0100

Sure.. but if I added ram it's because I will be doing more operations
on my server. I havn't added any load onto the server and the perfomance
has already decreased. Still seems something is wrong.

More ram = less perfomance. Sounds strange to me...

Thomas

Mitch Wagers wrote:
>
> well, 300 users isn't much of a load...
>
> At 12:17 PM 12/8/97 +0100, you wrote:
> >40MB was what I used to have. the idea of adding the Ram was to be able
> >to dedicate more memory to the SQL server. but I do so, I notice the
> >slowdown.
> >
> >Thomas
> >
> >Mitch Wagers wrote:
> >>
> >> I'd set it to about 28-32mb...40 might be ok...
> >>
> >> 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
> >> >
> >> >
> >>
> >> ----------------------------------------------------------
> >> RadiusNT Mailing List lists@iea-software.com
> >
> > ----------------------------------------------------------
> > RadiusNT Mailing List lists@iea-software.com
> >
> >
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com