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.