What is Eager Writer?
Microsoft SQL Server provides a mechanism to enhance write performance on a database.
This mechanism is used to write to disk immediately or synchronously after it is changed or updated.
This feature enables faster writes to the disk which writes data pages in a more efficient manner
It does not wait for Lazy Writer to come into the picture & write the data to the disk.
The lazy writer writes dirty pages from the buffer cache to the disk asynchronously in batches.
