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

youtube-video-thumbnail

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

View More results...

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