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 |
Can we move Resource database from one path to another? If yes,How can we?
How to add an address record into adventureworkslt?
How to enter date and time literals in ms sql server?
What is nested transaction?
What to perform pattern match with the like operator?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
what is meant by deafult in sql server?
What is sqlservr.exe - process - sql server (sqlex?press)?
How to replace null values in expressions using isnull()?
Tell me about pre-defined functions of sql?
What is RAID? What are the different types of RAID configurations?
What is SQL Profiler what is the use of it?
2 Answers 247Customer, Steria,