Sql Server : Enable execution STATISTICS for IO and Time for queries
- Posted by Sqltimes
- On August 2, 2014
- 0 Comments
Quick one today:
Sometimes, for some scripts, viewing execution statistics for IO and TIME help measure the improvement you make with code changes.
They could be enabled with the following T-SQL:
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
---- Enable IO and TIME execution statistics for a query--SET STATISTICS IO ONSET STATISTICS TIME ONGO-- Run some querySELECT * FROM sys.objectsGO-- disable themSET STATISTICS IO OFFSET STATISTICS TIME OFFGO |
Result:
SET STATISTICS ON
Hope this helps,
_Sqltimes
0 Comments