Table 1 – Dell POWEREDGE R720 User Manual
Page 5
Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i
5
to the traditional row-based approach. This technology enables better compression rates within the
database, which is very beneficial for data warehouses because of the huge amount of data handled.
Column store indexes also benefit common data warehousing queries such as filtering, aggregating,
grouping, and star-join queries. (See
for more
information on Column Store Indexes.) Microsoft Fast Track Data Warehouse 4.0 guidelines incorporate
the benefit of Column Store Indexes for improved query performance.
Dell’s 12th generation server platforms, featuring enhanced onboard memory, storage, and processor
speeds, have been optimized for better data warehouse performance. The latest Intel
®
Xeon
®
E5 series
processors, larger memory capacities, higher memory speed, and third generation PCI Express slots on
the newer PowerEdge platforms ensure faster database throughput.
The Dell Microsoft Fast Track reference architectures are engineered jointly by Dell and Microsoft. The
hardware-based optimizations and best practices are proposed by Dell and the software-based
optimizations are proposed by Microsoft. This approach presents “Faster time-to-value” using
integrated, balanced, and verified architectures.
Dell Microsoft SQL Server 2012 Fast Track reference
architectures using PowerEdge R720 and PowerVault MD3620i
We are proposing two different fast track reference architectures comprised of SQL Server 2012,
PowerEdge R720, and PowerVault™ MD3620i. Table 1 lists the Proposed Reference architectures along
with the assigned Solution IDs.
Recommended reference architectures with Solution IDs
Table 1.
Reference Architecture
Solution ID
Single Server Reference Architecture
2405036
Highly Available Reference Architecture
2405110
The following sections describe the hardware and software configuration details for the recommended
reference architectures.