In the preceding section, we looked at monitoring overall disk activity. In this section, we examine what SQL Server’s contribution is to all this disk activity. Disk activity can be categorized into reads and writes. SQL Server carries out writes to the disk for the following processes:
Writing dirty cache pages to disk
Freeing space in the page cache
Logging is a constant occurrence in ...