How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
Answer / 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 |
How to get a list of columns in a view using "sys.columns" in ms sql server?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Why de-normalization required?
Why are sql functions used?
What are cursors in ms sql server?
How will you find out if there are expensive SQL statements running or not?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
How to Insert multiple rows with a single insert statement?
How can I enforce to use particular index?
What are basics of policy management?
Explain having clause?
What types of integrity are enforced by a foreign-key constraint