导航

SQL Server 查看 SQL 语句执行时间

Posted on 2010-03-20 12:54  AlexCube  阅读(392)  评论(0)  编辑  收藏  举报

使用Set Statistics Time On

 

如

 

SET STATISTICS TIME ON

select COUNT(1) from files

 

返回结果：

 

SQL Server parse and compile time:
   CPU time = 0 ms, elapsed time = 0 ms.

SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 0 ms.

(1 row(s) affected)

SQL Server Execution Times:
   CPU time = 16 ms,  elapsed time = 41 ms.