partner practice enablement - overview in this session students will learn how to properly deploy,...
TRANSCRIPT
Partner Practice Enablement - Overview
In this session students will learn how to properly deploy, manage and scale SQL Server and SharePoint Server in Microsoft Azure Infrastructure Services. SQL Database will also be introduced. Topics such as automation, capacity planning and high availability will be discussed.
Audience: IT Professionals, Architects and Developers
Module 1 – Introduction to Microsoft Azure
Module 2 – Microsoft Azure Virtual Machines
Module 3 – Microsoft Azure Networking
Module 4 – Microsoft Azure Active Directory
Module 5 - Cloud Services and Web Sites
Module 6 - SQL Server and SharePoint
Module 7 - Management and Monitoring
CEO & Co-Founder of Opsgility, Experts in Instructor-Led Microsoft Azure Training.
Prior to starting Opsgility Michael was a Principal Cloud Architect with a leading Solution Integrator and a fifteen year Microsoft veteran. While at Microsoft Michael's roles included being a Senior Program Manager on the Microsoft Azure Runtime team and a Senior Technical Evangelist for Microsoft Azure Infrastructure Services.
Michael was the original developer of the Microsoft Azure PowerShell Cmdlets and is a globally recognized speaker for conferences such as TechEd and BUILD.
About the Instructor
Michael WashamMicrosoft Azure Trainer
http://www.opsgility.com
Twitter: @MWashamTX
SQL Server and SharePoint on Microsoft
Azure
Agenda
SQL Server in Microsoft AzureIntroducing Azure SQL DatabaseSharePoint Server in Microsoft Azure
SQL Server and Microsoft Azure
SQL Server and Microsoft Azure Virtual Machines
Supported VersionsSQL Server 2014, 2012, 2008 R2
Supported FeaturesAll SQL Server features supported
SQL Server ProvisioningCloud-first using stock images, bring your own server / VHD, capture cloud images
SQL Server LicensingPay by the hour or migrate your own license via Software Assurance **
** Microsoft Azure Compute, Bandwidth and Storage charges also apply
Bring your own LicenseCreate your own Image1. Create a VM based on base Windows Server
image
2. RDP into server
3. Follow instructions for creating a sysprepped image of SQL Server: http://technet.microsoft.com/en-us/library/ee210664.aspx
4. Run SysPrep and Shutdown the Virtual Machine
5. Capture the VM
Full Production Environment
Development and Test Environments
Cloud-based backup of on-premises data
SQL Server Always On w/ cloud-based secondary's
Common Scenarios
Running SQL Server in a Microsoft Azure VM
Storage RecommendationsVerify Disk Cache Settings on Data Disks (See whitepaper link below)
Avoid using OS drive for databases
Put database and transaction log files on separate drives
Use SQL Server File Groups instead of Disk Striping
Database RecommendationsConsider using database page compression to reduce I/O
High Availability RecommendationsConsider latency between primary and replica when choosing sync mode
Use Availability SetsMore at http://go.microsoft.com/fwlink/?LinkId=306266
More on StoragePerformance ConsiderationsDo not use the temporary disk (D:\) (including for TempDB)
Use SQL file groups across multiple disks instead of disk striping
Put logs, data and backup on separate disks
Disable geo-replication on storage account for consistency
Remember storage account capacity planning.
20,000 IOPS per Storage Account – 500 IOPS per disk
Consider compressing any data files when transferring in/out of Microsoft Azure.
More at http://go.microsoft.com/fwlink/?LinkId=306266
Migrating to Microsoft AzureRight-size the VMsCost impact – will pay compute, storage and bandwidth charges
Data Import and Export service for large data sets:
http://www.windowsazure.com/en-us/documentation/articles/storage-import-export-service
Supported VersionsBring your own – 2008, 2008 R2, 2012, 2014
Platform – 2008 R2, 2012, 2014
Licensing ConsiderationsBYO – License Mobility via Software Assurance
Platform – Included in the per hour rate
Understand platform image configuration differencesMore at http://msdn.microsoft.com/library/windowsazure/dn133142.aspx
SecuritySecurity ConsiderationsSimilar practices as on-premises
Regulatory Compliance - Microsoft Azure Trust Center
http://www.windowsazure.com/en-us/support/trust-center/
Remove unused public endpoints
Consider a Point to Site or Site to Site VNET for administration
Set ACL to limit IPs and/or subnets
More at http://msdn.microsoft.com/library/windowsazure/dn133147.aspx
SQL Server Microsoft Azure Integration
SQL Server 2012Backup to Microsoft Azure blob storage (PowerShell or T-SQL), On-premises and Microsoft Azure
SQL Server 2014Database Migration to Microsoft Azure
SQL Server Always On Hybrid (On-Premises and Replica in Microsoft Azure)
SQL Database files can be created directly in Microsoft Azure Storage
SQL Server Backup to Microsoft Azure Storage URL or fully Managed with UI Integration
High Availability and Disaster Recovery
Key ScenariosHigh Availability within Microsoft Azure
Disaster Recovery between on-premises and Microsoft Azure
Disaster Recovery across Microsoft Azure Data Regions
More at http://msdn.microsoft.com/en-us/library/windowsazure/jj870962
HA - SQL Always On Availability Groups
PRIMARY SECONDARY WITNESS
SYNCHRONOUS COMMIT
Availability Set: SQLAVSET
Microsoft Azure Virtual Network
SQL Availability Group
Active Directory
Up to 4 ReplicasCan be read only
Replica AuthenticationActive Directory
DependenciesActive DirectoryVirtual NetworkAvailability SetAutomatic failover with listener (secure with ACL)
Listener (1433)
HA - SQL Always On Availability Groups Hybrid
PRIMARY SECONDARY WITNESS
SYNCHRONOUS COMMIT
Microsoft Azure Virtual Network
On-Premises SQL Server Availability Group
SECONDARY
ASYN
CH
RO
NO
US
CO
MM
IT
IP SEC
Up to 4 ReplicasCan be read only
Replica AuthenticationActive Directory
DependenciesCreate Availability Group on-premisesEstablish VPNAdd Secondary Replica in Microsoft Azure
HA - SQL Server Mirroring
Replica AuthenticationActive DirectoryCertificates
SetupVirtual NetworkAvailability SetEstablish mirror with witness (Witness for automatic failover)
PRIMARY SECONDARY WITNESS
SYNCHRONOUS COMMIT
Availability Set: SQLAVSET
Microsoft Azure Virtual Network
SQL Mirror
Active Directory
DR - Spanning Cloud Azure Regions
SQL Mirroring or Always On with a Regional Virtual Network or ExpressRoute
PRIMARY
West US
SECONDARY
East US
ASYNCHRONOUS
COMMIT
IPSEC/VPN
ExpressRoute Circuit
DR – SQL Backup/Restore Using Blob StorageBackup or Restore using Microsoft Azure StorageHighly Available and Durable with 3 Local Copies of all BlobsEnable Geo-Replication for 3 additional copies in a remote regionSQL can be on-premises or cloud based
SQLVM
West USMicrosoft Azure Storage
Backup DB
Restore DB
DR: SQL Log Shipping
PRIMARY
Microsoft Azure Virtual Network
On-Premises
SECONDARY
LOG
SH
IPPIN
G /
SM
B
IP S
EC
ACTIVE DIRECTORY
ACTIVE DIRECTORY
SQL Shipping Uses File Share (SMB)
Requires Active Directory and VPN for offsite disaster recovery.
Introducing SQL Database
Delivers Database-as-a-Service functionality, based on SQL Server and hosted in Microsoft Azure
Focuses on predictable performance, scalability, business continuity, data protection, zero administration, and familiar tools
Service TiersPredictable performance and business continuityBasicSmall databaseSingle operation at one point in time
Up to 2GB DB Size
StandardTypical workgroup or web applicationMultiple concurrent transactions
Up to 250 GB DB Size
PremiumMission-critical applicationsHigh volume of concurrent transactions
Up to 500 GB DB Size
Web and Business tiers are being retired
Predictable PerformancePerformance Level• Measured in Database Throughput Units (DTUs)
• DTU = unit of measurement for power of combined CPU, memory, physical reads, and transaction log writes
• DTUs allow comparison of resources that power different performance levels
Transaction Rate• Transactions per units of time (in benchmark testing)
Predictability• Consistency of response time
Predictable Performance
ServiceTier
PerformanceLevel
DTUs MaximumSessions
TransactionRate
Predictability
Basic Basic 5 100 3,467/hour GoodStandard S1 15 200 283/minute Better
S2 50 500 1,470/minute BetterPremium P1 100 2,000 98/second Best
P2 200 4,000 192/second BestP3 800 16,000 730/second Best
Predictable Business ContinuityServiceTier
PerformanceLevel
Point in Time Restore Disaster Recovery
Basic Basic From the past 7 days Database copy andManual export
Standard S1From the past 14 days Database copy and
Manual exportS2Premium P1
From the past 35 days Active geo-replicationP2P3
SQL Server vs. Microsoft Azure SQL Database
SQL Server (IaaS)
Microsoft Azure SQL Database (PaaS)
Development Migrate Existing or Build New Apps Develop New Apps
Management Full Control Managed Service
Compatibility Full SQL Server Capabilities Based on SQL Server Technology
Shared TechnologyNetwork transport (Tabular Data Stream)SQL dialect (Transact-SQL)Data access APIs (ADO.NET, ODBC, JDBC)Development tools (SQL Server Data Tools)Management tools (SQL Server Management Studio)
More Information: http://blogs.msdn.com/b/windowsazure/archive/2013/02/14/choosing-between-sql-server-in-windows-azure-vm-amp-windows-azure-sql-database.aspx
DEMO SQL Database
SharePoint Server and Microsoft Azure
SharePoint Cloud Continuum
CONTROL
CO
ST-E
FF
ICIE
NC
Y
SharePoint(On-premises)
• SharePoint
Value PropFull h/w control – size/scaleRoll-your-own HA/DR/scale
Value Prop100% of API surface areaEasy migration of existing appsRoll-your-own HA/DR/scale
SharePoint (IaaS)
• Hosted SharePoint
Value PropAuto HA, Fault-ToleranceFriction-free scaleSelf-provisioning, mgmt. @ scale
• SharePoint Service
Office 365 (SaaS)
Product SupportSharePoint Server 2010 and 2013 supports the hosted virtualization solution of Microsoft, as well as required technologies, such as Microsoft SQL Server, when these products and technologies are deployed on the Microsoft Azure platform.
FAST SupportDo not support Microsoft FAST Search Server 2010 for SharePoint deployments on Microsoft Azure.
SharePoint Support on Microsoft Azure
SharePoint 2013 TrialFarm install wizard not executed
Not configured for single-server install (best for multiple servers – AD server and SQL Server)
Can be upgraded to fully licensed version
VM Gallery
SharePoint Architecture TipsIOPS Most Important FactorOptimize SQL Server Storage Only SharePoint is on the C: drive
Scale Out Not UpMove content databases to separate SQL ServersMove search databases to separate SQL ServersAdd more WFE for scaling SharePoint servicesAdd dedicated Search Servers and SQL Server
Microsoft Azure and SharePoint TipsDeploy Using a Virtual NetworkRequired for Active Directory
Use Multiple Data Disks Spread the IOPs around (up to 16 1TB Data Disks per VM with XLarge+ VMs)
Group Virtual Machine tiers into Availability SetsRemember: Availability Sets give your VMs hardware level high availability
Use HTTP or TCP Health Probes on Web Front EndsHave the load balancer help determine when your web front ends are available for
additional HA.
Focus on Agility and AutomationDeploying and managing SharePoint in the cloud can be scripted.
Remember a Stopped VM doesn’t charge you!
SharePoint 2013 Deployment Option 1 – PowerShell Automation ScriptsPowerShell Scripts that use Remote PowerShell for automated deployment of Active Directory, SQL Server and SharePoint 2013.
Two Sample Configurations Available (uses Trial Image)
HighlyAvailable and SingleVMs
Download from GitHub
https://github.com/windowsazure/azure-sdk-tools-samples
Option 2 – SharePoint Server Farm deployment in the Azure Preview Portal
Highly Available TemplateAD/DC/DNS
LBWEB SQLAPP
80
20000Admin
Cloud Service
Virtual Network
Microsoft Azure
AVSETSPWEB
AVSETSPAPP
AVSETSQLHA
AVSETDCSET
Web Tier2 x Large(4 Cores & 7 GB)
App Tier2 x Large(4 Cores & 7 GB)
Data Tier2 x A6(4 Cores & 28 GB)1 x Small (Quorum)(1 Core & 1.75 GB)
Identity Tier2 Small(1 Core & 1.75 GB)
Single Virtual Machines Template
AD/DC/DNSWEB/APP SQL
Cloud Service
Virtual Network
Microsoft Azure
Web/App Tier1 x Large(4 Cores & 7 GB)
Data Tier1 x A6(4 Cores & 28 GB)
Identity Tier1 Small(1 Core & 1.75 GB)
LB
80
20000Admin
AVETSPWEB
AVSETSQL
AVSETDCSET
DEMODeploying SharePoint 2013
Summary
SQL Server in Microsoft AzureIntroducing Azure SQL DatabaseSharePoint Server in Microsoft Azure
Coming Up Next . . .Management and Monitoring Microsoft Azure Virtual Machines
Thank You