DB Options : -Delayed Durability
Delayed durability is one the few features available to database professionals to improve write performance. Often for highly transnational databases we encounter disk level latency on writes. Most of the improvements would require changes to server hardware etc. Delayed Durability when done right is Simple, Effective and easy to do.
It should not be taken for granted that each and every transaction requires synchronous commits. Often there are a number of cases in databases where a slight delay and possible data loss is technically acceptable. The biggest issue with delayed durability is the number of features that it is not compatible with , most commonly replication. In all other cases there is a risk of data loss.
In this video I use Ostress.exe to simulate a high oltp workload and compare wait stats for Writelog to show the improvement in wait times.
Need more information? Visit https://www.enabledbusinesssolutions.com
To know more about Jayanth Kurup visit http://www.jayanthkurup.com
Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years’ experience. He has worked with companies like Microsoft, IBM, HCL, Wipro, Well Fargo, Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community.
In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc
You can also reach Jayanth via his LinkedIn profile below / jayanth-kurup
music from HAAWK