set statistics time {on|off}
Displays the number of milliseconds required to parse, compile, and execute each statement.

set statistics io {on|off}
Causes SQL Server to display information regarding the amount of disk activity generated by Transact-SQL statements.

Leave a Reply

Your email address will not be published. Required fields are marked *