devxlogo

Display Amount of Disk Activity Generated by Transact-SQL Statements

Display Amount of Disk Activity Generated by Transact-SQL Statements

You can set SQL Server to display information regarding the amount of disk activity generated by T-SQL statements. This option displays the number of scans, the number of logical reads (pages accessed), and the number of physical reads (disk accesses) for each table referenced in the statement. This option also displays the number of pages written for each statement. When STATISTICS IO is ON, statistical information is displayed. When OFF, the information is not displayed. After this option is set ON, all subsequent T-SQL statements return the statistical information until the option is set to OFF.
Here is the syntax:

 SET STATISTICS IO {ON | OFF}
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist