查看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:

转载于:https://www.cnblogs.com/yolion/archive/2007/07/31/Yolion.html