My understanding from the microsoft perspective is that sql express would use both cores in one cpu. I base this on the fact small business server 2003 will only run on up to dual cpu's but dual cores are still considered By M.S. to be a single cpu. Hence you can have a sbs server showing 4 cpu's in task manager.
Andrew. Gold Coast. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DP Sent: Friday, 23 February 2007 12:44 PM To: General Practice Computing Group Talk Subject: [GPCG_TALK] SQL Express 2005 question I wonder if any egg head here can help me with this question. One of the limitations of SQL Express 2005, is its limitation to 1 CPU. http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx I can't seem to get clarification if this would affect hyperthreaded Pentium4s, AMD X2 processors or Core Duo/Core 2 Duo processors. Can they differentiate between different CPU dies and different CPU cores ? Hate to build a new server with a dual core CPU and find SQL is only using half ! David Pan _______________________________________________ Gpcg_talk mailing list [email protected] http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk _______________________________________________ Gpcg_talk mailing list [email protected] http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
