查看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:
页:
[1]