Choosing the Right Processor for your SQL Server Workload

Updated with some reflections over the past month.

Phoebix

Last year, we planned to move our data warehouse from a 2 socket server to a 4 socket server that was left in the data centre from an abandoned project to virtualize our desktops.

  • The 2 core server: Dell R610, with 2 Intel E5640 @2.66Ghz and 64GB of RAM
  • The 4 core server: Dell R910, with 4 Intel X7550 @2.00Ghz and 128GB of RAM

Both were 64bit OS running SQL Server Enterprise. We decided to test the server before moving directly, so our first test was to load a large import (40 GB) using SSIS from a temporary table in one database to the data warehouse and process the relative cube.

View original post 777 more words

Author: Richie Lee

Full time computer guy, part time runner. Full time Dad, part time blogger. Pokémon Nut. Writer of fractured sentences. Maker of the best damn macaroni cheese you've ever tasted.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s