How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
Answer Posted / guest
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}
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do you size a resultset?
What is the purpose of the tempdb database?
What is the difference between join and inner join?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
How to find which stored procedure is currently running in sql server?
What is meant by indexing files?
Where is localdb stored?
ow to bring suspect mode datbase online from scratch
What is the difference between Stored Procedures and triggers?
Which command is used for user defined error messages?
What are the different sql server versions?
What is an inner join?
Explain linked server in sql?
What are the characteristics of modern DBMS?
What is the difference between web edition and business edition?