Summary

In this chapter, we have looked at Delayed Durability and how it can improve performance. It is important that when making use of this new feature in SQL Server 2014, you consider the potential data loss. Delayed Durability is something you should consider using if you have an I/O bottleneck or other related performance issues that Delayed Durability fixes. Always consider the potential for data loss and if that risk is acceptable to you. If the small amount of data loss that comes with Delayed Durability is not a problem for you, then this can be a great way of improving the performance of your databases. If, however, data loss, however small, is not acceptable to you, then this feature is not for you, regardless of the performance enhancement you can get from using it. In the next chapter, we will move on to the new high availability features and enhancements in AlwaysOn Availability Groups.