Skip to content

Instantly share code, notes, and snippets.

@joymon

joymon/SQL_Server_HADR_Solutions_Comparison.md

Last active January 3, 2020 16:34
Show Gist options
  • Save joymon/7aa45166b970dc8dac80d8213b89960e to your computer and use it in GitHub Desktop.
Save joymon/7aa45166b970dc8dac80d8213b89960e to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server High Availability & Disaster Recovery technologies and comparison
Raw
SQL_Server_HADR_Solutions_Comparison.md

Comparison of SQL Server HA & DR solutions and comparison

No SQL FCI with S2D Alwasy On AG Description
1 MSDTC is not in pre Azure Win 2019 Available from SQL 2016 SP2 onwards Official link
2 Good for large no of database MSFT only tested upto 100 DBs
3 Fail over 30+secs Fail over 1 secs
4 Required shared storage Each node stores
5 DR to be done separately One async node can be for DR
6 FileStream needs non CSV volumne Works natively
7 No read from secondary Support reading secondary read
8 Full instance fail over Group of databases can fail over
9 No automatic page repair automatic page repair
10 Full feature in Standard edition Enterprise only. Standard has basic

References

https://blog.coeo.com/is-this-the-end-of-sql-server-failover-cluster-instances

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment