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.
Getting Started with SQL Server 2014 Administration
By :
Getting Started with SQL Server 2014 Administration
By:
Overview of this book
Table of Contents (13 chapters)
Getting Started with SQL Server 2014 Administration
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
SQL Server 2014 and Cloud
Backup and Restore Improvements
In-Memory Optimized Tables
Delayed Durability
AlwaysOn Availability Groups
Performance Improvements
Index
Customer Reviews