백서

MICROSOFT® SQL SERVER® 2014 - DATA WAREHOUSE FAST TRACK (DWFT) REFERENCE ARCHITECTURE

HP and SanDisk® collaborated to certify the HP DL380 Gen8 and HP DL580 Gen8 with HP PCIe LE Workload Accelerators on the Microsoft SQL Server 2014 Data Warehouse Fast Track Reference Architecture (DWFTRA). See how our solutions meet or exceed performance and storage needs while reducing datacenter sprawl, licensing cost, and administration overhead.

Win with HP® and SanDisk®

Our three solutions are designed to meet and exceed your performance and storage needs by taking advantage of SanDisk's industryleading storage performance, reliability, and capacity, while reducing data center sprawl, licensing cost, and administration overhead.

 

New Data Warehouse Features in Microsoft SQL Server 2014

Microsoft added clustered column store indexes (CCI) in SQL Server 2014, which are designed to decrease query response times and deliver deeper levels of data compression. CCI eliminates the need to build summary tables, thus further reducing ETL run times.

CCI is optimized for query performance. Our solutions deliver an order-of-magnitude of 7x better query performance when using CCI. CCI accomplishes this by using a columnar format to compress the data by 10x or more, processing a set of rows in batches, and reading only the columns that are referenced in the query.

CCI is updateable allowing concurrent insert – both bulk import and trickle insert – of new data while query workload is running. This reduces the data latency from the time data is born to when it is available for querying.

 

What is the SQL Server Data Warehouse Fast Track Reference Architecture?

The Microsoft SQL Server 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 in SQL Server DWFT reference architecture 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.

  Rated User Capacity (TB) Measured Throughput (Queries/Hr/TB) Measured Scan Rate Physical (MB/s) Measured CPU% (Avg.)
HP ProLiant DL380 Gen8 28 202 with row store 1414 with CCI 5,868 96
HP ProLiant DL380 Gen8 45 198 with row store 1476 with CCI 4,778 97
HP ProLiant DL580 Gen8 90 366 with row store 2721 with CCI 9,245 92

 

Our Results - Your Choice

Three configurations were certified by Microsoft's SQL Server Engineering Team. Two configurations are based on the HP ProLiant DL380 Gen8 platform, and the remaining configuration is based on the HP ProLiant DL580 Gen8 platform. These options provide rated data capacities of 28TB, 45TB and 90TB, giving you the flexibility to choose a solution that meets your requirements.

 

Scalable Server Architecture

The HP ProLiant DL380 Gen8 includes six PCIe Gen3 full-height and half-length (FHHL) slots, and the HP ProLiant DL580 Gen8 includes up to nine PCIe Gen3 FHHL slots. This enables customers to properly size their data warehouse in the beginning and increase the HP PCIe LE Workload Accelerator capacity as data volumes grow.

 

HP ProLiant DL380/DL580 Gen8 and HP PCIe LE Workload Accelerator

  • Up to 768GB/3TB of DRAM, respectively
  • Up to 48/120 logical processors, respectively
  • Up to 26TB/46.8TB of HP PCIe LE Workload Accelerator usable capacity, respectively
  • Up to 16.2/24.3GB/s of HP PCIe LE Workload Accelerator read bandwidth, respectively.

앞으로 플래시를 사용할 준비가 되셨습니까?

포츈지 500대 대기업이든 5명이서 출발하는 신생 기업이든 관계없이, SanDisk는 인프라 활용도를 극대화하는 데 도움이 되는 솔루션을 보유하고 있습니다.

VIA
이메일

질문을 하시면 저희가 답변을 드리겠습니다.

대화해 봅시다
800.578.6007

망설이지 말고, 잠시 얘기를 나누면서 완벽한 플래시 솔루션 구축을 시작하십시오.

판매 문의

몇 가지 간단한 질문을 하려는 경우든, 조직의 요구에 맞게 설정된 SanDisk 솔루션에 대해 논의할 준비가 되어 있든 관계없이, SanDisk 영업 팀이 항상 도움을 드리기 위해 대기하고 있습니다.

아래 양식을 작성해 주시면 질문에 기꺼이 답변해 드릴 것입니다. 영업 팀에 바로 연락해야 한다면 다음 전화 번호를 이용하십시오: 800.578.6007

필드를 비워둘 수 없습니다.
필드를 비워둘 수 없습니다.
올바른 이메일 주소를 입력하십시오.
필드에는 숫자만 사용할 수 있습니다.
필드를 비워둘 수 없습니다.
필드를 비워둘 수 없습니다.
필드를 비워둘 수 없습니다.
필드를 비워둘 수 없습니다.

관심 분야에 표시하십시오:

질문 또는 의견:

옵션을 선택해야 합니다.

감사합니다. 요청을 접수했습니다.