[dba-SQLServer] Multi-processor

On Wed, 18 Aug 2004 17:24:42 +1000, Michael Maddison
<michael at ddisolutions.com.au> wrote:
> Depending on the version of SQL.  IIRC you can always use 2,
> the higher end versions depend on OS and such but vary from 4 to 8.
> Zeons with hyperthreading show up as 2 cpu's in taskmgr which is cool
> but not fully utilised till Win 2003 server...
> 
> check BOL

http://www.microsoft.com/sql/techinfo/administration/2000/scalabilityfaq.asp

According to this article, Sql Server 2000 will scale up to 4
processors on a Sql Server Standard Install, course you'd want to
check your available CAL/Per Processor Licenses.

The maximum amount of ram you can acces however is only 2gb... the
link shows more info on scalability.

-- 
-Francisco