SQL Server IO operations

Riley 220 Reputation points

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,949 questions
0 comments No comments
{count} votes

Accepted answer
  1. CosmogHong-MSFT 14,821 Reputation points Microsoft Vendor

    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Rahul Randive 4,366 Reputation points Microsoft Employee

    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!

    0 comments No comments