Server Specs for DW Server

Question

Post reply

Server Specs for DW Server

GBeezy

SSCarpal Tunnel

Points: 4723
More actions
March 10, 2014 at 8:29 am

#283302

I understand that what I am about to ask will come across as very general, but I need start somewhere!!!
I have been tasked with building a data warehouse for my employer. I have zero experience with this!!! I do have a good deal of experience with SSIS, just not building ETL for a DW. One aspect they want me to figure out is what kind/how fast/how beefy does the server need to be for a DW. To that, I have no idea. I have assumptions and I have been attempting to research this, but I read so many different things, its hard figure out whats legit and what makes sense for what I am trying to do.
Can anyone please weigh in on this?
1. How many CPU's/how fast, how much memory, how fast/what type of Hard drives?
2. What type of RAID configuration should be implemented?
3. I have to assume a VM is not the way to go?
I understand that this could be clustered, but that is more up to business, i.e. how long can live with out this data.
I think I am going to try to following the Kimball Methodology; extracting to a staging area and then do the heavy ETL from there.
Direct answers to these questions, if you can point me to articles to read, etc...will all be greatly appreciated!!!
Also, if anyone can suggest a book to buy for a Data Warehouse beginner, that would be greatly appreciated as well!!!
Thank You

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 1

VM is definitely not the way to go.

These are best ones ..

http://www.amazon.com/The-Data-Warehouse-Toolkit-Dimensional/dp/1118530802/ref=pd_sim_b_5?ie=UTF8&refRID=1D8GA5JQC7W2V1WXYAK8

http://www.amazon.com/Building-Data-Warehouse-Examples-Experts/dp/1590599314

--

SQLBuddy

GBeezy SSCarpal Tunnel Points: 4723 More actions · Answer 2

Thanks SQL Buddy!!!

I've been reading up on the Kimball Methodology and actually just purchased The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling about an hour ago.

Thanks for the suggestions!!

Would you have any insight into the Server specs for a Data Warehouse Server?

Thanks Again!!