SQL Server Performans Monitoring (Top 10 SQL Server Counters)

Microsoft’ un tavsiye ettiği SQL Server performansı için en önemli performans sayaçları.

1. Buffer Manager: Buffer cache hit ratio

2. Buffer Manager: Page life expectancy

3. SQL Statistics: Batch Requests/Sec

4. SQL Statistics: SQL Compilations/Sec

5. SQL Statistics: SQL Re-Compilations/Sec

6. General Statistics: User Connections

7. Locks: Lock Waits / Sec: _Total

8. Access Methods: Page Splits / Sec

9. General Statistic: Processes Block

10. Buffer Manager: Checkpoint Pages / Sec

SQL Server Performans Monitoring (Top 10 SQL Server Counters)