SQL

SQL – 2008 – Performance Monitoring

Monitor Set – SQL 2008 – Performance Monitoring – Monitors: SQLServer:Access Methods Page Splits/sec SQLServer:SQL Statistics Batch Requests/sec SQLServer:Databases Log Flushes/sec SQLServer:General Statist… User Connections SQLServer:Locks Average Wait Time (ms) SQLServer:Buffer Manager Buffer cache hit ratio SQLServer:Memory Manager Total Server Memory (KB) SQLServer:Memory Manager Target Server Memory (KB) DISCLAIMER: All Monitor sets should be used…

Read More

SQL – 2008 – Services

Monitor Set – SQL 2008 – Critical Services Monitors: MSSQLSERVER, MsDtsServer100, MSSQLFDLauncher, ReportServer, SQLWriter Also monitors – sqlservr.exe process for “Down” transition. DISCLAIMER: All Monitor sets should be used as a guideline. Thresholds set, may not be suitable for your exact environment. What works for large clients, may not work for small ones, and vice-versa.…

Read More