--清空内存中所有缓冲
CHECKPOINT
DBCC DROPCLEANBUFFERS
USE TEST
GO
--查看表在磁盘中的物理特征
DBCC SHOWCONTIG (CONTACT) WITH ALL_INDEXES
--报告一些性能相关的统计
SET STATISTICS IO ON
SET STATISTICS TIME ON
--清空内存中所有缓冲
CHECKPOINT
DBCC DROPCLEANBUFFERS
USE TEST
GO
--查看表在磁盘中的物理特征
DBCC SHOWCONTIG (CONTACT) WITH ALL_INDEXES
--报告一些性能相关的统计
SET STATISTICS IO ON
SET STATISTICS TIME ON