查看SQL语句在SQL Server上的执行时间
打开SQL Server的查询分析器。在下面语句两个go中间加入要执行的sql语句。
set statistics profile on
set statistics io on
set statistics time on
go
<这里写上你的语句...>
go
set statistics profile off
set statistics io off
set statistics time off
For example:
SET STATISTICS io ON
SET STATISTICS time ON
go
SELECT * FROM TBL_MeetingRoomOrder
go
SET STATISTICS profile OFF
SET STATISTICS io OFF
SET STATISTICS time OFF
Result: