Database Reference
In-Depth Information
The following script inserts two rows into the table t1 :
USE [DB1]
GO
INSERT INTO [dbo].[t1]
([ID]
,[Name])
VALUES
(1,'Seth'),
(2,'Jake')
GO
The following script will change the database level Delayed Durability option to
Forced . Therefore, all transactions will use Delayed Durability:
USE [master]
GO
ALTER DATABASE [DB1] SET DELAYED_DURABILITY = FORCED WITH NO_WAIT
GO
We will then set up a performance monitor and configure it to monitor log flushes.
I am going to use the graphical tool for this but if you want to monitor for an
extended period of time, you could set up a data collector. (Setting up a data
collector is outside the scope of this topic, but for more information you can visit
http://technet.microsoft.com/en-us/library/cc749337.aspx ).
To start performance monitor, search for performance and double-click on
Performance Monitor .
Add the Log Flushes/sec counter to the live running performance monitor. This
counter is part of the SQL Server:Database object of the monitor graphical user
tool. The tool will look like the following screenshot. As you can see, this is not
a busy database Delayed Durability has forced and there are currently no log
flushes happening:
 
Search WWH ::




Custom Search