Drupal use Quad Core?

My company is going to be migrating to Drupal in the near future and I am at the early planning stages.

Mindful of the fact that within Drupal, every time a webpage is generated, there is a query to a database, so I would like to get a very fast server to more than make up for this lag.

Can someone point me to some documentation as to whether or not Drupal will use Quad Core technology and where I can go within the drupal config files to tweak performance based on server hardware specs?

Any advice or input on medium to high end server purchase for a multiuser/high traffic Drupal site would be much appreciated.