Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

What are data resources?

0 Answers  


What is update_statistics command?

0 Answers  


What are system databases in ms sql server?

0 Answers  


How do I find the sql server database version?

0 Answers  


Explain about temporary stored procedure?

0 Answers  






How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

0 Answers  


Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  


What is executereader?

0 Answers  


what is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,


Explain datetime2 data type in sal server 2008?

0 Answers  


What does man by sql wildcard characters in sql server?

0 Answers  


What is difference between rownum and rowid?

0 Answers  






Categories