2011 年 10月 21 日随笔档案 - Fanr_Zh

公告

2011年10月21日

摘要： 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 阅读全文

posted @ 2011-10-21 10:41 Fanr_Zh 阅读(486) 评论(0) 推荐(0)