- Sybase® SQL Server Performance and Tuning Guide
Chapter 19
Monitoring SQL Server Performance with sp_sysmon
- Introduction
- Invoking sp_sysmon
- Using sp_sysmon to View Performance Information
- Sample Interval and Time Reporting
- Kernel Utilization
- Task Management
- Transaction Profile
- Transaction Management
- Index Management
- Lock Management
- Data Cache Management
- Procedure Cache Management
- Memory Management
- Recovery Management
- Disk I/O Management