Counters for Monitoring SQL Server Performance

Below are the top few counters which we need to monitor to know SQL Server performance.

On the basis of optimal values of the counters, we can identify performance of SQL Server...

They are...

 1.  SQLServer: Buffer Manager: Buffer Cache hit ratio

 2.  SQLServer: Buffer Manager: Page life expectancy

 3.  SQLServer: SQL Statistics: Batch Requests/Sec

 4.  SQLServer: SQL Statistics: SQL Compilations/Sec

 5.  SQLServer: SQL Statistics: SQL Re-Compilations/Sec

 6.  SQLServer: General Statistics: User Connections

 7.  SQLServer: Locks: Lock Waits / Sec: _Total

 8.  SQLServer: Access Methods: Page Splits / Sec

 9.  SQLServer: General Statistic: Processes Block

10. SQLServer: Buffer Manager: Checkpoint Pages / Sec