In terms of overall gaming performance, the Intel Xeon E5-2450L v2 is massively better than the AMD Athlon II X4 559 when it comes to running the latest games. This also means it will be less likely to bottleneck more powerful GPUs, allowing them to achieve more of their gaming performance potential.

The Xeon E5-2450L v2 was released less than a year after the Athlon II X4, and so they are likely to have similar levels of support, and similarly optimized performance when running the latest games.

Both CPUs exhibit very powerful performance, so it probably isn't worth upgrading from one to the other, as both are capable of running even the most demanding games at the highest settings (assuming they are accompanied by equivalently powerful GPUs).

The Xeon E5-2450L v2 has 6 more cores than the Athlon II X4. 10 cores is probably excessive if you mean to just run the latest games, as games are not yet able to harness this many cores. The cores in the Athlon II X4 is more than enough for gaming purposes. However, if you intend on running a server with the Xeon E5-2450L v2, it would seem to be a decent choice.

The Xeon E5-2450L v2 has 16 more threads than the Athlon II X4. The Athlon II X4 has one thread per physical core, whereas the Xeon E5-2450L v2 uses hyperthreading and has 2 logical threads per physical core.

Multiple threads are useful for improving the performance of multi-threaded applications. Additional cores and their accompanying thread will always be beneficial for multi-threaded applications. Hyperthreading will be beneficial for applications optimized for it, but it may slow others down. For games, the number of threads is largely irrelevant, as long as you have at least 2 cores (preferably 4), and hyperthreading can sometimes even hit performance.

More important for gaming than the number of cores and threads is the clock rate. Problematically, unless the two CPUs are from the same family, this can only serve as a general guide and nothing like an exact comparison, because the clock cycles per instruction (CPI) will vary so much.

The Athlon II X4 and Xeon E5-2450L v2 are not from the same family of CPUs, so their clock speeds are by no means directly comparable. Bear in mind, then, that while the Athlon II X4 has a 1.7 GHz faster frequency, this is not always an indicator that it will be superior in performance, despite frequency being crucial when trying to avoid GPU bottlenecking. In this case, however, the difference is probably a good indicator that the Xeon E5-2450L v2 is superior.

Aside from the clock rate, the next-most important CPU features for PC game performance are L2 and L3 cache size. Faster than RAM, the more cache available, the more data that can be stored for lightning-fast retrieval. L1 Cache is not usually an issue anymore for gaming, with most high-end CPUs eking out about the same L1 performance, and L2 is more important than L3 - but L3 is still important if you want to reach the highest levels of performance. Bear in mind that although it is better to have a larger cache, the larger it is, the higher the latency, so a balance has to be struck.

The Athlon II X4 has a 1792 KB bigger L2 cache than the Xeon E5-2450L v2, but on the other hand, it is the Xeon E5-2450L v2 that has a 19 MB bigger L3 cache than the Athlon II X4. In this case, the L2 size is probably what counts, so the Athlon II X4 is likely superior in this area.

The maximum Thermal Design Power is the power in Watts that the CPU will consume in the worst case scenario. The lithography is the semiconductor manufacturing technology being used to create the CPU - the smaller this is, the more transistors that can be fit into the CPU, and the closer the connections. For both the lithography and the TDP, it is the lower the better, because a lower number means a lower amount of power is necessary to run the CPU, and consequently a lower amount of heat is produced.

The Xeon E5-2450L v2 has a 99 Watt lower Maximum TDP than the Athlon II X4, and was created with a 23 nm smaller manufacturing technology. What this means is the Xeon E5-2450L v2 will consume significantly less power and consequently produce less heat, enabling more prolonged computational tasks with fewer adverse effects. This will lower your yearly electricity bill significantly, as well as prevent you from having to invest in extra cooling mechanisms (unless you overclock).