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. Knows a thing or two about Pokémon. Knows too much about SQL Agent. 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