SET STATISTICS TIME

Transact-SQL Reference

Transact-SQL Reference

SET STATISTICS TIME

Displays the number of milliseconds required to parse, compile, and execute each statement.

Syntax

SET STATISTICS TIME { ON | OFF }

Remarks

When SET STATISTICS TIME is ON, the time statistics for a statement are displayed. When OFF, the time statistics are not displayed.

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

Microsoft® SQL Server™ is unable to provide accurate statistics in fiber mode, which is activated when you enable the lightweight pooling configuration option.

The cpu column in the sysprocesses table is only updated when a query executes with SET STATISTICS TIME ON. When SET STATISTICS TIME is OFF, a 0 is returned.

ON and OFF settings also affect the CPU column in the Process Info View for Current Activity in SQL Server Enterprise Manager.

Permissions

SET STATISTICS TIME permissions default to all users.

See Also

SET

SET STATISTICS IO