1.查看SQL语句IO消耗
set statistics io on
sql 语句
set statistics io off
2.查看SQL语句时间消耗
set statistics time on
sql 语句
set statistics time off
3.查看SQL语句索引消耗
set statistics profile on
sql 语句
set statistics profile off
原文：http://www.cnblogs.com/chengeng/p/5912021.html