Home

Dell PowerEdge R720 Reference Configuration

image

Contents

1. Adapter Settings Profile Storage Server 7 Header Data Split 2014 Bytes Interrupt Moderation Large Send Offload IPv4 Large Send Offload IPv6 Locally Administered Address 1 link State Fvent Pama Enables Jumbo Packet capability for TCP IP packets In situations where large packets make up the majority of traffic and additional latency can be tolerated Jumbo Packets can reduce CPU utilization and improve wire efficiency Jumbo Packets are larger than standard Ethernet frames which are approximately 1 5k in size Jumbo Packet Note Changing this setting may cause a momentary loss of connectivity zi 12 Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i PowerConnect 8024 Switch Tuning For the reference configuration Dell proposes to have J umbo frames enabled on all participating iSCSI ports of the configuration The MTU size of all the concerned ports should be set to 9216 Figure 9 shows how to enable jumbo frames for all the switch ports from the serial console window Figure 9 Enabling J umbo frames on switch ports console gt enable console conf igure console config interface range Tengigabitethernet A11 console config if mtu 9216 console config if exit console config exit console copy running config startup config This operation may take a few minutes Management interfaces will not be available
2. EE EEEN 4 Introduction to Microsoft SQL Server Fast Track reference architectures cccrcccrerrererrerer 4 What s new with Dell Microsoft Fast Track reference architeCctures cccceeeeeeee eect ee eee etna ees 4 Dell Microsoft SQL Server 2012 Fast Track reference architectures using PowerEdge R720 and POWEIV aUIIMD 36 201i Sessa toto aE a sae atet ents seagate E T ua neue eee eae A 5 Single server reference architecture eeren EEEE nee e eed 6 Highly available reference architecture sis tcindowsiica wows ales wetreaniaudehadta e i ia 7 Reference architecture configuration hardware component details cceeeeeee cette eter teed 8 Reference architecture configuration tuning details cece eee e eee teeta eee eaten eee 9 Reference architecture performance detailS cc cececee cece ENEEK E N EE ERNES 16 SUMMA Y eain nE ENEA EE REE RAEE EENDE EEEE ETNEA eau EAE ENEE AEEA 16 Tables Table 1 Recommended reference architectures with Solution IDS eerren 5 Table 2 Single server reference architecture detailS cece cece eee eee eee teeters 6 Table 3 Highly available reference architecture details cceee eee e eect eee eee eee eee need 7 Table 4 Mount point naming and storage enclosure MapPiNG cece cece eee e eee eee ed 15 Table 5 Performance Metrics eigse reseni ra E E veda SAT E DEEA EP A TESA E 16 Figures Figure 1 Single server reference architecture ce
3. Microsoft SQL Server 2012 Fast Track Reference Configuration using PowerEdge R720 and PowerVault MD3620 This whitepaper describes the Dell Microsoft SQL Server Fast Track reference architecture configuration and performance results Jisha J Dell Database Solutions Engineering Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i 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 kind 2012 Dell Inc All rights reserved Dell and its affiliates cannot be responsible for errors or omissions in typography or photography Dell the Dell logo PowerVault and PowerEdge are trademarks of Dell Inc Intel and Xeon are registered trademarks of Intel Corporation in the U S and other countries Microsoft Windows and SQL Server are either trademarks or registered trademarks of Microsoft Corporation in the United States and or other countries Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks and names or their products Dell disclaims proprietary interest in the marks and names of others July 2012 Rev 1 0 Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i Contents Executive SUM all Ver erih tps cale EEE EE EEA EEE N AE SANEA E EI EEA EEEI
4. Set the virtual disk segment size to 256KB For the recommended Fast Track configurations Dell recommends setting the virtual disk segment size to 256KB This benefits the large block sequential workloads The segment size is set in the Customize Advanced Virtual Disk Parameters window Figure 7 Figure 7 Modifying the virtual disk segment size FS MD3620F_FT1 Customize Advanced Virtual Disk Parameters Create Use this screen to change any advanced virtual disk parameters If you want a tailored I O characteristic select the Custom radio button and enter values for the multiplier and the segment size What are the virtual disk I O characteristics wi is ship Virtual Disk name 8 Virtual Disk capacity 54 000 GB Virtual Disk I O characteristics type File system typical Database Multimedia Custom r ey RAID controller module ownership C Soto Slot 1 lt Back Finish Cancel Help Intel X540 10GbE NIC tuning For the specific reference configurations J umbo Packets were enabled on all NIC ports and set to a packet size of 9014 bytes All other parameters were set to the default settings The jumbo packet settings can be changed using the Advanced tab of the Adapter properties window Figure 8 Figure 8 Enabling J umbo packets on network adapter ports x Teaming VLANs BootOptions Driver Details General Link Speed Advanced DataCenter intel Advanced
5. Socket 4 Total Logical Processors HT Enabled 16 per Server Total Installed Memory 128GB 1600Mhz per Server Network Adapters Su a arl e e Da Multipathing Software Dell MD Series DSM Multipathing Policy Least Queue Depth Default 1 PowerVault MD3620i with a MD1220 rerna trage Expansion Enclosure Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i Disks 48 146G 6Gbps 15k SAS drives Network Switch 2 PowerConnect 8024 Operating System Windows 2008 R2 SP1 Enterprise Edition Clustering Software Microsoft Windows Clustering Database Software SQL Server 2012 Enterprise Edition Reference architecture configuration hardware component details This section describes the hardware details used for the specific reference configurations Dell PowerEdge R720 server Dell launched the 12 generation PowerEdge servers with support for Intel Xeon E5 series processors The PowerEdge R720 is a 2 socket 2U rack server that offers simplified management purposeful design and energy efficiency with support of Intel E5 Series Sandy Bridge processors and ECC DDR3 RDIMMs 1600MHz with a maximum capacity of 768GB Memory PowerEdge R720 supports five x8 PCle Gen3 amp two x16 PCle Gen3 slots Visit dell com us enterprise p poweredge r720 pd for more information on PowerEdge R720 Servers Intel Ethernet X540 DP 10GBASE T server adapter The pro
6. ails for the recommended reference architectures Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i Single server reference architecture Figure 1 depicts the single server reference architecture Table 2 lists the details of the configuration Figure 1 Single server reference architecture PowerEdge R720 2 Intel Xeon Sandy Bridge CPUs E5 2643 128GB RAM 1600Mhz 2 Intel Ethernet X540 Dual Port 10GBASE T Server Adapter Windows 2008 R2 SP1 SQL Server 2012 1 PowerConnect 8024 PowerVault MD3620i PowerVault MD1220 Expansion Enclosure 48 146G 6Gbps 15k SAS drives ccc Table 2 Single server reference architecture details Hardware Components Details Server PowerEdge R720 Processors 2 Intel Xeon Sandy Bridge CPUs E5 2643 3 3Ghz Total Cores per Socket 4 Total Logical Processors HT enabled 16 Total Installed Memory 128GB 1600Mhz Network Adapters a Ethernet X540 Dual Port 1OGBASE T Server apter Multipathing Software Dell MD Series DSM Multipathing Policy Least Queue Depth Default External Storage e PowerVault MD3620i with a MD1220 Expansion nclosure Disks 48 146G 6Gbps 15k SAS drives Network Switch 1 PowerConnect 8024 Operating System Windows 2008 R2 SP1 Enterprise Edition Database Software SQL Server 2012 Enterprise Edition Microsoft SQL Server 2012 Fast Track Reference C
7. ce eect nina eee kin naa in aeaa 6 Figure 2 Highly available reference architecture cece eee cece e eee eee eee e ete e eterna 7 Figure 3 Cabling diagram for single server configuration c cece eee e eet eee t nett tenet ed 9 Figure 4 Enabling J umbo frames on storage iSCSI host ports ccccee eee eee eect teeter eee 10 Figure 5 Enabling storage High Performance Tier Turbo Mode c cece eee ee eee teeter eee 11 Figure 6 Modifying storage cache block S ZE 12 eect eee eee eee teeta eee eas 11 Figure 7 Modifying the virtual disk segment SIZ cece e 12 Figure 8 Enabling J umbo packets on network adapter portS s sssssssssssrrrssrrrssrrrnserrnsrrrsrers 12 Figure 9 Enabling J umbo frames on SWitCh ports cece eet iaiia 13 Figure 10 Storage LUN layout cssiuctsie saerssirpeetsacsgen toed yaetene E DANAEA NEEN EEEE AE 14 Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i Executive summary Dell and Microsoft in cooperation provide guidelines and design principles to assist customers in designing and implementing a balanced configuration for Microsoft SQL Server data warehouse workloads to achieve out of the box scalable performance These database reference architectures enable each of the components in the database stack to provide optimal throughput to match the database capabilities of the specific set
8. during this time Are you sure you want to save y n y Configuration Saved console exi console gt Windows tuning The allocation unit size for all the database hard drives was set to 64KB SQL server tuning The following startup options were added to the SQL Server Startup options E This parameter increases the number of contiguous extends in each file that are allocated to a database table as it grows This option is beneficial because it improves sequential access T1117 This trace flag ensures the even growth of all files in a file group when auto growth is enabled Note that the Fast Track reference guidelines recommend to pre allocate the data file space rather than to depend on auto grow SQL Server Maximum Memory For SQL Server 2012 FTDW 4 0 guidelines suggest allocating no more than 92 of total server RAM to SQL Server If additional applications will share the server the amount of RAM left available to the OS should be adjusted accordingly For this reference architecture the maximum server memory was set at 117 76GB For the specific recommended fast track configuration the resource governor disabled by default and the max degree of parallelism settings 0 by default were set to the default settings 13 Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i Storage system configuration The Fast Track Reference Architecture guidelines define three pr
9. hroughput for the entire system is maximally utilized Configurations are designed specifically for the data warehouse or BI Business Intelligence systems Visit msdn microsoft com en us library dd459146928v sql 100 29 aspx for more information on Fast Track Data Warehouse architectures What s new with Dell Microsoft Fast Track reference architectures Dell and Microsoft have refreshed the Fast Track reference architecture offerings with the latest technology advancements Microsoft SQL Server 2012 and Dell PowerEdge 12 generation servers are the latest additions to the list of reference architecture components Microsoft SQL Server 2012 comes with several exciting features which directly benefit database environments Column Store Index is one of these important features which impacts the data warehouse database configurations This feature enables storing data in columnar fashion in contrast Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i 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 msdn microsoft com en us library gg492088 aspx for more information on Column Store Indexes Micr
10. imary layers of storage configuration e Physical disk array RAID Groups for Data and Logs e Operating system volume assignment LUN e Databases User System Temp Log On each storage array for the primary user and system temp database files e Four RAID 5 disk groups were created each consisting of eleven disks two disk groups each from the base and the expansion enclosure e One virtual disk LUN was created out of each disk group These LUNs were evenly distributed across the storage controllers Therefore there were four LUNs virtual disks for the primary user data Each storage controller was assigned two of the LUNs For the primary user and system temp database transaction logs one RAID1 disk group was created of 2 disks This RAID group was dedicated to host the database transaction log files The remaining 2 disks on the storage array were assigned as the storage hot spares global Figure 10 shows the pictorial representation of the LUN layout in the storage array Figure 10 Storage LUN layout PowerVault MD3620i DATA DATAN RAID5 10 2 RAIDS 20 1 PowerVault MD1220 Expansion Enclosure DATAS DATA 4 RAID5 10 2 RAIDS 10 1 Global Hotspares 14 Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i For Fast Track architectures Dell recommends using mount points for the storage access rather than using drive letters It is also important to as
11. ks p Premium Features Premium Features installed on storage array Additional Physical Disk Support Enabled 120 Enterprise Key Manager EKM Integration Disabled Feature Key Required High Performance Tier Enabled Mixed Physical Disk Types Enabled Physical Disk Security Enabled RAID 6 Virtual Disks Enabled Snapshot Virtual Disks Disabled Feature Key Required Solid State Disk Support Enabled zi ea Feature Pack Feature Pack installed on storage array fioGb iSCSI MD3600i Change rStorage Array Feature Information Feature Enable Identifier 3449000000000000000000003E 1E6549 lt Service Tag gt ras oS Close Help Set the Storage Cache Block Size to 32KB In this specific Fast Track configuration Dell recommends setting the storage cache block size to 32KB for maximum array throughput The Cache block size is set in the Change Cache Settings window Figure 6 Figure 6 Modifying storage cache block size FF M03620F_FT1 Change Cache Settings E x DELL The start value must be greater than or equal to the sto vale NOTE To change the cache settings for an individual virtual dsk use the Change Cache Settings option For more information refer to the online help Cache fush settings a4 Start fushing meee Lx cos _ rep 11 Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i
12. l and Logical 1 0 Maximum user data capacity Includes the total disk capacity of all disks allocated to primary data storage and does assume SQL Server page compression ratio of 3 5 1 This metric is not limited by rated bandwidth Reflects actual user query throughput Bene hinatr Mees Rate Logical 2070 which includes reads from RAM Buffer Ss cache Benchmark Scan Rate Physical 1320 Reflects physical I O read from disk during MB s benchmark FTDW Peak I O MB s 2460 Maximum observed Maximum observed I O rate rate Represents ipsam seers te _ throughput using FTDW Rated CSI MB s 4410 Columnstore Index Summary Dell in partnership with Microsoft enables customers to enhance ROI Return of Investment on their data warehouse systems using Fast Track Data Warehouse architectures These uniquely designed architectures ensure optimally designed and architected BI solutions The end to end database best practices and recommendations enable the customer to achieve a balanced data warehouse environment with greater performance than traditional data warehouse systems Up to User Data Capacity TB The Dell Microsoft Fast Track Architecture provides the following benefits to customers e Delivers a tested and validated configuration with proven methodology and performance behavior e Achieves a balanced and optimized system at all the levels of the stack by following the best practices of hardware and software comp
13. onents e Avoids over provisioning of hardware resources e Offers high availability at all levels of setup host switches and storage e Helps customers avoid the pitfalls of an improperly designed and configured system e Reduces future support costs by limiting solution re architect efforts because of scalability challenges 16
14. onfigurations using PowerEdge R720 and PowerVault MD3620i Highly available reference architecture For achieving high availability for the database we recommend using Microsoft Database Clustering Using Microsoft clustering services one database server is configured as the primary active server and the second server is configured as secondary passive The secondary server should have exactly the same configuration as the primary server Since the database is active on a single server at any point of time the performance of the database on the primary server active is comparable to the single server configuration discussed earlier Figure 2 depicts the highly available fast track reference architecture and Table 3 lists the configuration details Figure 2 Highly available reference architecture 2 PowerEdge R720 2 Intel Xeon Sandy Bridge CPUs E5 2643 per Server 128GB RAM 1600Mhz per Server 2 Intel Ethernet X540 Dual Port 10GBASE T Server Adapter per Server Windows 2008 R2 SP1 Clustered SQL Server 2012 Clustered 2 PowerConnect 8024 PowerVault MD3620i PowerVault MD1220 Expansion Enclosure 48 146G 6Gbps 15k SAS drives oe SSH SRRSS SERS eS aana Table 3 Highly available reference architecture details Hardware Components Details Server 2 PowerEdge R720 Processors 2 Intel Xeon Sandy Bridge CPUs E5 2643 3 3Ghz per Server Total Cores per
15. osoft 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 Table 1 Recommended reference architectures with Solution IDs Reference Architecture Solution ID Single Server Reference Architecture 2405036 Highly Available Reference Architecture 2405110 The following sections describe the hardware and software configuration det
16. posed reference architectures use two dual port Intel Ethernet X540 DP 10GBASE T Server Adapter cards This new dual port adapter has RJ 45 copper interfaces and is available both in low profile and full height interfaces Visit intel com content www us en network adapters 10 gigabit network adapters ethernet 10gigabit adapters html for more information on Intel Ethernet X540 DP 10GBASE T Server Adapters Dell PowerConnect 8024 Ethernet switch Dell PowerConnect 8024 switch is a rack mountable 10Gb Ethernet switch with 24 ports The last four ports 21 24 are combo ports which have the option to use SFP slots These allow the use of fiber optic connection uplinks to core switches Visit dell com us enterprise p switch powerconnect for more information on PowerConnect 8024 switches Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i PowerVault MD3620i iSCSI storage arrays PowerVault MD3620i storage arrays support 2 5 inch 6Gbps SAS disks which enable better backend performance MD3620i supports up to two controllers Each controller has two 10GbE host side ports and one SAS out port which is used to connect to any additional expansion enclosures Each RAID controller module contains 2GB of cache that is mirrored with the other controller s cache for high availability and protected by a battery powered cache offload mechanism Dell PowerVault MD3620i storage comes with i
17. s link of the PowerVault Modular Storage Manager MDSM Setup tab Figure 4 Enabling J umbo frames on storage iSCSI host ports FF MD3620i_SQLFT Advanced Host Port Settings The following settings apply for both IPv4 and IPv6 TCP listening port The default listening port is 3260 You can alternatively choose to enter a custom value from 49152 to 65535 Use custom listening port Gustom listening port Jumbo frames If jumbo frames are disabled the default Maximum Transmission Unit MTU size is 1500 Bytes per frame IV Enable jumbo frames MTU size 1501 9000 J 9000 Bytes frame _o E Enable High Performance Tier feature on MD3620i High performance Tier turbo mode one of the premium licensed features of the MD3620i array enables the storage to deliver increased performance For the proposed fast track architecture you should enable the HPT feature to achieve improved throughput from the array Other features may be enabled based on specific customer requirements The premium licensed features of the MD3620i storage array may be enabled or disabled from the Premium Features and Features Pack information window on the MD Storage Management GUI Figure 5 10 Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i Figure 5 Enabling storage High Performance Tier Turbo Mode How do I manage Premium Featur ature Pac
18. sign the appropriate LUN volume and mount point names to the configuration in order to simplify troubleshooting and performance analysis The mount point names should be assigned in such a way that the logical file system reflects the underlying physical storage enclosure mapping Table 4 shows the LUN and mount point names used for the specific reference configuration and the appropriate storage layer mapping All the logical volumes were mounted to the C FT folder Table 4 Mount point naming and storage enclosure mapping Logical Logical Logical LUN Volume Array Full Volume Path volume Label Label SE1 C FT PRI v SE1 C FT PRI v2 S C FT PRI SA1 SE2 Storage Storage Array Enclosure Processor 1 SA1 SE2 SP1 DG3 v3 C FT PRI Saat SA1 SE2 SP2 DG4 E2 SE2 Expansion SP2 DG4 v4 SA1 SE2 C FT LOG SA Storage Array SE Storage Enclosure SP Storage Processors DG Disk Group V Volume SA1 15 Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i Reference architecture performance details Table 5 shows the performance numbers reported for the recommended reference configuration Table 5 Performance metrics a a This capacity rating is based on up to FTDW Rated Capacity TB capacity but adjusted to account for Fast Track Rated I O Core performance metric for validation FTDW Rated I O MB s 1690 This is the midpoint of Physica
19. ts own Device Specific Module DSM software included in the MD3620i s Resource DVD which is fully integrated with Microsoft MPIO and helps you configure multipath solutions Figure 3 depicts how the cables are connected in the configuration 2 Intel Ethernet X540 Dual Port 10GBASE T Server Adapters PowerConnect 8024 PowerVault MD3620i PowerVault MD1220 Expansion Enclosure Visit dell com us enterprise p powervault iscsi arrays for more information on PowerVault MD3620i storage arrays Reference architecture configuration tuning details This section explains best practices and tuning guidelines to achieve the best performance using the discussed reference architectures PowerVault MD3620i storage tuning The following modifications are needed to optimize the storage for maximum sequential throughput e Enable J umbo Frames on all storage iSCSI host ports e Enable High Performance Tier feature on MD3620i e Set the Storage Cache Block Size to 32KB e Set the virtual disk segment size to 256KB Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i Enable J umbo Frames on all storage iSCSI host ports J umbo frames need to be enabled on all four storage iSCSI host ports and the MTU size should be set to 9000 bytes frame This can be done using the Advanced Host Port Settings window Figure 4 accessible from the Configure iSCSI host port
20. up Dell 12 generation servers along with the robust storage backends form efficient candidates for a high performing data warehouse solution This white paper describes the architectural design principles and guidelines used to achieve an optimally balanced SQL Server Data Warehouse solution using Dell PowerEdge R720 and PowerVault MD3620i iSCSI SAN storage along with Microsoft SQL Server 2012 The performance numbers achieved for the reference configuration are also discussed in detail Introduction to Microsoft SQL Server Fast Track reference architectures The objective behind the database Fast Track reference configurations is to provide guidance and resources to help customers identify the right architecture and configuration for data warehouse solutions The following are tangible benefits of following these recommended configuration best practices and guidelines e Accelerated data warehouse projects with pre tested hardware configurations e Reduced hardware and maintenance costs by purchasing the right balanced hardware solution and optimizing it for a data warehouse workload e Reduced planning and setup costs leveraging the Certified Reference Architecture configurations e Predictable performance by configuring the system correctly and taking advantage of the tuning directions The Fast Track reference architectures avoid the risk of improperly designed and configured systems These guidelines ensure that the capability and t

Download Pdf Manuals

image

Related Search

Related Contents

Descargar  Sony KV-29FQ65 User's Manual  MANUAL DE UTILIZAÇÃO  Instalação do Driver - Windows 7  Jwin JD-VD509 User's Manual  KRAUS KBU17 Installation Guide    Brodit ProClip 521645  EX1R Setup, Use & Care Guide  Motorola 68000202474-B Cell Phone User Manual  

Copyright © All rights reserved.
DMCA: DMCA_mwitty#outlook.com.