Throw memory and CPU at it within reason, licensing constraints if any considered as was mentioned. Vast majority of DB performance problems are due to coding and/or sql and not hardware sizing, however. Best thing you can do for a database is find out top x statements by execution time, improve...