DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
Dbcc DropCleanBuffers
上面三句具体是什么作用,还没查说明.
SET STATISTICS IO ON
SET STATISTICS TIME ON
查询当前的缓存对象.
select * from sys.syscacheobjects
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
Dbcc DropCleanBuffers
上面三句具体是什么作用,还没查说明.
SET STATISTICS IO ON
SET STATISTICS TIME ON
查询当前的缓存对象.
select * from sys.syscacheobjects