Sofia Event Center

21-22 November 2013

Breakthrough Data Platform Performance with SQL Server 2014Margarita NaumovaSQL Master Academy

Magi NaumovaWorking with SQL Server from v6.5

SQL Server Trainer and Consultant with over 60 projects in Bulgaria, Finland, Germany, UK, Sweden…

5 years Senior Consultant in Microsoft, member of Microsoft Worldwide Technical Leadership Team

BG SQL UG Founder and Leader

Now teaching and presenting SQL Server, running SQL Master Academy Training Program - www.SQLMasterAcademy.com and SQL Server consulting company - www.inspirit.bg

Blogging: www.maginaumova.com

0.001

0.100

10.000

1,000.000

100,000.000

10,000,000.000

1,000,000,000.000$/Mbyte (Y)

$/Mbyte (Y)

Key trends1

95

7

19

62

19

67

19

72

19

82

19

87

19

92

19

97

20

02

20

07

20

12

19

77 Data explosion

10x increase every five years

85% from new data types

VolumeVelocityVariety

Mission critical and cloud

performance Cloud-ready Self-service BIPerformance

and productivityMission critical

Modern DB platform

The evolution of the Microsoft data platform

SQL Server2000

SQL Server2005

SQL Server2008

SQL Server2008 R2

SQL Server2012

XML ● KPIs

Management studio ● Mirroring

Compression ● Policy-based mgmt. ● Programmability

PowerPivot ● SharePoint integration ● Master data services

AlwaysOn ● ColumnStore index ● Data quality services ● Power View ● Cloud

SQL Server2014

In-memory across workloads ● Performance and scale ● Hybrid cloud optimized ● HDInsight ● Cloud BI

Platform for hybrid cloud

Faster insights from data

Breakthrough Data Platform Performance

Mission critical performance and manageability

In-memory built-inAverage 10x faster for new and existing SQL Server apps

Secure and scalableMost secure with enterprise scale using Windows Server

High availabilityThe 9’s you need, with AlwaysOn

In-memory built-inNew in-memory OLTP

Enhanced in-memory ColumnStore for DW

In-memory BI with PowerPivot

Buffer pool extension to SSDs and enhanced query processing

Before

15,000 requests/se

c

16x fasterwith in-memory

250,000 requests/se

c

SQL Server 2014 with in-memory

Bwin game application

Bwin game application

Select only highly utilized tables to be in-memory

Optimize in-memory to fit existing hardware

On average 10x faster, without having rewrite entire app

Leverage full SQL Server capabilities

In-memory performance across OLTP, DW, and BI

All in a single SKU

Database vulnerabilities

2006 2007 2008 2009 2010 2011 2012 20130

1020304050607080

0 211 8

0 1 4 0

69

53 53 55

3429

22 18

5

28 25 2921

612

0

16 169 8 6

43

20

43

SQL Server Oracle MySQL DB2

Secure

Redefined engineering security processes

CC certification at high assurance level

Enhanced separation of duty

Transparent data encryption

Encryption key management

Support for Windows Server core

*National Institute of Standards and Technology Comprehensive Vulnerability Database 4/17/2013, Market share from IDC 2013

Up 640 logical processors

64 vCPUs/VM

1TB memory/VM

64 nodes/cluster

Network virtualization provides flexibility and isolation

Assign minimum and maximum bandwidth

Storage virtualization

Enterprise-class network storage on standard hardware

Storage tiering for higher performance

Scalable

SQL Server 2014Resource Governor adds IO governance

SysPrep at cluster level

Windows Server 2012 R2Hyper-V

Storage spaces

NIC teaming

Online VHDX resize

Network and storage QoS

Pool 1

Pool 2

Pool 3

High availabilityMulti-DB failover, manual or automatic

Up to 8 secondary replicas

100% availability during all online operations

HA without expensive SANs

Offload reads and backups to secondaries

Deployment and management wizards

Monitoring dashboard within SSMS and System Center

Primary Secondary 2Running BI workloads

Secondary 1Running backups

Synchronous data movement

Asynch

ronous

data movementAG_Listener

SQL Server 2014

Enhanced AlwaysOn

Replica Wizard

Windows Server 2012 R2

Clustered shared volume support

Online VHDX support

System Center 2012 R2

Manage on-premises and cloud apps

BMW

Faster insights from any data

Easy access to data, big and smallSearch, access, and shape internal and external data, and combine with unstructured data

Powerful insights with familiar toolsSpeed up analysis and time to insight with the familiarity of Excel in Office and Office 365 and access via mobile devices

Complete BI platformScale your BI models and enrich and secure your data with a complete platform spanning cloud and on-premises

Syndromic

SurveillancePlatform

Identify outbreaks in minutes

Business challengeHealthcare software vendor sought a solution to combine different data types to help identify disease outbreaks earlier Key benefits Spot outbreaks in near

real-time

Combine on-prem structured data with hand written notes and social media feeds

Local data mart

Clinical app

Windows 8 app

National data mart

Paul HendersonBI Division Head

Hadoop file

management

Natural languageprocessor

Clinical app

Anonymiser

Easy access to data, big and smallSimplify access to public and corporate data

Easily preview, shape, and format your data

Combine and refine data across multiple sources

Gain insight across relational, unstructured, and semi-structured data

Common management of structured and unstructured data

Query across relational DB and Hadoop with single T-SQL Query

Power Query

Windows Azure Marketplace

Windows Azure HDInsight service andMicrosoft HDInsight server (preview) 100% apache

Parallel data warehouse with Polybase

Powerful insights with familiar tools

Excel in Office and Power BI in Office 365: Power Pivot and PowerView

Power Maps in Excel

Data mining add-ins for Excel

Mobile BI apps

Access and mash-up data from virtually any source

Model data using familiar tools

Generate insights fast with powerful data visualizations

Quickly analyze up to millions of rows of data in Excel with PowerPivot and Power View

Connect and collaborate around data

Easily share insights for improved decision making

Mobile clients for any device

Microsoft Power BI for Office 365

Scalable | Manageable | Trusted

Collaborate in Office 365

Insights in ExcelShare

Find

Q&A

Mobile

Analyze

Visualize

Discover Search, access, and transform public and internal data sources with Power Query

Share data views and workbooks refreshable from on-premises and cloud based data sources, with Power BI sites

Easy data modeling and lightning fast in-memory analytics with Power Pivot

Bold new interactive data visualizations with Power View and Power Map

Ask questions and get immediate answers with natural language query

Mobile access through HTML5 and touch optimized apps for Windows 8, RT, and iOS tablets

Complete BI platform

Stream insight

Data quality services

Master data services

Analysis services

BI semantic model

Client toolsAnalysis, reports, scorecards, dashboards, custom apps

Data sourcesDatabases, LOB applications, big data,

Odata feeds, spreadsheets, text files

BI semantic model

Cleanse data and improve data quality

Seamlessly integrate data from any source

Complete and enterprise-grade BI platform

Build and deploy secure and scalable BI solutions

Empower business users to manage data governance

Deliver credible, consistent data to the right users

Platform for hybrid cloud

Hybrid cloud solutionsEnable new hybrid scenarios like cloud backup and cloud DR to reduce costs and improve on-premises DR

Easy on-ramp to cloudEasily migrate and run SQL Server in the cloud to gain benefits of cloud computing

Complete and consistentDeploy a complete and consistent data platform from on-premises to cloud

SQL database service is a “game changer”

Leads to greater revenueBusiness challengeCost effective solution to deal with massively variable demand for online ticket sales

Key benefits 150,000 ticket sales

in 10 seconds

Massive scale out

Manage complianceCore

transaction processing app

ON-PREM

WEB-APPTicket Sales

Normal demand

SQL DATABASEScale to

meet demand

Peak demand

User info transaction

Confirmation of ticket purchase

Collect userand credit

info

Hybrid cloud solutionsManual or automatic

At an instance level with point in time restore

Measures DB usage patterns to set backup frequency

Fast disaster recovery (low RTO)

Easy to deploy and manage

Cloud bursting

Greater global reach

Better isolation of internal assets

On-premise network

Domain controller

Periodic Snapshot

(automatic/manual)

SQL Server

Restore to VM

Geo replication

Manual or automatic

At an instance level with point in time restore

Measures DB usage patterns to set backup frequency

Fast disaster recovery (low RTO)

Easy to deploy and manage

Cloud bursting

Greater global reach

Better isolation of internal assets

Hybrid cloud solutions

On-premise network

Domain controller

VPN tunnel (Windows Azure Virtual Network)Asynchronous

commit

Primary replica

Secondary replica

Synchronous commit

Run backups

Run BI reports

Manual or automatic

At an instance level with point in time restore

Measures DB usage patterns to set backup frequency

Fast disaster recovery (low RTO)

Easy to deploy and manage

Cloud bursting

Greater global reach

Better isolation of internal assets

Hybrid cloud solutions

On-premise network

Domain controller(authenticating all users on-premise and cloud)

VPN Tunnel Windows Azure Virtual Network

SQL Server

Lin

ked

Serv

er

Web server

Easy on-ramp to cloudEasily migrate on-premise SQL Server to a Windows Azure VM

Designed for users unfamiliar with Windows Azure

Ideal for existing apps and dev/test new apps

Full SQL Server functionality

Full VM control

Ideal for new variable-demand apps

Dynamic scale-out of database

No patching of OS or DB

HA built-in with 99.9% SLADB

INFRASTRUCTURE

DATA MANAGEMENT & PROCESSING

DATA ENRICHMENT & FEDERATED QUERY

BI & ANALYTICSThe Microsoft Data Platform

Self-service CollaborationCorporate PredictiveMobile

Extract, transform, load

Single query model Data quality Master data

management

Non-relationalRelational Analytical Streaming Internal & External

VirtualizationScalability Security and Identity Quality of service

Show All

Close All

Complete and consistent data platform

3rd party

Dev ops tools Identity VirtualizationManagement tools

Microsoft Cloud

Complete and consistent data platform

1CONSISTENTPLATFORM

SQL Server 2014Mission critical performance

Faster insights from any data

Platform for hybrid cloud

Споделете вашата обратна връзка за тази сесия и за цялостната организация на конференцията

http://aka.ms/inchargeи участвайте в томболата за HTC 8S и други

награди!