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