It's a very important decision to choose a protection mode. Every mode has its pros and cons. They all serve different requirements and require specific conditions. The following is a general guide to decide the correct mode:

We've now learned the properties of the data protection modes and we're able to determine the correct mode according to our needs. Note that, if we decide to use the Maximum Protection or Maximum Availability modes but encounter performance problems, we should try to tune the database, server, disk, and network infrastructure before scaling down the data protection level.