Transcript Whats in Windows Server 2012 for SQL Server

DBI332







Microsoft SQL Server database storage
Microsoft SQL Server databases on SMB file shares
Windows Server 2012 SMB File Server enhancements
SQL Server HA Options
Database Mirroring
Primary disaster site for
databases
Replication
Database
Scale Out
for Queries
Log Shipping
Additional disaster sites for
databases
Logical recovery
Replication
Database reporting and read
scale out with redundancy
Database Mirroring
Clustering
Production
Database
Log Shipping
Clustering
Local server redundancy
Log Shipping
with Restore Delay
Always On Storage Partner Solutions
Site storage HA
Highest hardware reliability
Backup
Hot
Standby
Warm
Standby
Logical
Recovery
Standby
Current Options
New storage option
The world has changed
SQL Server
\\fs1\share
Node A
\\fs1\share
Node B
File Server Cluster
SQL
Server
SQL
Server
SQL
Server
IIS
IIS
IIS
VDI
Desktop
Hyper-V
Hyper-V
Hyper-V
VDI
Desktop
Hyper-V
Hyper-V
Hyper-V
VDI
Desktop
Hyper-V
Hyper-V
Hyper-V
File
Server
File
Server
Shared
Storage
SQL Server
\\fs1\share
\\fs1\share
Node A
Node B
File Server Cluster
SMB Client Interface Scaling - Throughput
1 x 10GbE
2 x 10GbE
3 x 10GbE
5000
MB/sec
4000
3000
2000
1000
0
I/O Size
http://go.microsoft.com/fwlink/p/?LinkId=227841
4 x 10GbE
Configuration
RDMA (SMB Direct)
Local Storage
Configuration
RDMA (SMB Direct)
Local Storage
BW
MB/sec
IOPS
IOs/sec
%CPU
Privileged
10,900
11,200
83,400
85,500
8
5
BW
MB/sec
IOPS
IOs/sec
%CPU
Privileged
4,550
4,870
555,000
595,000
55
29
Hyper-V: Over 1 Million IOPs from a Single VM
Industry Leading IO Performance
• VM storage performance on par with
native
• Performance scales linearly with
increase in virtual processors
• Windows Server 2012 Hyper-V can
virtualize over 99% of the world’s SQL
Server.
Windows
Server 2008
R2
VMware
vSphere 5
Windows
Server 2012
250,000 IOPs
300,000 IOPs
1,000,000+
IOPs

SMB for SQL



Microsoft SQL Server database storage
Microsoft SQL Server databases on SMB file shares
Windows Server 2012 SMB File Server enhancements



Hyper-V Enhancements for SQL Server
Summary & QA
Scale-out file shares (active-active)
CHKDSK with zero downtime
Clustered Shared Volumes block cache
Simpler management
Application Servers
Data Center Network
(Ethernet, InfiniBand or combination)
Single Logical File Server (\\fs\share)
Single File System Namespace
Cluster Shared Volumes
Clustered File Server
Fundamental gains for server applications
SQL transactions/s
4270 (98%)
5000
4315 (100%)
4000
3000
2000
1175 (27%)
1000
0
SMB
SMB +
DAS
Performance tuning and debug
> smbsofs33
Server: stb-red-dc-01.stbtest.microsoft.com
Address: 10.200.81.201
Non-authoritative answer:
Name:
smbsofs33.ntdev.corp.microsoft.com
Addresses: 2001:4898:0:fff:0:5efe:10.217.108.49
2001:4898:0:fff:0:5efe:10.217.108.103
2001:4898:0:fff:0:5efe:10.217.108.148
10.217.108.148
10.217.108.49
10.217.108.103
SQL Server
Node A
Node B
Node C
Scale-Out File Server Cluster

SMB for SQL




Microsoft SQL Server database storage
Microsoft SQL Server databases on SMB file shares
Windows Server 2012 SMB File Server enhancements
Scale-Out File Server for application data


Summary & QA
MS Hyper-V Server 2008 R2 SP1
Microsoft Hyper-V Server 2012
August 2011
Oct-26-2012
Free Download from:
www.microsoft.com/hvs
Free Download from:
www.microsoft.com/hvs
Physical Processor Support:
Up to 8 processors
(no core limitations)
Up to 64 processors
(no core limitations)
Physical Memory Support:
Up to 1 TB per server
Up to 4 TB per server
Up to 4 per VM
Up to 64 per VM
64 GB of memory per VM
(no memory tax)
1 TB of memory per VM
(no memory tax)
Live Migration/High Availability:
Yes
Yes
Live Storage Migration:
No
Yes
Shared Nothing Live Migration:
No
Yes
RemoteFX:
Yes
More monitors, more resolutions
Storage Spaces:
No
Yes
VMs on File Based Storage
No
Yes
Release Date:
Cost:
Virtual Processors
Virtual Machine Memory Support:
LEARN
MORE

SMB for SQL






Microsoft SQL Server database storage
Microsoft SQL Server databases on SMB file shares
Windows Server 2012 SMB File Server enhancements
Scale-Out File Server for application data
Hyper-V Enhancements for SQL Server
•
•
•
•
•
•
•
•
•
•
Key Advantages over VMware vSphere
Capability
Windows Server 2008
R2 Hyper-V
Windows Server 2012
Hyper-V
VMware vSphere
5.1 Ent Plus
384
1,024
512
64 GB
1 TB
1 TB
Virtual Processors Per Virtual Machine
4
64
64
Maximum Nodes Per Hyper-V Cluster
16
64
32
1,000
8,000
3,000
SR-IOV with Live Migration Support
No
Yes
No
Native 4KB Disk Support
No
Yes
No
Maximum Virtual Disk Size
2 TB
64 TB
2 TB
Encrypted Cluster Storage
No
Yes
No
Open Extensible Switch
No
Yes
Closed
Resource Metering
No
Yes
Chargeback Req.
1GB Simultaneous Live Migrations
1
Unlimited
4
10GB Simultaneous Live Migrations
1
Unlimited
8
Live Storage Migration
No
Yes
Yes
Shared Nothing Live Migration
No
Yes
Yes
Network Virtualization
No
Yes
VXLAN Req.
Virtual Machine Replication
Yes
Yes
Yes
Guest OS Application Monitoring
No
Yes
API Only
Guest Clustering with Live Mig & Dyn Memory
Yes
Yes
No
Resource
Active Virtual Machines Per Host
Memory Per Virtual Machine
Scalability,
Performance,
Density
Maximum Virtual Machines per Hyper-V Cluster
Storage
Secure
Multitenancy
Flexible
Infrastructure
High Availability