1. 查询sql所消耗io性能
set statistics io on
select * from t_his_card_log where fyid = '0301014'
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
set statistics io on
select * from t_his_card_log where fyid = '0301014'
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