Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Advanced
Nov 12, 1999

Display Amount of Disk Activity Generated by Transact-SQL Statements

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}
Jai Bardhan
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date