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 […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |