Monitor Set – SQL 2005 – Performance Monitoring. Monitors Databases Active Transactions and Transactions/sec, General Statistics – monitors User Connections, Locks – Average Wait time (ms) and Memory Manager – Maximum Workspace.
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.
If you experience any problem or can improve the monitor set, please post below.