How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
- 1 Answers
- 4925 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is 1nf normalization form?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Write an sql query to find first weekday of the month?
How to set a database state to offline in ms sql server?
How to generate create function script on an existing function?
What is forward - only cursors / read only cursor?
Can you explain different types of locks in sql server?
How to turn on the mssql api module in php?
Write a SQL command to insert and update only a particular field?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What are the advantages of sql azure?
Which tools are available to manage SQL Azure databases and servers?
What is a view in sql?
What is indexing and its types?
How to bind a view to the schema of the underlying tables?
