Microsoft SQL Server 2008 R2 Parallel Data Warehouse Deep Dive
SQL Server Parallel Data Warehouse uses MPP (massively parallel processing) to deliver high performance and scalability on SQL Server 2008, Windows Server 2008 and industry-standard hardware. The appliance partitions large tables across multiple physical nodes, with each node having dedicated CPU, memory and storage and running its own instance of SQL Server. In this session we dive into the SQL Server Parallel Data Warehouse architecture and design and describe the appliance’s performance metrics and data scalability. We review data gathered during the Madison Technical Previews (or MTPs) with internal and external customers.