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-default

Scripts are only available to members. Please sign in or join as a member.

How to Download Scripts

In order to access this script you will need to be logged in with a paid account.

Content Copyright
2013 Virtual Administrator
Number of Downloads
7
Script Version
1.0
Script Author
Script RMM
RMM Version
6.2

Search For More Scripts

Generic selectors
Exact matches only
Search in title
Search in content
scripts
training
views
patch_updates
monitorsets
reports
marketingmaterials
Filter by Categories
MSP Guides
Webinars