Availability groups provide some exciting features in mixing high availability and disaster recovery; however, from a performance consideration, there are a few drawbacks. With the advances in SQL Server 2016, our guest Jimmy May from SanDisk, set out to test the features and see if they could get some really high performance out of an availability group with two synchronous replicas. In this episode he talks with us about some of his findings and some of the pains associated with getting there.
Show notes are available at http://sqldatapartners.com/2016/12/31/availability-group-improvements/ and have fun on the SQL trail!
Episode 195: Understanding DAX
Episode 194: PolyBase Use Cases
Episode 193: Power BI Premium
Episode 192: The DBA is Dead! Long Live the DBA!
Episode 191: Power BI Row-Level Security
Episode 190: SQL Server 2019
Episode 189: Power BI Common Data Model
Episode 188: Databricks
Episode 187: Power BI Performance Tuning
Episode 186: Analytics & Security: Find Pain Points, Make a Plan
Episode 185: DBATools in a Month of Lunches
Episode 184: Where do people get stuck with Power BI?
Episode 183: SQL Server Big Data Clusters
Episode 182: XEvents
Episode 181: Paginated Reports in Power BI
Episode 180: PolyBase in SQL Server 2019
Episode 179: SQL Trail Recap & Buying Power BI
Episode 178: Database Design
Episode 177: Lock Pages in Memory
Episode 176: Power BI Storage Options
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast