Dynamics AX High Availability Disaster Recovery January 13

Dynamics AX High Availability & Disaster Recovery January 13, 2022

Agenda • Disaster Recovery Overview • SQL Server • • Editions Licensing Overview HA/DR Technologies HA/DR Features by Edition • AX Considerations • HA/DR Technologies – What you should know • Always. On • Features • Quorum Considerations • Hybrid Scenarios • HA/DR Architectures

Introduction & Objectives About Me About Stoneridge Objective 1 Objective 2 • Josh Lee– Senior Consultant • Focus on Performance, SQL and Stack technologies • Former AX Partner Technical Consultant and Premier Field Engineer for SQL • Microsoft Gold Partner focused on Dynamics AX in Upper Midwest • True product experts with deep experience at Microsoft and in partner channel • Understand High Availability Options for AX • Understand Disaster Recovery options with SQL Server

Disaster Recovery Overview January 13, 2022

What is your Disaster Recovery Plan?

Downtime Planned Unplanned

Recovery Objectives RTO RPO

Return on Investment Avoiding/Reducing Downtime Resource Utilization Automating Recovery

SQL Server Overview January 13, 2022

SQL Server Editions Enterprise Business Intelligence Standard

Licensing Per Core (2 to a pack) Server/CAL

Licensing Per Edition Per Core Enterprise Standard Server/CAL Business Intelligence Free Express

High Availability and Disaster Recovery Technologies WSFC (Always. On FCI) Always On AG Transactional/Snapshot Replication Database Mirroring Log Shipping *Hyper‐V

Features By Editions Enterprise BI Standard Max Cores OS Max 4 Sockets/16 Cores Max Memory OS Max 64/128 GB* Log Shipping Database Mirroring AO FCI ‐ Safety Only ‐ 2 nodes Availability Group Snapshots 2012 ‐ https: //msdn. microsoft. com/en‐us/library/cc 645993(v=sql. 110). aspx 2014 ‐ https: //msdn. microsoft. com/en‐us/library/cc 645993(v=sql. 120). aspx

Comparisons HA/DR Solution RPO RTO Automatic Failover Usable Secondarys AG ‐ synchronous commit 0 Seconds Yes 0‐ 2* AG ‐ asynchronous commit Seconds* Minutes No 0‐ 4* * Seconds ‐ Minutes Yes No 0 Seconds Yes, but. . DBM – high performance Seconds Minutes* No Yes, but. . Log Shipping Minutes – Hours* No Yes, but. . Backup, Copy, Restore Hours* Hours – Days* No Yes, but. . AO‐FCI DBM – high safety

Components of AX AX MR SSRS SSAS

What’s Supported? FCI Always. On Availability Groups (Sync/Async) Log Shipping DBM Transactional/Snapshot Replication

What You Should Know January 13, 2022

What You Should Know - DBM Async ‐ Enterprise Individual DBs Automatic Failover = Witness Placed on deprecated in 2012

What You Should Know - Transactional Requires PK You cannot drop/recreate PKs Terms/Concept s Non‐clustered indexes not default Distribution DB

What You Should Know – Log Shipping No automatic failover Reversal is tricky Data Loss Window

What You Should Know – Clustering Same domain Know your Quorum Shared Storage Enhanced WS 2012+

What You Should Know – AG WSFC AGL ROR Enterprise Only Keywords Logins/Jobs Group of DBs

What You Should Know - AX SSRS cannot be clustered* RS failover broken – not really Read‐only replicas can be used for processing cubes Patch

Patches that I know of. . • AX 2012 RTM – KB 2920058 • AX 2012 R 2 – KB 2956617 • AX 2012 R 2 ‐ KB 2869651 • All 2012 Versions – KB 2984666

Always. On January 13, 2022

Always. On FCI Always. On AG

Always. On - FCI Enhanced Multi‐subnet Support Enhanced Health Monitoring Flexible Failover Policy

Always. On - AG AGL Read Only Routing Groups DBs Flexible Storage

Quorum Considerations January 13, 2022

Quorum Node Majority Mode Majority with Witness No Majority

Dynamic Quorum Windows 2012 Adjusts Quorum Sequentially loss only

Dynamic Witness Windows 2012 R 2 ‐ Default ON Adjusts Witness Vote Even Number Vote Odd Number No Vote Windows 2012 R 2 Always Configure Witness Quorum

Node Weight (Votes) No vote by default Exclude secondary site nodes Include all primary replicas Include possible automatic failover owners Odd number of votes Re‐assess vote assignments post‐failover

Tie breaker for 50% node split Cluster Property (Lower. Quorum. Priority. Node. ID) Allows weight for cluster vote removal Mainly for DR configurations

What You Should Know – AG/FCI DR TTL – 20 m (default) DNS propagation delays Multi. Subnet. Failover=True Evaluate Quorum

Hybrid January 13, 2022

Hybrid cloud solutions Simplified cloud backup Cloud disaster recovery Manual or automatic At an instance level with point ‐in‐time restore Measures database usage patterns to set backup frequency Fast disaster recovery (low RTO) Easy to deploy and manage Windows Azure Secondary replica Asynchronous commit VPN tunnel (Windows Azure Virtual Network) On‐premises network Extend on‐premises apps Domain controller Cloud bursting Greater global reach Better isolation of internal assets Synchronous commit Primary replica Secondary replica

Hybrid DR for SQL Server Deploy 1 or more replicas on‐premise Determine region Low TCO

Architectures January 13, 2022

Database Mirroring Primary Secondary Database Mirroring (sync) Witness

Failover Clustering with Database Mirroring SQL Server FCI 2 SQL Server FCI 1 Database Mirroring (Async) Windows Server Failover Cluster 1 Windows Server Failover Cluster 2

Log Shipping Backup Share Primary Backup Secondarys Copy Restore

Log Shipping with Database Mirroring Primary Secondary Database Mirroring (sync) Witness Log Shipping

Transactional Replication Publisher Distributer (optional)* Subscriber

Failover Cluster Instance with Availability Group Windows Server Failover Cluster DR Site Primary Site Node 1 Node 3 Node 2 Availability Group Synchronous / Asynchronous Node 4

Availability Groups for HA and DR Windows Server Failover Cluster Primary Site DR Site Node 2 Node 1 Node 3 Availability Group Synchronous Asynchronous

Quorum Model and Node Votes Windows Server Failover Cluster Primary Site DR Site Node 2 Node 1 VOTE Node 3 Availability Group VOTE Synchronous Asynchronous VOTE NO VOTE

Hybrid – Typical Configuration Windows Azure On-Premises 49

Hybrid – Robust

Hybrid - Reverse Configuration On-Premises Windows Azure 51