• There are some serious errors and misconceptions and this is only going to add to more users messing with options they don't understand!.

    Procs, the number are doubled under w2k3 and procs are also depenedant upon the underlying o/s. You should never check the reserve physical memory unless you are using a fixed memory ( with min and max the same ) Note that once you use awe or instances you MUST fix memory sizes otherwise you will have problems.

    Boost priority should ONLY ONLY ONLY ever be used if ms support tell you, this setting causes major problems. ( it was I understand added for SBS where multiple apps run on a server - the guys I've spoken to at microsoft wish this option was removed as it causes so many support calls )

    fibre mode is relevent only on large multiproc boxes where cpu is almost maxed out and you have very high levels of context switches.

    I could go on -- I fail to see how you can quote the admin guide - did you really read it properly? and how on earth did you come to some of your calculations?

    My advice ( and that of microsoft ) is that unless you really know what you're doing and then really only if microsoft support tell you all config settings should remain "out of the box" Changing settings on a production server could easily bring the system down.

     

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/