ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories >> Software >> Databases >> SQL-Server
 
 
 
Question
How to Display, Amount of Disk Activity Generated by 
Transact-SQL Statements?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
Answer
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}
 
0
Guest
 
View All Answers
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com