From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Considerations for building a data warehouse - SQL Server Tutorial
From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Considerations for building a data warehouse
In this section, I'd like to talk about some different hardware considerations for a data warehouse. this course is mostly focused on developers but, often developers are asked to give input on what hardware should be purchased or what hardware should be upgraded. We're going to talk about hardware in four distinct categories: network, memory, processor and, disk. So, let's talk about each of these individually. Network bandwidth is typically not a big problem for data warehouses. A modern 10 gigabit or 1 gigabit network should be plenty of bandwidth to handle the day to day operations of a data warehouse. We do need to be concerned about a connection to the internet. If your ETL process is pulling data from an external source and we're going to pull data over the internet, it is plausible you could saturate that link. The consequences of that could vary. If your business is very focused on eight to five, Monday through Friday, and you're running the ETO process at midnight, then…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.