Export (0) Print
Expand All
2 out of 3 rated this helpful - Rate this topic

SET STATISTICS IO

SQL Server 2000

Causes Microsoft® SQL Server™ to display information regarding the amount of disk activity generated by Transact-SQL statements.

Syntax

SET STATISTICS IO { ON | OFF }

Remarks

When STATISTICS IO is ON, statistical information is displayed. When OFF, the information is not displayed.

After this option is set ON, all subsequent Transact-SQL statements return the statistical information until the option is set to OFF.

There are five output items.

Output item Meaning
Table Name of the table.
scan count Number of scans performed.
logical reads Number of pages read from the data cache.
physical reads Number of pages read from disk.
read-ahead reads Number of pages placed into the cache for the query.

The setting of SET STATISTICS IO is set at execute or run time and not at parse time.

Permissions

SET STATISTICS IO permissions default to all users.

See Also

SET

SET SHOWPLAN_ALL

SET STATISTICS TIME

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.