At about 1 hour into the game for some reason cpu 2 and 3 traded loads, which is why I presented an average for 2 & 3.
Great report Tom... have make some test too on my intel system :
- GFX : planet high, all the rest very High
- Huge mutlistar system with 9 AI, using the pre-release of 7DS ( huge mod ) and having 10 different race in game
- OS/Soft : Kubuntu, Wine, Opengl, Play-on-Linux
- Material : 2 quad core Xeon 2.66 ghz, 16 gb ddr2 serial ram 8 channel interleace in raid mode with ECC 8bits, Nvidia 8800 ultra 768 mb
About the graph below... first line is the 4 core from the first processor, second line is the 4 core from the second processor, the first graph from the last line is the processor global... one unit is 15 minutes... have test during around 1 hours...

The core that Sins use change always with time... in my case, it is a bios function of the Xeon... since i have choice to run the server board in silent mode, once a core become hot, it change of core in a automatic way...
Now one time, one core was used at 100% by sins... In the global graph, it is around 12% for sins... the little spike are mainly system application... 12%*8 make a max of 96%... ram used was almost 4.5 gb...
The first 15 minutes was used for build a huge fleet... the next 20 one for seek a ennemy... once i have destroy the fleet of two AI and take severak ennemy planet, CPU use have know a huge drop for a short time ( time needed for the AI and myself to rebuild fleet )...
Now, for my test, i have use the biggest map, the biggest GFX ( planet on veryhigh crash the game in some case, so i keep it on high only ), the maximum of player who is 10 ( 11 if you count the pirate ) and use the biggest mod who exist now ( almost 1gb in 7zip format !!! )... with all this, the maximum use of one core have not yet reach the 100%... My Cpu speed is a little slower that yours... but resultat are similar...
Conclusion are similar to you... a single core 2.8 or 3.0 ghz is enough ( need some power for the OS and other application running )... a dual core 2.6 ghz will be able to support the biggest map, with the best gfx, with the biggest mod and with the max of player...
Ram is a other problem... the biggest everything have go over the 6 gb use after 10 hours of game... First beta of Entrenchment have reach almost 11 gb ( reason was the mine spam on a huge map with 10 player, but from what i have read, the problem was resolved in the recent beta )...
I guessing that there is no way to treat 2 cores as one.
It is not really needed... some processor allow the implementations of hardware-assisted x86 virtualization ( Intel VT and/or AMD V ) in the bios... this along with VMware ESX server who don't need a host OS... The CPU virtualization increase the server utilization without the risk of critical services being starved for CPU resources. VMware ESX uses intelligent process scheduling and load balancing across available processors to manage the execution of virtual machine processing.
But if needed, Vmware ESX have a 4-way Virtual SMP... This enable a single virtual machine to use up to four physical processors simultaneously. VMware ESX extends this unique feature from two to four processors. With 4-way Virtual SMP even the most processor intensive software applications can be virtualized. From test, this work with multicore when core are not build on a single dye ( multiship modules ).... by example, my Xeon quad core are in reality 2 dual core... ESX find 4 processor with two core in my system... this allow me to use the 4-way system and emulate a processor at 10 ghz ( some power is used for the virtualization )...
PS : i am not sure that ESX will work on usual desktop computer !!! But server board with good graphic card and good sound card become ultimate game computer...
PS2 : My desktop computer is mainly used for 3D render ( i am freelancer 3D modeler ), using 4 independant 64 bits render engine reducing the render time from 1 night on my Pentium 4 3 ghz to 15 minutes on my actual machine... it is a professional use... the only game on it is "Sins of Solar Empire" because i have begin make model for mod a few month ago... and because "i am in love" with these game...