How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?



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

Post New Answer

More SQL Server Interview Questions

Explain an automatic checkpoint

0 Answers  


How many triggers you can have on a table?

0 Answers  


How do I edit a stored procedure in sql server?

0 Answers  


Can sql servers linked to other servers like oracle?

0 Answers  


How to rebuild master databse?

0 Answers  


wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,


Why do we use non clustered index?

0 Answers  


There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,


What is the significance of null value and why should we avoid permitting null values?

0 Answers  


How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  


What is difference between createstatement and preparedstatement?

0 Answers  


What are the different types of replication are there in sql server 2000?

0 Answers  


Categories