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