How much data loss is a “near zero” data loss (300)

Speaker: Margarita Naumova

You have probably heard that SQL Server AlwaysON Availability Group provides a near zero data loss. But it is very important to understand what does it mean. Are you not losing any data at all in case of failover? Are you able to make such a promise? Or you are going to lose some data in some scenarios? To give an answer to yourself or to your customers, you need to understand how the Availability Group works and what happens in case you need to perform failover, when are you able to guarantee near zero data loss. In this session, I am going to describe the availability group commit and failover process and in case you are forced to perform a failover how to be understand the amount of data that have been lost.