WWW.DISSERTATION.XLIBX.INFO
FREE ELECTRONIC LIBRARY - Dissertations, online materials
 
<< HOME
CONTACTS



«WHITE PAPER Cisco UCS C240 M4 Rack Server with Lightning Ascend™ Gen. II SAS SSDs from SanDisk® 36TB Data Warehouse Fast Track Reference ...»

WHITE PAPER

Cisco UCS C240 M4 Rack Server with

Lightning Ascend™ Gen. II SAS SSDs from SanDisk®

36TB Data Warehouse Fast Track Reference Architecture

Based on the SQL Server 2016 Data Warehouse Fast Track (DWFT)

Reference Architecture

www.SanDisk.com

Western Digital Technologies, Inc.

951 SanDisk Drive, Milpitas, CA 95035

Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs from SanDisk – 36TB DWFT RA (SQL Server 2016)

Table of Contents

Executive Summary

About the Cisco UCS C240 M4 Rack Server

Lightning® Product Family of SAS SSDs from SanDisk

About the Data Warehouse Fast Track Reference Architecture

Reference Architecture

Server UEFI Configuration

General Settings

Operating System Settings

Windows Configuration – Power Settings

Storage Configuration

SQL Storage Pool - Virtual Disks

SQL Server Settings

Database Configuration

TempDB Configuration

Memory Allocation

Local Security Policy

SQL Server 2016 Configuration Parameters

Measured Performance

Summary

Bill of Materials

Cisco UCS C240 M4 – Non High Availability Option

Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs from SanDisk – 36TB DWFT RA (SQL Server 2016) Executive Summary This guide details the server, storage, and software configurations for the Cisco UCS® C240 M4 Rack Server with Lightning Ascend Gen. II 12Gb/s SAS SSDs (1.6TB) from SanDisk which Microsoft® has validated for a Fast Trackrated user capacity of 36TB.

This document is for individuals (BI Architects, DBAs, Report-Developers, and IT Directors) involved in decision making who are looking for guidance when designing enterprise, business-intelligence applications.

The Microsoft SQL Server® Data Warehouse Fast Track (DWFT) reference architecture is designed to eliminate the complexity of properly sizing hardware, which helps reduce unnecessary scale-out of storage and servers.

The sizing techniques used in SQL server DWFT will properly size servers, based on I/O and CPU consumption.

This consumption-based approach ensures your data warehouse can fully take advantage of your hardware investment.

About the Cisco UCS C240 M4 Rack Server Storage and I/O-Optimized Cisco UCS C-Series Rack Servers The Cisco UCS C240 M4 Rack Server is a 2-socket, 2-rack-unit (2RU) rack server. It offers outstanding performance and expandability for a wide range of storage and I/O-intensive infrastructure workloads, from big data to collaboration. The enterprise-class Cisco UCS C240 M4 server extends the capabilities of the Cisco Unified Computing System™ (Cisco UCS) portfolio in a 2RU form factor with the addition of the Intel® Xeon® processor E5-2600 v4 and v3 product family, which delivers a superb combination of performance, flexibility, and efficiency.

Product Overview The Cisco UCS C240 M4 offers outstanding levels of internal memory and storage expandability with exceptional

performance. It has the following features:

 Up to 24 DDR4 DIMMs at speeds of up to 2400 MHz, for improved performance and lower power consumption  Up to 6 PCI Express (PCIe) 3.0 slots (4 full-height, full-length)  Up to 24 small form factor (SFF) drives or 12 large form factor (LFF) drives, plus two (optional) internal SATA boot drives Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs from SanDisk – 36TB DWFT RA (SQL Server 2016)  Support for 12-Gbps SAS drives  A modular LAN-on-motherboard (mLOM) slot for installing a next-generation Cisco virtual interface card (VIC) or third-party network interface card (NIC) without consuming a PCIe slot  2 x 1 Gigabit Ethernet embedded LOM ports  Support for up to two double-wide NVIDIA graphics processing units (GPUs), providing a graphics-rich experience to more virtual users  Excellent reliability, availability, and serviceability (RAS) features with tool-free CPU insertion, an easyto-use latching lid, hot-swappable and hot-pluggable components, and redundant Cisco® Flexible Flash (FlexFlash) SD cards

For additional details, refer to the following datasheet:

http://www.cisco.com/c/en/us/products/collateral/servers-unified-computing/ucs-c240-m4-rackserver/datasheet-c78-732455.html Lightning® Product Family of SAS SSDs from SanDisk The Lightning Ascend Gen. II 12Gb/s SAS SSD doubles interface speed, providing the highest performance for mission-critical hyperscale, cloud, and virtualized data center application workloads. This product offers a

feature-rich robust design, including the following:

 SanDisk’s innovative parallel processing architecture  Full data path protection (T10-DIF support)  Temperature-based power control  SED instant secure erase  MTBF of 2.5 million hours  Power fail protection The SSD is backward-compatible with 6Gb/s SAS and offers a single firmware binary platform for seamless

integration and reduced qualification times. A summary of features is shown below:

Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs from SanDisk – 36TB DWFT RA (SQL Server 2016) For more information, visit https://www.sandisk.com/business/datacenter/products/flash-devices/ssds/sas-ssd/lightning-gen2 About the Data Warehouse Fast Track Reference Architecture The SQL Server Data Warehouse Fast Track reference architecture provides a scalable framework based on balancing I/O to achieve maximum performance from SMP-based servers. SQL Server Data Warehouse Fast Track eliminates the complexity of sizing servers with data warehouses by providing a set of data consumption rates that properly balances performance between the disk subsystem, CPU, and memory.





More information on SQL Server DWFT can be found here:

http://www.microsoft.com/en-us/server-cloud/data-warehouse-fast-track.aspx Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs from SanDisk – 36TB DWFT RA (SQL Server 2016) Microsoft SQL Server 2016: Data Warehousing with Improved Column Store Technology Microsoft SQL Server 2016 has made significant improvements in data warehousing technologies and performance, including column-store features as well as many other improvements.

Column-store indices offer great advantages over traditional row stores for analytics and data warehousing queries. They are ideally suited for the star schemas, and tables with billions of rows which are commonly seen.

Among their advantages for analytics are:

Up to 10X compression in data size Data warehouses are very large by nature, and the compression offered by column store index technologies offers both space and cost savings, but also significantly increased performance, due to the dramatically reduced IO requirements given by the compression, coupled by the ability to only scan the specific columns required by each query. This compression also reduces the amount of memory required to hold a given number of rows from the source data warehouse.

Additional Indices SQL Server 2016 adds the capability to add additional (B-Tree) indices to column store-based tables, which enables efficient single-row lookup.

In addition to these architectural features, we have further optimized the processing of queries in column-store

indices in the following ways:

Operator Pushdown Pushdown refers to moving both filter and aggregation query operations closer to the data, so that many of the filters and calculations can be done in the scan operators, dramatically reducing the volume of data which needs to be handled further on in query processing.

Batch Mode Processing SQL Server 2016 includes enhancements in batch-mode processing which processes many rows at a time rather than serially doing calculations on each individual row. These batch operations are further optimized by leveraging Single Instruction Multiple Data (SIMD) vector processing CPU instructions in the Intel® architectures.

Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs from SanDisk – 36TB DWFT RA (SQL Server 2016) Reference Architecture The following table shows the configuration details for the Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs, using the Fast Track Data Warehouse architecture.

–  –  –

Server UEFI Configuration  Hyper-Threading was enabled.

 Operating mode was changed to "Maximum Performance”.

 Fan Offset was set to “Increased Cooling”.

General Settings Operating System Settings This Fast Track Data Warehouse test used the Microsoft Windows Server 2012 R2 Standard Edition OS. Standard installation steps were used to install the operating system with default values, followed by service packs and update patches.

Windows Configuration – Power Settings The High Performance plan was chosen to reduce CPU throttling.

Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs from SanDisk – 36TB DWFT RA (SQL Server 2016) Storage Configuration The Windows 2012R2 OS was configured on a pair of 1.2TB 6G SAS 10K SFF HDDs (mirrored).

The Lightning Ascend Gen. II SAS SSDs were configured using Storage Spaces. This technology allows Windows Server to virtualize storage by grouping industry-standard disks into storage pools and then creating virtual disks (“storage spaces”) from the available capacity in those storage pools.

Storage Spaces enable cost-effective, highly available, scalable and flexible storage solutions for business-critical deployments.

This server is available with a single Cisco 12G SAS Modular RAID controller, configured to pass-through mode.

–  –  –

SQL Server Settings Database Configuration A 1TB data warehouse schema was created for benchmarking using the Fast Track toolkit. The schema used a master filegroup with 4 additional filegroups.

TempDB Configuration In total, eight 10GB tempdb files were created and stored on the volume designated for data files (C:\DB\DATA).

The tempdb transaction log file was stored on the volume designated for log files (C:\DB\LOGS).

Memory Allocation SQL Server was allocated 118GB of the available server memory (512GB). This amount is allocated as part of the Fast Track test criteria to drive backend disk activity during the Row Store query runs.

Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs from SanDisk – 36TB DWFT RA (SQL Server 2016) Local Security Policy

The SQL Server maintenance account was granted the following privileges:

 Enable Lock Pages in Memory - prevents SQL Server buffer pool pages from paging out.

 Perform Volume Maintenance Tasks - enables Instant File Initialization.

SQL Server 2016 Configuration Parameters

–  –  –

Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs from SanDisk – 36TB DWFT RA (SQL Server 2016) Measured Performance During Fast Track Database Validation, Microsoft’s Reference Point tool drives multiple concurrent query workloads designed to identify bottlenecks. The tool establishes the key performance metrics in the table below.

–  –  –

Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs from SanDisk – 36TB DWFT RA (SQL Server 2016) SQL Server Data Warehouse Fast Track Certification Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs from SanDisk – 36TB DWFT RA (SQL Server 2016) Summary Together, Cisco and SanDisk dedicated hundreds of hours of testing to engineer the SQL Server DWFT solution to provide the most optimal reliability and performance. These series of tests pushed the Cisco UCS C240 M4 to peak performance without hardware failure. The reliability and performance experienced during testing is what can be expected in production environments.

The same configuration meets the need of both Row Store and Column Store configurations, delivering high measured I/O throughput in the Row Store configuration at 5.5GB/s, and high query rates in the Column Store configuration at 2365 Q/Hr/TB.

Cisco UCS C240 M4 Rack Server with Lightning Ascend Gen. II SAS SSDs from SanDisk – 36TB DWFT RA (SQL Server 2016) Bill of Materials Cisco UCS C240 M4 – Non High Availability Option

–  –  –

©2016 Western Digital Corporation or its affiliates. All rights reserved. SanDisk and the SanDisk logo are trademarks of Western Digital Corporation or its affiliates, registered in the U.S. and other countries. Lightning and Lightning Ascend are trademarks of Western Digital Corporation or its affiliates. Other brand names mentioned herein are for identification purposes only and may be the trademark(s) of their respective holder(s). 5111EN 20160609



Similar works:

«Civil and Environmental Research www.iiste.org ISSN 2222-1719 (Paper) ISSN 2222-2863 (Online) Vol 2, No.3, 2012 Oil Exploration and Spillage in the Niger Delta of Nigeria Adati Ayuba Kadafa Department of Environmental Management, Faculty of Environmental Studies, Universiti Putra Malaysia. 43400 Darul Eshan, Selangor, Malaysia. *Email:kwaala@yahoo.com Abstract Colonel Drake drilled a 70 feet well in Titusville, Pennsylvania and discovered oil. In 1956, Shell British Petroleum discovered crude...»

«12 January 2016 SOLAR ENERGY DEVELOPMENT IN THAILAND OVERVIEW As of 26 October 2015: Number of Solar Projects The current number of solar projects which have achieved COD in Thailand is 295 projects, with a total selling capacity of 1244 MW. [Information from ERC’s website as of 12 October 2015.] They include:  5 SPP PPAs signed with EGAT, with total selling capacity of 305 MW, details as follows: Installed Selling COD No. Name of Project Capacity Capacity 1. Bangchak Solar, Ayutthaya 34...»

«THE SEMINAR ON JESUIT SPIRITUALITY The Seminar is composed of a number of Jesuits appointed from their provinces in the United States. It concerns itself with topics pertaining to the spiritual doctrine and practice of Jesuits, especially United States Jesuits, and communicates the results to the members of the provinces through its publication, Studies in the Spirituality of Jesuits. This is done in the spirit of Vatican II’s recommendation that religious institutes recapture the original...»

«GIALens. (2010):3. http://www.gial.edu/GIALens/issues.htm Comments on Sorcery in Papua New Guinea KARL J. FRANKLIN, PH. D. Graduate Institute of Applied Linguistics and SIL International ABSTRACT Variations of sorcery and witchcraft are commonly reported in Papua New Guinea. The Melanesian Institute (in Goroka, PNG) has published two volumes (Zocca, ed. 2009; Bartle 2005) that deal extensively with some of the issues and problems that have resulted from the practices. In this article I review...»

«ISSN: 2349-5677 Volume 1, Issue 3, August 2014 International Negotiation: “The Cuban Missile Crisis” Template for Social Change Samuel Appiah-Marfo, PhD Senior Lecturer of Research Methods and Conflict Analysis & Resolution Regent University of Science and Technology, Ghana Preface According to Samuel Huntington (1997) “The main responsibility of Western leaders is to recognize that intervention in the affairs of other civilizations is the single most dangerous source of instability or...»

«QUITTERS, INC. Morrison was waiting for someone who was hung up in the air traffic jam over Kennedy International when he saw a familiar face at the end of the bar and walked down. 'Jimmy? Jimmy McCann?' It was. A little heavier than when Morrison had seen him at the Atlanta Exhibition the year before, but otherwise he looked awesomely fit. In college he had been a thin, pallid chain smoker buried behind huge horn-rimmed glasses. He had apparently switched to contact lenses. 'Dick Morrison?'...»

«Business Combinations Comptroller’s Licensing Manual Washington, DC December 2006 Table of Contents Business Combinations Introduction Types of Combinations Same State Combinations with Banks and Thrifts Interstate Combinations under the Riegle-Neal Act Interstate Combinations Between National Banks and Insured State and Federal Thrifts Transactions Involving Bank Holding Companies Reorganizations to Become a Bank Holding Company Subsidiary. 5 Reverse Triangular Mergers Acquiring a Bank...»

«MILLSTONE TOWNSHIP BOARD OF ADJUSTMENT MEETING MINUTES MARCH 28, 2012 Meeting called to Order by Chairman Novellino at 7:30 p.m. Reading of Adequate Notice by Vice Chairman Barthelmes. Salute to the Flag and observance of a moment of silence for the troops. Roll Call: Present: Lambros, Novellino, Bailey, Conoscenti, Frost, Barthelmes and Mostyn. Absent: Morelli and Curcio. Approval of Minutes: February 22, 2012 The members having received and reviewed the draft minutes and recommend changes...»

«Services for professional procurement. Be better informed, make better decisions. Achilles Automotive Community Supplier Frequently Asked Questions (FAQ) January 2016 2013 Contents Overview Who is Achilles? What is the Achilles Community model and how does it work? What is the Achilles Automotive Community? Benefits of the Achilles model over the traditional model What is Achilles’ role? Registration What is the Automotive Registration Process? The Three Stages of the Registration Process Who...»

«1 Fiche descriptive sur les zones humides Ramsar (FDR) Catégories approuvées dans la Recommandation 4.7modifiée par la Résolution VIII.13 de la Conférence des Parties contractantes Note aux rédacteurs: 1. La FDR doit être remplie conformément à la Note explicative et mode d’emploi pour remplir la Fiche d’information sur les zones humides Ramsar ci-jointe. Les rédacteurs sont vivement invités à lire le mode d’emploi avant de remplir la FDR. 2. La FDR remplie (et la ou les...»

«Tartalomjegyzék I. Bevezetés és célkitűzések 3 II. Irodalmi áttekintés 6 II. 1. A mikorrhiza-kapcsolatok általános jellemzése és típusai 6 II. 2. A mikorrhiza-kapcsolatok evolúciója 8 II. 3. Ektomikorrhiza-képző növényés gombacsoportok 11 II. 4. Az ektomikorrhizák kialakulása és funkciója 12 II. 5. Az ektomikorrhiza-közösségek ökológiai jellemzői 14 II. 6. Az ektomikorrhiza-közösségek vizsgálatának módszerei 18 II. 6.1. Morfológiai-anatómiai vizsgálati...»

«Green Party election priority Introduction Summary Situation Solution Benefits Authorised by Jon Field, Level 2, 17 Garrett Street, Wellington. 2 Maui’s dolphins are a source of delight and pride for New Zealand. These boisterous creatures are the smallest and rarest dolphins in the world and live only on the West Coast of the North Island. Like the Kiwi, Maui’s dolphins are an important part of New Zealand’s natural heritage. New Zealanders love and want to protect the Maui’s dolphin,...»





 
<<  HOME   |    CONTACTS
2016 www.dissertation.xlibx.info - Dissertations, online materials

Materials of this site are available for review, all rights belong to their respective owners.
If you do not agree with the fact that your material is placed on this site, please, email us, we will within 1-2 business days delete him.