SQL Server Administration

Useful SQL Server DBCC Commands

DBCC CACHESTATS displays information about the objects currently in the buffer cache, such as hit rates, compiled objects and plans, etc. Example: DBCC CACHESTATS Sample Results (abbreviated): Object Name       Hit Ratio ————      ————- Proc              0.86420054765378507 Prepared          0.99988494930394334 Adhoc             0.93237136647793051 ReplProc          0.0 Trigger           0.99843452831887947 Cursor            0.42319205924058612 Exec Cxt          0.65279111666076906 View              0.95740334726893905 Default           0.60895011346896522 UsrTab            0.94985969576133511 SysTab            0.0 Check             0.67021276595744683 Rule              0.0 Summary           0.80056155581812771 Here’s what some […]