November 11, 2002 at 10:00 am
My organization will be going live soon with an 8 processor server. Is there any 'rule-of-thumb' sp_configure changes that need to be made with that many processors? I am assuming the answer will be to monitor the box once its up and running and configure accordingly but I figured I would ask anyways.
Thanks
November 11, 2002 at 10:41 am
I think that should work.
November 11, 2002 at 12:54 pm
As hardware variances and other things can have an effect you need to monitor it either way. However, past experience and comparison charts I have seen (sorry do not remember where) have said that anything above 4 processors do not have a major impact on performance. ALso, to save licensing have you look at the new line of INTEL processors that utilize free processor areas to execute simultaneous threads (Hyper-Threading). It is like having 2 CPUs for the price of one as is quite amazing. Check it out on the XEON here
The cost isn't bad either from what I have heard.
November 11, 2002 at 4:38 pm
Thats about it. I have one and have had no problems. If you're loading it with extra memory make sure you have the boot.ini set up right and the awe enabled.
Andy
November 11, 2002 at 6:21 pm
Also remember if putting NT on it, you can't run setup with > 2Gb. not sure if this is the same with 2000. Often there is a bios setting which fools the OS into believeing there is only 256Mb installed.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 11, 2002 at 7:22 pm
BOth NT and 2000 can be enabled to run more than 2GB of memory based on a switch added to the Boot.ini and enabling in SQL. Look at AWE and PAE in SQL BOL.
November 12, 2002 at 3:03 am
The memory can be configured once running but the setup of NT causes a STOP if more than 2Gb of memory is configured. There is a KB article but I can't find it
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 12, 2002 at 3:40 am
SOrry, my mistake, I misread and did not pick up the "setup" part of the post.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply