How to Build a Data Warehouse with EMC, Cisco, and Microsoft

The Microsoft SQL Server Fast Track Data Warehouse 3.0 reference configurations were built, designed, and tested by Cisco, EMC and Microsoft to provide:

  • Architectural guidance for customers, partners and reseller who are evaluating, planning, or deploying Microsoft SQL Server based data warehouse solutions
  • Performance and capacity guidance for selecting server, storage and connectivity solutions where out-of-the box performance and ability for rapid deployments are important

Reference Configurations

These reference configurations use Cisco UCS C-Series rack-mount servers and EMC VNX5300™ storage systems connected through Cisco Nexus 5500 series switch using Fibre Channel over Ethernet (FCoE) protocol.

Two reference configurations are introduced – the medium enterprise configuration and large enterprise configuration are designed to meet a broad range of data warehouse requirements, scaling from 8 up to 40 terabytes using compression capabilities in SQL Server 2008 R2 Enterprise.

  • The medium enterprise configuration consists of Cisco UCS C250 M2 Extended-Memory Rack-Mount Server equipped with two Intel® Xeon® Processors X5680 (3.33 GHz, 12MB L3 Cache, 130W), 96 GB of memory and two Cisco UCS P81E Virtual Interface Cards. The storage system consists of an EMC VNX5300 connected through a Cisco Nexus 5548 switch. See Table 1 for the configuration details, Table 2 for the benchmark results, and Table 3 for Bill of Materials.
  • The large enterprise configuration consists of a Cisco UCS C460 M1 High-Performance Rack-Mount Server equipped with four Intel® Xeon® X7560 Processors (2.26GHz, 24MB cache, 130W), 256 GB of memory and eight QLogic QLE8152 Dual Port 10 Gb Converged Network Adapters. The storage consists of two EMC VNX5300 storage systems connected through a Cisco Nexus 5548 switch. See Table 4 for the configuration details, Table 5 for the benchmark results, and Table 6 for Bill of Materials.

You can download the entire paper here.

Advertisements

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