Sql Server 查询性能查看

dbcc dropcleanbuffers    --清除buffer pool里的数据页面
dbcc freeproccache        --清除memtoleave和buffer pool里的执行计划内存
set statistics io on
go

-- 要执行的sql语句

set statistics io off
go

 

dbcc ind('test','table_1',-1);

dbcc dropcleanbuffers;
dbcc traceon(3604);
dbcc page('test',1,188,1);

select * from dbo.Table_1