Um ein grundlegende Informationen eines SQL Servers unter Last/Stress zu erhalten nutze ich typischerweise diese Performance Counter welche Microsoft standardmaßig bereit stellt.
Performance Non-Disk Counters |
|
| Object | Counter |
| Memory | Available Mbytes |
| Memory | Pages Input/Sec |
| Memory | Pages/Sec |
| Paging File | %Usage |
| Paging File | %Usage Peak |
| Process (sqlservr) | %Processor Time |
| Process (Processes) | %Processor Time |
| Processor | %Privileged Time |
| Processor | %Processor Time |
| System | Processor Queue Length |
Performance Disk CountersWhen the data files are places on a SAN additionally Use the performance |
|
| Object | Counter |
| PhysicalDisk | Avg. Disk Sec/Read |
| PhysicalDisk | Avg. Disk sec/Write |
Performance SQL Server Counters |
|
| Object | Counter |
| SQL Server | Buffer Manager: Buffer cache hit ratio |
| SQL Server | Buffer Manager: Page life expectancy |
| SQL Server | SQL Statistics: Batch Requests/Sec |
| SQL Server | SQL Statistics: SQL Compilations/Sec |
| SQL Server | SQL Statistics: SQL Re-Compilations/Sec |
| SQL Server | General Statistics: User Connections |
| SQL Server | Locks: Lock Waits / Sec: _Total |
| SQL Server | Access Methods: Page Splits / Sec |
| SQL Server | General Statistic: Processes Block |
| SQL Server | Buffer Manager: Checkpoint Pages / Sec |