Lenovo DX8200D SQL Accelerator Packs_V6

DX8200D for SQL Acceleration Solution Overview The Lenovo DX8200D for SQL Acceleration is designed to bring the full set of hyperconverged infrastructure benefits to customers with mission-critical SQL applications. By combining compute, networking and storage into a compact 2U server platform, the DX8200D for SQL Acceleration can reduce IT costs, deliver high levels of performance, simplify operations, eliminate single points of failure, and provide greater flexibility for SQL environments. Available as All Flash Array (AFA) as well as Hybrid Flash Array (HFA) models, the DX8200D SQL Acceleration delivers these benefits to a wide range of customers across multiple industries and SQL application environments. and changes to production environments. Most IT organizations do not have the time, resources or the luxury to make significant changes to their production applications.

Solution: How It Works Networking

The Lenovo DX8200D for SQL Acceleration appliance is designed to help customers overcome the challenges associated with today’s SQL environments. These solutions address the performance (latency), core exploitation, uptime (high availability), disaster recovery (D/R) and flexibility concerns faced by customers around the world.

• I/Os go to internal storage. Latency from networking layers and from external storage protocols are gone. All I/Os (reads & writes) now happen internally at high speed between server memory and storage devices, across multiple lanes. • Easy to expand. Customers can add additional memory, internal disks or direct attach JBODs (disk enclosures) as nodes scale up. All of this happens non-disruptively. Customers also have the option to add additional nodes to their environment, as they scale out. • No single point of failure. Best practices suggest deploying 2 nodes to create a high availability SQL failover cluster with mirrored data to eliminate disruption to production environments in case of failures, as shown below.

Challenges with today’s SQL environments IT organizations are constantly challenged to meet SQL application demands. Key challenges include: • Higher performance, exploitation of available cores, elimination of long queues and performance bottlenecks

Networking

• Continuous uptime of production SQL instances, creating always ON environments, effective SQL failover clusters that eliminate single points of failure • Operating an increasingly dynamic SQL environment with limited budgets • Improved I/O operations by eliminating high latency associated with external storage access and complex networking layers (SQL application performance is negatively impacted by inefficient I/O protocols.) • Effective Business Continuity deployments that give the ability to resume operations quickly at a second site in case of unplanned events at primary, production location For years, DBAs have tried to meet these challenges by tuning databases, altering queries or modifying applications. This requires significant expertise, development work

Key Benefits •

Simplification: Compute, Networking and Storage combined into a single, 2U node. These are pre-configured, pre-tested, ready to go solutions.

For added protection, the nodes can be physically separated and placed in different buildings in a campus environment, or housed in another datacenter, because the DX8200D for SQL Acceleration supports stretch clusters for up to 100 km. Operations continue uninterrupted in case one node goes down. This implementation provides zero RTO (Recovery Time Objective) and zero RPO (Recovery Point Objective), meeting the highest demands for always on systems. For effective D/R, a third node can be located anywhere (unlimited distance) and via asynchronous replication, creating a backup environment that is flexible and adjustable to meet customers’ business continuity requirements. Async Repl

• Reduced cost as customers no longer have to purchase separate servers to host SQL applications or add additional ports to their SANs or buy external storage to manage the growing demands of critical applications. •

Significant performance improvements based on DataCore™ Parallel I/O processing technology, which opens up multiple I/O lanes, eliminating the storage bottleneck.

Primary Site

Secondary Site

DX8200D SQL Accelerator models There are two sets of models available to meet SQL applications demands in terms of capacity, performance and budget.

For a mixed environment, the Hybrid Flash Arrays (HFA) models provide the right balance of SSDs and hard disk drives (HDDs) to deliver high performance at more affordable price points. Given the two storage tiers involved, these models exploit the DX8200D automated tiering feature to keep active data in the SSD tier.

For extreme performance requirements, the All Flash Array models provide the maximum benefit of Solid State Disks (SSDs) to deliver the highest TPM (Transactions Per Min) count, required by a typical multi database environment. These models provide the lowest latency as all I/Os transfer data (reads & writes) at memory speeds. There are no physical disk mechanical delays (disk rotation, head movement, seek, etc). Note that SSDs in all DX8200D models are configured in RAID-1 mode (fully mirrored) for maximum data protection and performance.

Note that all models benefit from advanced caching, RAM exploitation, Random Write Acceleration, Quality of Service, load balancing and multi-core parallel I/O processing.

DX8200D SQL ACCELERATOR PACKS: ALL FLASH ARRAY MODELS

DX8200D SQL ACCELERATOR PACKS: HYBRID FLASH ARRAY MODELS

Synchronous replication is used to keep both nodes in an SQL failover cluster in sync at all times, providing a true high availability environment designed to keep operations going even in the event of a component or node failure.

ENTRY MODEL

MIDRANGE MODEL

HIGH MODEL

ENTRY MODEL

MIDRANGE MODEL

HIGH MODEL

Includes 3.2 TB of Usable Storage



Includes 8 TB of Usable Storage



CTO Models

5135AC1 (3-YR)

5135AC2 (3-YR)

5135AC3 (3-YR)

CTO Models

5135AC4 (3-YR)

5135AC5 (3-YR)

5135AC6 (3-YR)

SERVER PLATFORM

3650 M5, Dual E5-2620 v4 Processors (16 Cores total) (includes 10Gb iSCSI ports, RAID adapters, Dual Power Supply, Bootable disks)

SERVER PLATFORM

DX8200D

WARRANTY SERVER RAM

256 GB

3650 M5, Dual E5-2620 v4 Processors (16 Cores total) (includes 10Gb iSCSI ports, RAID adapters, dual Power Supply, Bootable disks)

WARRANTY

NBD 9X5 (7X24 UPGRADE OPTIONS AVAILABLE) 128 GB

DX8200D

512 GB

SERVER RAM

NBD 9X5 (7X24 UPGRADE OPTIONS AVAILABLE) 128 GB

256 GB

512 GB

8.4 TB

16.8 TB

33.6 TB

USABLE INTERNAL CAPACITY

3.2 TB

6.4 TB

12.8 TB

USABLE INTERNAL CAPACITY

iSCSI PORT COUNT (10Gb)

6

6

6

iSCSI PORT COUNT (10Gb) Optional

6

6

6

FC PORT COUNT (16Gb) Optional

0

0

0

FC PORT COUNT (16Gb)

0

0

0

POPULATED

16

16

16

POPULATED

13

FREE (AVAILABLE)

8

8

8

FREE (AVAILABLE)

11

INTERNAL 2.5IN STORAGE BAYS

INTERNAL 2.5IN STORAGE BAYS

DATACORE VIRTUALSAN SOFTWARE

13

23

11

1

DATACORE VIRTUALSAN SOFTWARE

BASE LICENSE INCLUDED

8 TB

8 TB

16 TB

BASE LICENSE INCLUDED

8 TB

16 TB

32 TB

BASE LICENSE TYPE

HS8

HS8

HS16

BASE LICENSE TYPE

HS8

HS16

HS32

• x3650 Server node

• (4) 1Gb Ethernet Ports (General mgmt.)

• x3650 Server node

• Hybrid Flash Arrays (SSD + HDD)

• Dual 2620v4 Procs 8C (16C)

• All Flash Arrays (SSDs only)

• Dual 2620v4 Procs 8C (16C)

• Global Spare included

• 128 – 512 GB RAM

• 3-yr, 24x7x4 Warranty (optional)

• 128 – 512 GB RAM

• 3-yr, 24x7x4 Warranty (optional)

• Dual Power Supply

• DataCore VirtualSAN software

• Dual Power Supply

• DataCore VirtualSAN software

• Dual boot drives

• Windows Server 2012 R2 Standard

• Dual boot drives

• Windows Server 2012 R2 Standard

• (6) 10Gb iSCSI Ports (SQL clustering)

• 3.2, 6.4, 12.8 TB models (usable)

• (6) 10Gb iSCSI Ports (SQL clustering)

• 8, 16, 32 TB models (usable)

• (4) 1Gb Ethernet Ports (General mgmt.) For additional information, please visit datacore.com or email [email protected] ©2018 DataCore Software Corporation. All Rights Reserved. DataCore, the DataCore logo and SANsymphony are trademarks or registered trademarks of DataCore Software Corporation. All other products, services and company names mentioned herein may be trademarks of their respective owners.