获取sql执行时间方法2
--清除缓存CHECKPOINT;DBCC DROPCLEANBUFFERS;DBCC FREEPROCCACHE;DBCC FREESYSTEMCACHE ('ALL');GO SET STATISTICS TIME ON; GO SELECT top 200 * from tableGO SET STATISTICS TIME OFF; GO
本文共 253 字，大约阅读时间需要 1 分钟。
获取sql执行时间方法2
--清除缓存CHECKPOINT;DBCC DROPCLEANBUFFERS;DBCC FREEPROCCACHE;DBCC FREESYSTEMCACHE ('ALL');GO SET STATISTICS TIME ON; GO SELECT top 200 * from tableGO SET STATISTICS TIME OFF; GO
转载于:https://www.cnblogs.com/dinghanhua/p/9709838.html