参考https://www.cnblogs.com/dxqNet/p/9525136.html

sql语句调优

dbcc freeproccache
dbcc dropcleanbuffers
set statistics time on
set statistics io on
set statistics profile on;
sql语句
set statistics profile off;