摘要:
DBCC CACHESTATSdisplays information about the objects currently in the buffer cache, such as hit rates, compiled objects and plans, etc.Example:DBCC CACHESTATSSample Results (abbreviated):Object Name Hit Ratio————————-Proc0.86420054765378507Prepared0.99988494930394334Adhoc 0.93237136647793051ReplPro 阅读全文