As a side note, you can specify 1 or more processors to use in SQL 2000 and even limit it to one (and even specify which one). This is done for licensing and to allow the administrator better fine tuning. In EM go to properties for the server and you will see the choice.
-mk Mark A. Kruger, MCSE, CFG www.cfwebtools.com ..no more brochures! -----Original Message----- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 4:10 AM To: CF-Talk Subject: RE: Performance boost with Upgrade to dual processor ?? AFAIK, Both processors are used (obviously, as the actual board is designed to do this). It may not use the processor 100% and give you better performance (a common misconception that 2 processers give you 2x speed!), but for OS's which support multi-processors it does take advantage (Win2K, NT4 DPE). SQL Server has a multiprocessor version out of the box and DOES take advantage of both processors out of the box. A machine which only used a spare processor when chip A has maxed out is pointless & inefficient, you may as well pack it full of RAM, SCSI throuhout to help it on its way... My desktop machine has dual-p and I am monitoring it now, and I can confirm that it using both chips when needed, and not as a fallover solution. Hope this helps! Neil Team Macromedia Spectra ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
