The Art and Science of Designing a Mission Critical SQL Server
Duration: 60 minutes
Track: Strategy and Architecture
When asked to design a critical database system, too many people pick an HA feature and then design the solution around it. This usually results in a costly and disappointing design.
This session will show you the five basic archetypes for mission critical database systems and how to select the right features from SQL Server to implement each design. Along the way you’ll hear some best practices, tips, and real world advice for choosing between features like Availability Groups and clustered instances of SQL Server, as well as the history of some of the more interesting and less often used availability features. You will also get a glimpse of how some of the largest mission critical systems running on the Microsoft platform are created using a distributed model where redundancy replaces failover.
While you may not be able to revisit your current designs right away, what you learn will improve how you approach thinking about making a system as fail-proof as it can be.