在MSSQL Server中通过查看SQL语句执行所用的时间，来衡量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 执行完后点消息即可。