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 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. Once you assign the monitor set, review the data and make any adjustments you feel are necessary for your environment.
Script Categories
Content Copyright
2013 Virtual Administrator
Number of Downloads
7
Script Version
1.0
Script Author
Script OS
Script RMM
RMM Version
6.2
Search For More Scripts
View More results...