SQL SERVER 查看SQL语句IO,时间，索引消耗

1.查看SQL语句IO消耗

set statistics io on     
  select * from dbo.jx_order where order_time>'2011-04-12 12:49:57.580' 
set statistics io off

2.查看SQL语句时间消耗

set statistics time on 
     select * from dbo.jx_order where order_time>'2011-04-12 12:49:57.580' 
set statistics time off

3.查看SQL语句索引消耗

set statistics profile on        select * from dbo.jx_order
       where order_time>'2011-04-12 12:49:57.580' 
set statistics profile off
©著作权归作者所有,转载或内容合作请联系作者
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。