This page isn't exactly about it, but does point out what I was looking for.

Scroll a little down to the "Physical memory and CPU limits" table
http://support.microsoft.com/kb/889654

It says that Windows XP supports 1-2 CPUs. So to take full advantage of a quad-core I would have to change to Windows Server 2003?