执行sql所用时间测试方法

1.

SET STATISTICS PROFILE ON
SET STATISTICS IO ON
SET STATISTICS TIME ON
GO /*--你的SQL脚本开始*/
SELECT [TestCase] FROM [TestCaseSelect]
GO /*--你的SQL脚本结束*/
SET STATISTICS PROFILE OFF
SET STATISTICS IO OFF
SET STATISTICS TIME OFF

2、declare@ctdatetime
set@ct=getdate()  
---  
--sql   语句  

---  
selectdatediff(ms,   @ct   ,getdate())   as'查询时间（毫秒）'

转载于:https://blog.51cto.com/5133852/1250849