Oracle DB CPU Selection

[Mouhamad]

Hello everyone,

I currently have 4 DB servers runing on Intel® Itanium® Processor 9140N (18M Cache, 1.60 GHz, 533 MHz FSB) - 2 HP RX physical servers.

I'm planing to virtualize these 4 databases on 2 ESXi hosts. Due to licenses limitation (16 cores only), I'm actually confused on which CPU should I select.

Option 1:

2 ESXi Hosts

2 x CPUs Intel® Xeon® Processor E5-2643 (10M Cache, 3.30 GHz, 8.00 GT/s Intel® QPI)

Option 2:

2 ESXi Hosts

1 x Intel® Xeon® Processor E5-4650 (20M Cache, 2.70 GHz, 8.00 GT/s Intel® QPI)

Which option is more recommended? Having 2 CPUs with less cores and less cache? Or one high performance CPU with more cores and cache?

Is this architecture a good replacement for the Itanium CPUs?

Thanks,

[Mouhamad]

Any recommendation please?

[MALIK_ADEEL_IMT]

Option 1 is looking more suitable. But keep in mind the license of ESX server with cores.

Secondly please update these 4 databases are in SQL or in Oracle?

Are these in Cluster for SQL and RAS for Oracle?

Forget the performance if you think your DB load is highly heavy then go with the 2 processor because it’s not dependent upon RAM rather processor will do more role.

For architecture point of view kindly send the architecture diagram.

Thanks

Adeel Imtiaz

[mcowger]

Given that you are looking at the same total # of cores (8 /host in both configs), the question is between larger cache, I'd go for the single socket.  Larger cache = better performance on DBs - moreso (generally) than raw GHz.