What Every DBA Needs to know about working with Windows 2016New High Availability Features in Windows Server 2016

David BerminghamMicrosoft Cloud and Datacenter MVPTechnology EvangelistSIOS Technology Corp.

Clusters Your Way.

Clusters Your Way.

Windows Server 2016 CTP4Storage ReplicaCloud WitnessSite AwarenessCluster Rolling UpgradeWorkgroup and Multi-Domainless ClustersStorage Spaces DirectAgenda

Clusters Your Way.Available as evaluation downloadhttps://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-technical-previewAvailable in the Azure Marketplacehttps://azure.microsoft.com/en-us/marketplace/partners/microsoft/windowsservertechnicalpreview/

Windows Server 2016 CTP4

Clusters Your Way.Evaluating Windows Server 2016 CTP4Provision Windows 2016 CTP4 in Azure

Clusters Your Way.

Storage Replica for Multisite Cluster

https://technet.microsoft.com/en-us/library/mt126103.aspx

Clusters Your Way.Transport: SMB3Network: RDMA or TCP/IPRequires Physical Disk Cluster Resource (SCSI-3 reservation support)Requires at least one disk for replication and one for logsOne Target OnlySynchronous OnlyAt least one 1GbE connection on each file server, preferably 10GbE, iWARP, or InfiniBandA network between the two sets of servers with at least 1Gbps throughput (preferably 8Gbps or higher) and average of 5ms round trip latency.

Storage Replica for Multisite Cluster Requirements

Clusters Your Way.Cloud Witness

https://blogs.msdn.microsoft.com/clustering/2014/11/13/introducing-cloud-witness/

Clusters Your Way.Alternative to Disk Witness and File Share WitnessUse casesMulti-Site ConfigurationsBranch OfficeCloud DeploymentsNo Shared Storage AvailableCloud Witness

Clusters Your Way.Cloud WitnessDemonstration

Clusters Your Way.Enhances multi-site cluster experienceEnsures resources run locally whenever possibleLearn Morehttps://blogs.msdn.microsoft.com/clustering/2015/08/19/site-aware-failover-clusters-in-windows-server-2016/

Site Awareness

Clusters Your Way.Assign Nodes to Sites

(Get-ClusterNode SQL1).Site=1(Get-ClusterNode SQL2).Site=1(Get-ClusterNode SQL3DR).Site=2(Get-ClusterNode SQL4DR).Site=2

SQL Server cluster resources failover to a node within the same site, before failing to a node in a different siteSite Awareness

Clusters Your Way.Assign Preferred Site(Get-Cluster).PreferredSite =

Dynamic Quorum drops weights from the Disaster Recovery site During a Quorum SplitSite Awareness

Clusters Your Way.Cross-Site Heartbeating(Get-Cluster).CrossSiteDelay = (Get-Cluster).CrossSiteThreshold =

Adjusting the heartbeating across sites can improve cluster reliability where WAN connections are unreliable by relaxing the heartbeating policy between sitesSite Awareness

Clusters Your Way.Poll QuestionHave you implemented a multisite cluster?

Clusters Your Way.

Cluster Rolling Upgrade

https://technet.microsoft.com/en-us/library/dn850430.aspx

Clusters Your Way.Poll QuestionWhen do you plan to implement Windows 2016?

Clusters Your Way.Eliminates need for Active DirectoryUse CasesMulti-DomainADless environments

Workgroup and Multi-Domain Clusters

Clusters Your Way.Create a local User account on each node in the clusterThe username and password of the account must be the same on all nodesThe account is a member of the local Administrators group on each nodeEach node must have a primary DNS SuffixNew-Cluster Name -Node -AdministrativeAccessPoint DNShttps://blogs.msdn.microsoft.com/clustering/2015/08/17/workgroup-and-multi-domain-clusters-in-windows-server-2016/

Workgroup and Multi-Domain Clusters

Clusters Your Way.Poll QuestionDo you envision ever needing a workgroup or multi-domain cluster?

Clusters Your Way.Storage Spaces Direct

https://technet.microsoft.com/en-us/library/mt126109.aspx

Clusters Your Way.http://blogs.technet.com/b/clausjor/archive/2015/11/23/hardware-options-for-evaluating-storage-spaces-direct-in-technical-preview-4.aspxWe highly recommend using server configurations from our partners, that are in process of being validated, as we have worked closely with them to ensure they function properly and provide the best overall experienceIntel Xeon Processor E5 v3 Family10+ GbE NIC with Remote Direct Memory Access (RDMA) capabilityEach server must be configured with at least 2 performance devices and 4 capacity devicesStorage Spaces Direct supports three storage device attach types: NVMe, SATA or SASFour or more servers in the clusterStorage Spaces Direct Hardware Requirements

Clusters Your Way.

A Word From Our Sponsor

Clusters Your Way.Thank you!Twitter @davebermdavid.bermingham@us.sios.comwww.ClusteringForMereMortals.com

On the Web: www.us.sios.com/clustersyourwayTel: 866.318.0108@SIOSTech

Clusters Your Way.