Database Reference
In-Depth Information
This hardens the transaction to the log and you can view the log flush in
Performance Monitor :
The spike in the counter indicates the log flush.
If the database's Delayed Durability setting had been set to Disabled , the log flush
would have occurred after the commit.
Next, the following script sets the Delayed Durability setting to Disabled :
USE [master]
GO
ALTER DATABASE [DB1] SET DELAYED_DURABILITY = DISABLED WITH NO_WAIT
GO
 
Search WWH ::




Custom Search