Transcript Resource Pooling Elasticity Self Service Usage Based BENEFITS Reduce capital expenses BENEFITS BENEFITS o Greater agility BENEFITS o o o o Reduce operational expenses o Dynamic infrastructure CONSOLIDATE databases - Standardize and consolidate - Improve hardware utilization - Manage IT infrastructure.

Resource Pooling
Elasticity
Self Service
Usage Based
BENEFITS
Reduce capital expenses
BENEFITS
BENEFITS
o
Greater agility
BENEFITS
o
o
o
o
Reduce operational expenses
o
Dynamic infrastructure
CONSOLIDATE databases
- Standardize and consolidate
- Improve hardware utilization
- Manage IT infrastructure efficiently
Deploy resources on demand
- Handle peak load scenarios faster
- Scale to mission critical workloads
o
o
- Scale to efficiently meet demand
- High availability across multiple data centers
Green IT
Optimize IT to business priorities
Faster time to market
Make IT strategic by
mapping consumption to
business priorities
o Centralize view of total
resource consumption
across the enterprise
- Automation without compromising control
Reduce administration overhead
Business units can request
resources on demand
TOOLS OR FEATURES
Discover database
sprawl and
capacity planning
Microsoft® Assessment and
Planning (MAP) Toolkit
Consolidation
options
SQL Server Upgrade Advisor
STEPS
TOOLS OR FEATURES
Setup for high
availability
SQL Server AlwaysOn Failover
Clustering & Availability Group
Windows Server Core, Dynamic
Quorum, ReFS support
SQL Server Migration Assistant
(SSMA)
Setup for disaster
recovery
Physical to Virtual
Migration
System Center Virtual Machine
Manager
Virtualize and
manage instances
Windows Server Hyper-V™
Scale virtual machines
(CPU, memory,
storage, network)
System Center Virtual Machine
Manager & App Controller
Load balance virtual
machines
MANAGE
For additional information go to http://www.microsoft.com/sqlserver
SQL Server AlwaysOn
Hyper-V Live Migration
TOOLS OR FEATURES
Create database
VM templates
SQL Server Sysprep
System Center Virtual Machine
Manager
STEPS
TOOLS OR FEATURES
Measure usage
- Assign cost
- Map usage to
business units
Windows Azure Pack for
Windows Server,
Charge back and
reporting
Build automation
Windows Azure Pack for
Windows Server, System Center
Service Manager, Orchestrator,
App Controller
In-Memory OLTP, SSD buffer pool
extension, Columnstore, Resource
Governor, Hyper-V scale,
Dynamic Memory, online VHDX,
Tiered Storage, SMB support, NIC
teaming & QoS
System Center Virtual Machine
Manager
THROUGH
Follow us on http://www.facebook.com/sqlserver
STEPS
DRIVE
STEPS
DEPLOY
- Reduce space and power needs
SCALE
CONSOLIDATE
o
Scale resources efficiently
A
SINGLE
Follow us on http://twitter.com/SQLServer
PA N E
OF
Follow us on http://www.youtube.com/sqlserver
GLASS
2013 Microsoft Corporation. All rights reserved.
Call to Action
System Center Service Manager
Windows Azure Pack for
Windows Server, SQL Server
Analysis Services OLAP cubes and
Excel PowerPivot, Power View
Learn more at
http://www.microsoft.com/
SQLServerPrivateCloud
• Discovery, Reporting, and Migration
• Quick discovery of SQL Server 7.0 or later
• Other databases discovery MySQL, Oracle, and Sybase
• Migration to the latest SQL Server on-prem or Azure Virtual Machine
http://Microsoft.com/MAP/
Increased virtual processor & memory
Allows SQL Server VM to use up to 64 virtual processors & 1 TB
of memory
Increased logical processor & memory
Allows SQL Server to use up to 640 logical processors
& 4 TB of memory
Increased cluster node scalability
Supports SQL Server clusters up to 64 nodes
Increased VM density
› Up to 8,000 SQL Server VMs per cluster
› Support for up to 320 logical processors & 4 TB memory
Support for NUMA
QoS – Network Bandwidth Enforcing
Windows NIC Teaming
Cluster-Aware Updating (CAU)
Online
Dynamic Quorum
Windows Server Core
Online VHDX resize (Windows Server 2012 R2)
Online
Updating …
Online
SMB Support
Fiber Channel Support
ReFS Support (SQL Server 2014)
Tiered Storage Spaces (Windows Server 2012 R2)
Reads/Writes
Accumulates
Data Activity
Hot Data
Cold Data
http://download.microsoft.com/download/8/0/F/80FCCBEF-BC4D-4B84-950B-07FBE31022B4/ESG-Lab-Validation-Windows-Server-Storage.pdf
Virtual Machine Manager & App Controller
•
Creation & management of private cloud based on SQL Server VMs
•
Deployment of SQL Server VM across private & public cloud
environments
Operations Manager & Advisor
•
•
Proactive & reactive monitoring of
SQL Server instances
Early detection & problem resolution of SQL Server issues using agentbased operations that perform continuous server scanning
Data Protection Manager
http://download.microsoft.com/download/C/C/1/CC16C89A-E289-4217-B2D8-7DD37A4285B8/ESG-Lab-Validation-WS2012-HyperV-and-SQL2012.pdf
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
Windows Server 2012
250,000 IOPS
1,000,000+ IOPS
http://blogs.technet.com/b/schadinio/archive/2012/07/07/over-1-million-iops-from-a-single-vm.aspx
SQL SERVER
ORACLE
• Only need to license individual VMs (with SA)
• Can participate in Live Migration or VMotion farm
• Oracle does not recognized Hyper-V or VMware ESX as partitioning
• Customers must license all physical cores on the virtualization host
(including all hosts in the cluster for Live Migration)
http://blogs.flexerasoftware.com/elo/2012/09/oracle-database-licensing-in-a-vmware-virtual-environment-part-1-of-3.html
http://blogs.flexerasoftware.com/elo/2012/09/oracle-database-licensing-in-a-vmware-virtual-environment-part-2-of-3.html
http://blogs.flexerasoftware.com/elo/2012/10/oracle-database-licensing-in-a-vmware-virtual-environment-part-3-of-3.html
High Availability
Performance & Scalability
Hyper-V supports up to 64 vCPU, vSphere Enterprise 32 vCPU,
vSphere Enterprise Plus (most expensive edition) 64 vCPU
Windows Server Failover Clustering (WSFC) is a mature
technology and part of Windows Server
Hyper-V supports 320 logical processors per host, vSphere
160 logical processors
SQL Server AlwaysOn (makes full use of WSFC) is the premier
high availability technology for mission critical deployment
Hyper-V supports up to 4 TB physical memory, vSphere
Enterprise Plus (most expensive edition) 2 TB
VMware supports AlwaysOn (WSFC) but
lose KEY features
Customers Retain ALL Hyper-V
Features in AlwaysOn
No VM mobility (vMotion)2
Unlimited & Simultaneous Live Migration
No Dynamic Resource Scheduling2
Mixed Guest/Host Clustering
No VMware Fault Tolerance2
Hyper-V Replica
5 node limits only3
Large storage for single virtual disk (64 TB) vs. 2 TB in vSphere
No support for iSCSI, FCoE, NFS storage protocols3
…..and many more!
No Guest Clustering support
1http://download.microsoft.com/download/E/8/E/E8ECBD78-F07A-4A6F-9401-AA1760ED6985/Competitive-Advantages-of-Windows-Server-Hyper-V-over-VMware-vSphere.pdf
2http://pubs.vmware.com/vsphere-51/index.jsp?topic=%2Fcom.vmware.vsphere.mscs.doc%2FGUID-6BD834AE-69BB-4D0E-B0B6-7E176907E0C7.html
3http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1037959
• What’s being delivered
• Extensions to SQL Server Sysprep functionality to support image based
deployment of clustered SQL Server instances
• Main benefits
• Full automation of SQL Server Failover Cluster deployment scenarios (private and public cloud)
• Reduces deployment times for SQL Server Failover
Clusters
• Built on top of SQL Server 2012 SP1 CU2 Sysprep
enhancements
• Database Engine
• Reporting Services
• Analysis Services
• Integration Services
• Shared features
• What’s being delivered
• Usage of non-volatile drives (SSD) to extend buffer pool
• Main benefits
• Improve query performance
• No risk of data loss (using clean pages only)
• Easy configuration
Example:
ALTER SERVER CONFIGURATION
SET BUFFER POOL EXTENSION ON
SIZE = 50 GB
FILENAME = 'F:\SSDCACHE\EXAMPLE.BPE'
• What’s being delivered
• Single partition online index rebuild
• Managing Lock Priority for table SWITCH and Online Index Rebuild
• Main benefits
• New partition-level granularity for online index rebuild allows lower
resource (CPU/memory) usage to better meet the needs of customers who
need 24/7 access
• Provide customers greater control over impacting running transactions if
using switch partition or online index rebuild commands
• Combined together, these features allow customers to better schedule
resource intensive or blocking operations and better achieve 24/7
availability for their applications
• What’s being delivered
• Add Max/Min IOPS per volume to Resource Governor pools
• Add DMVs and Perf counters for IO statistics per pool per volume
• Update SSMS Intellisense for new T-SQL
• Update SMO & DOM for new T-SQL and objects
• Main benefits
• Better isolation (CPU, memory, and IO) for multi-tenant workloads
• Guarantee performance in private cloud and hosters scenario
• What’s being delivered
• New wizard to deploy a DB to SQL Server in Azure VM
• Main benefits
• Easy to use
• Perfect for DBAs new to Azure and for ad hoc scenarios
• Complexity hidden
• Detailed Azure knowledge is not needed
• Almost no overhead: the defining factor
for time to transfer is DB size
CREATE CREDENTIAL mystoragecred
WITH IDENTITY = ‘mystorage',
SECRET = ‘<your storage access key>
BACKUP DATABASE mydb TO URL ='https://mystorage.blob.core.windows.net/backup-container/mydb20130411.bak'
WITH CREDENTIAL = ‘mystoragecred',
FORMAT, COMPRESSION, STATS = 5,
MEDIANAME = ‘mydb backup 20130411', MEDIADESCRIPTION = 'Backup of mydb'
• What’s being delivered
• An agent that manages and automates SQL Server backup policy
• Main benefit
• Large scale management and no need to manage backup policy
• Context-aware – e.g. workload/throttling
• Minimal knobs – control retention period
• Manage whole instance, or particular DBs
• Leverage Cloud Backup in SQL Server 2012 SP1 CU2 Example:
EXEC smart_admin.sp_set_db_backup
• Inherently off-site
@database_name='TestDB',
• Geo-redundant
@storage_url=<storage url>,
• Minimal storage costs
@retention_days=30,
• Zero hardware management
@credential_name='MyCredential',
@enable_backup=1
• What’s being delivered
• Native support for SQL Server database files stored as Windows Azure blobs
• A first step in moving on-prem SQL Server databases to Azure environment
• Main benefit
• Delivers an incremental path to database in the cloud. Can move one database at a time, without
application changes
• Additional benefits
• Save storage cost: On-premises computing, with bottomless off-site storage in Azure
• Increase HA and DR:
• A set of database files stored in Azure storage – backed by Azure Storage SLA
• Fast disaster recovery using database attach operation without the need to restore data
• Maintain on-prem control of security: Allow TDE key on-prem while encrypted data in Azure
Storage
Migration from VMware
Win from VMware
http://www.microsoft.com/casestudies/Case_Study_Search_Results.aspx?Type=1&Keywords=hyper-v%20vmware%20sql%20server&LangID=46
http://download.microsoft.com/download/6/1/D/61DDE9B6-AB46-48CA-8380-D7714C9CB1AB/Best_Practices_for_Virtualizing_and_Managing_SQL_Server_2012.pdf
Windows
Azure
mva
http://channel9.msdn.com/Events/TechEd
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn