Currently have a 2 socket server with a single xeon e5-2407 @2.2Ghz running SQL Server 2012. There are no performance issues at the moment but wondering for the future if it would be better to upgrade the existing CPU (higher clock speed, more cache, etc) or to add an additional matching CPU into the second slot.
Appreciate your advise on pros and cons of each and things I should be aware of.
Thank you!