SQL Server IO operations

Question

Will some operations, such as DBCC CHECKDB, Update Statistics, database backups, etc., result in relatively large hard disk reads/writes?

Answer 1

Hi @Riley

Yes, but these operations are generally performed as custom tasks, which occur at fixed times each day.

SQL Server basically only reads data files, and it is directly related to the cache capacity of memory, and also related to the amount of data that users need to read.

The number of writes that occur in SQL Server is directly related to the amount of data modification that the user has completed. If most of the operations on a database are queries, SQL Server will have very few write operations.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi Riley •

Yes, running DBCC CHECKDB, Update Statistics, and database backups in SQL Server can result in relatively large hard disk reads/writes.

This is because these operations involve scanning and processing large amounts of data, which can cause a high I/O load on the storage system.

DBCC CHECKDB is a command that checks the logical and physical integrity of all the objects in a database. When you run this command, SQL Server reads all the data pages in the database and performs various consistency checks. This can result in a large number of hard disk reads and writes, especially if the database is large.

To minimize the impact of these operations on hard disk reads and writes, you can Schedule these operations during off-peak hours when there is less load on the server.

Thank you!