Using Procmon.exe to monitor the logwrite size of SQL Server

In the official blog of Microsoft Asia-Pacific Database Support Group, you will find that many articles use the Procmon.exe tool.

Today I would also introduce this tool

How big is the experiment based on this article, SQL Server, per log write? "

Download address for this tool:http://files.cnblogs.com/lyhabc/ProcessMonitor.zip

The test content in the article is like this

What is the minimum size of SQL Server log write?

I did a test for this (Windows 7+sql server 2012)

1 I format the disk, the minimum allocation unit is 4KB

2) I put the log on the disk

3) I commit a very small transaction

To be like the test environment in the article

I'll give you a screenshot of the allocation unit of the disk character for this database.

Test script:

Use [Northwind]   
go   
CREATE TABLE T1 (C1 INT)   
go   
BEGIN TRAN   
inserts into  T1   
VALUES  (1)   
COMMIT