Dell PowerEdge External Media System 1434 Dell SMB Reference Configuration for
Dell PowerEdge External Media System 1434 Manual
View all Dell PowerEdge External Media System 1434 manuals
Add to My Manuals
Save this manual to your list of manuals |
Dell PowerEdge External Media System 1434 manual content summary:
- Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 1
Dell SMB Reference Configuration for Microsoft® SQL Server® 2012 Fast Track Data Warehouse on PowerEdge R720xd This whitepaper describes the Dell Microsoft SQL Server Fast Track reference architecture configuration and performance details Database Solutions Engineering Anthony Fernandez Mayura - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 2
Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd This document is for informational purposes only and may contain typographical errors and technical inaccuracies. The content is provided as is, without express or implied warranties of any - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 3
Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd Contents Introduction ...4 Microsoft SQL Server Fast Track Data Warehouse 4 Dell Fast Track Data Warehouse Reference Architecture 4 Hardware Component Architecture 5 Internal Storage - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 4
. These methodologies yield performance much better than that of traditional data warehousing systems. Based on this, Dell has developed a reference guide that helps customers implement FTDW on Dell hardware. Dell Fast Track Data Warehouse Reference Architecture In order to optimize data warehouse - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 5
Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd Hardware Component Architecture Redundant and robust tests have been conducted on Dell's PowerEdge servers to determine best practices and guidelines for building a balanced FTDW system. - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 6
of the R720xd Server, refer to the Power Edge R720xd Technical Guide, a link to which is provided in the References section of this document. Processors The Microsoft Fast Track 4.0 Reference Guide describes how to achieve a balance between components such as storage, memory, - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 7
Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd Refer to the Microsoft Fast track 4.0 Reference Guide for detailed recommendations on system memory configuration. Internal Storage Controller (PERC H710P Mini) Settings The Dell PERC H710P Mini is an - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 8
Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd Figure 4. Internal Storage Controller Settings RAID configuration One of the most critical decisions to make when deploying a new storage solution is which RAID type(s) to use, because that - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 9
access. It is also very important to assign the appropriate virtual disk and mount-point names to the configuration in order to simplify troubleshooting and performance analysis. Mount-point names should be assigned in such a way that the logical file system reflects the underlying physical storage - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 10
production, staging, and system temp databases were deployed per the recommendations provided in the Microsoft Fast Track Data Warehouse 4.0 Reference Guide. Application Configuration The sections below explain the settings applied for the operating system and database layers. Windows Server 2008 R2 - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 11
the SQL Server buffer pool. However, at this time SQL Server 2012 does not support the use of -T834 in the case that Column Store Indexes (CSI) are to validate the configuration. Please refer to the Fast Track Reference Guide (link provided in the reference section) for detailed guidelines. Figure - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 12
10 Single RAID 1 Disk Group Synthetic I/O rate: 2669 MB/s The second synthetic I/O test with SQLIO was performed with a large file to ensure reads are serviced from the storage system hard drives instead of from cache. Figure 8 shows the maximum real rate that the system is able to provide with - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 13
Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd Figure 8. SQLIO Real Rate Test from Disk (Large File) POWER EDGE R720-XD SQL Server 2012 Enterprise Single Socket Intel four core Aggregate Synthetic I/O rate: 2014 MB/s H710P PERC - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 14
Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd For the validated Fast Track configuration, the aggregate BCR was 950.75 MB/s. During the evaluation cycle, the system configuration was analyzed for multiple query variants (simple, average, - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 15
. High-availability at all the levels of setup (host, switches, and storage). Help to avoid the pitfalls of improperly-designed and configured systems. Reduced future support costs by limiting solution re-architect efforts because of scalability challenges. 15 - Dell PowerEdge External Media System 1434 | Dell SMB Reference Configuration for - Page 16
www.dell.com\services Dell Support www.dell.com\support OLTP and OLAP http://datawarehouse4u.info/OLTP-vs-OLAP.html Microsoft Fast Track Data Warehouse and Configuration Guide Information www.microsoft.com/fasttrack http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91448AB733B1AF
Database Solutions Engineering
Anthony Fernandez
Mayura Deshmukh
May 2012
Dell SMB Reference Configuration for
Microsoft® SQL Server® 2012 Fast Track
Data Warehouse on PowerEdge R720xd
This whitepaper describes the Dell Microsoft SQL Server Fast Track
reference architecture configuration and performance details