EMC FOR MICROSOFT SQL SERVER 2012 Mission Critical with Confidence

Karsten Bott mSpecialist EMC Deutschland GmbH

© Copyright 2011 EMC Corporation. All rights reserved.

1

Heute 13:3o Verlosung !!! Gewinnen Sie 1 von 2 iomega Storecenter ix2 2*1TB RAID1 NAS Device Info´s hier am Stand !! Heute letzte Chance !

© Copyright 2011 EMC Corporation. All rights reserved.

2

EMC Virtual Infrastructure For Microsoft Maximize The Value Of Microsoft Software Investments

HIGHER QUALITY OF SERVICE

HIGHER EFFICIENCY/ LOWER COST

FASTER TO TIME TO VALUE

© Copyright 2011 EMC Corporation. All rights reserved.

3

EMC Accelerates IT Transformation Businesses are transitioning to services ready IT Lower costs

Reduce complexity

 High costs deploying and maintaining heterogeneous application solutions  Imbalanced utilization of infrastructure resources

 Managing silos of technology with multiple tools  Different processes and scripts to regular tasks

Scalability and Elasticity

 Dynamic IT solutions that respond to changing business requirements  Highly scalable application across all workloads ensuring business continuity

Maintain strict SLAs

 Need continuous operations with minimal to no data loss  Supporting Recovery time, recovery point and recovery level objectives

© Copyright 2011 EMC Corporation. All rights reserved.

4

Moving from Static to Dynamic Infrastructure EMC Automated Storage Optimization for Microsoft Environments

MANUAL PROCESS

100% AUTOMATED VIRTUALIZED

SharePoint

Exchange

SQL

SharePoint

SQL

Exchange

FAST Cache & FAST VP SSD

Static Association Of Disk Groups To Applications Based On Best Practices

© Copyright 2011 EMC Corporation. All rights reserved.

SAS

NL-SAS

Dynamic, Self-Optimizing Storage Pools Based On Actual Data Activity

5

Moving from Static to Dynamic Infrastructure EMC Automated Storage Optimization for Microsoft Environments • FAST Cache continuously ensures that the hottest data is served from high performance Flash SSDs

100% AUTOMATED VIRTUALIZED

• FAST VP (Virtual Pools)* optimizes storage pools automatically, ensuring that active data is being served from SSDs, while cold data is moved to lower cost disk (SAS/NLSAS)

SharePoint

SQL

Exchange

FAST Cache & FAST VP

• Value to You: – Automatic I/O performance tuning – More transactions and more users without configuration changes

© Copyright 2011 EMC Corporation. All rights reserved.

SSD

SAS

NL-SAS

Dynamic, Self-Optimizing Storage Pools Based On Actual Data Activity

6

Boost Your SQL Server 2012 Performance Reference Architecture Whitepaper •

Four user databases of 1.8TB total data

•

Always On Availability Group replication (Synchronous mode)

•

OLTP (TPC-E Like) workload

SQLNODE1

SQLNODE.2

Transactions/sec (TPS)

25,000

24,936

26,837

20,000 15,000

13,884

10,000 5,000

6,815 490

0

Baseline

1,486

893

2hr FAST Cache warmup

1,604 FAST Cache Steady State

FAST Cache increased SQL Server throughput by x4 (TPS/IOPS) while maintaining very low latency of