MS SQL执行时间测试

------------------------------------------------------------------------------------ 在事件探查器中能看到执行SP，SQL所占用的时间等信息 -------------------------------------------------------------------------------------- 适用于存储过程 declare @begin_date datetime declare @end_date datetime select @begin_date = getdate() exec 存储过程 select @end_date = getdate() select datediff(ms,@begin_date,@end_date) as '用时/毫秒' 打开SQL Server的查询分析器。在下面语句两个go中间加入要执行的sql语句。 set statistics profile on set statistics io on set statistics time on go <sql语句> 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 Table go SET STATISTICS profile OFF SET STATISTICS io OFF SET STATISTICS time OFF