Michael Maddison
michael at ddisolutions.com.au
Wed Aug 18 02:24:42 CDT 2004
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 cheers Michael M Yes, Sql Server will use multiple processors _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com