Follow Our FB Page << >> 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:


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