Today, I will introduce this tool. This experiment is based on this article: The test content in this article is SQLserv.
How can I use procmon.exe to monitor SQLSERVER's logwrite size? Today I will also introduce this tool. This experiment is based on this article: The test content in this article is such an SQL serv
If procmon.exe is used to monitor the logwrite size of SQLSERVER
In the technical support team of Microsoft Asia Pacific data warehouse, you will find that many articles use the procmon.exe tool.
Today, I will also introduce this tool.
This experiment is based on this article 《
Of this tool:
The test content in this article is as follows:
What is the minimum size of SQL server log write?
So I did a test (Windows 7 + SQL server 2012)
1) I format the disk. The minimum allocation unit is 4 kb.
2) I put the log on the disk.
3) I commit a very small transaction.
To be the same as the test environment in the article
I will show the distribution unit of the drive letter of the database.
Test script:
T1 (c1 INT) t17 VALUES (1) 8 COMMIT,