SET STATISTICS PROFILE ON
SET STATISTICS IO ON
SET STATISTICS TIME ON
GO --这之间是要执行的脚本
select * from [UserTable]
GO --这之间是要执行的脚本
SET STATISTICS PROFILE OFF
SET STATISTICS IO OFF
SET STATISTICS TIME OFF
可以分析出cpu开销，IO开销，时间开销
备忘
原文：http://www.cnblogs.com/lonelyxmas/p/5038525.html