SQL语句执行效率及性能测试

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

declare @d datetimeset @d=getdate()/*你的SQL脚本开始*/SELECT [TestCase] FROM [TestCaseSelect] /*你的SQL脚本结束*/select [语句执行花费时间(毫秒)]=datediff(ms,@d,getdate())