What paging file would you recommend for:
32 x CPU
32 GIG RAM
Many DB using many tera's
Windows2003
SQL Server 2000
I know a little about paging and that SQL is intelligent enough to
prevent swapping. But I'd still like to tune the OS to rule out future
performance issues.Thanks John, we are soon to be STRESS testing our new servers, so will
definately be monitoring the resources side of things for bottlenecks.
Thanks once again. Greg
John Bell wrote:
> Hi
>
> "Microsoft MSMQ Setup" wrote:
> > What paging file would you recommend for:
> >
> > 32 x CPU
> > 32 GIG RAM
> > Many DB using many tera's
> > Windows2003
> > SQL Server 2000
> >
> > I know a little about paging and that SQL is intelligent enough to
> > prevent swapping. But I'd still like to tune the OS to rule out future
> > performance issues.
> >
> This seems to vary depending on who you talk to! I am not sure if MS publish
> a value for Windows 2003, for Windows XP the default size will be RAM * 1.5,
> but I have seen other figures such as RAM * 2.5 or RAM + 12. What you should
> be doing is monitoring the usage of the pagefile and to make sure that memory
> is not a bottleneck.
> John
No comments:
Post a Comment