Script Category: SQL

SQL – 2005 – Performance Monitoring

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.

SQL – 2005 – Services

Monitors the base SQL services, including msftesql, MSSQLSERVER, SQL Server Agent, SQLSERVERAGENT, and SQLWriter. 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… Continue Reading

SQL – 2005 – Services monitoring

Monitor Set – SQL 2005 – Services monitoring.   monitors MSSQLSERVER, SQLSERVERAGENT, SQL Server Agent, SQLWriter, and msftesql. 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… Continue Reading

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… Continue Reading

SQL – 2008 – Services

Monitor Set – SQL 2008 – Critical Services Monitors: MSSQLSERVER, MsDtsServer100, MSSQLFDLauncher, ReportServer, SQLWriter Also monitors – sqlservr.exe process for “Down” transition. 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.… Continue Reading

Monitor SQL Database

Script downloads vbs files which executes which gathers sql database size and log size and write values to script log if successful. Script then deletes all files. Continue Reading

SQL – 2005 – Performance Monitoring

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… Continue Reading

SQL – 2005 – Services

Monitors the base SQL services, including msftesql, MSSQLSERVER, SQL Server Agent, SQLSERVERAGENT, and SQLWriter. 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… Continue Reading

SQL – 2005 – Services monitoring

Monitor Set – SQL 2005 – Services monitoring.   monitors MSSQLSERVER, SQLSERVERAGENT, SQL Server Agent, SQLWriter, and msftesql. 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… Continue Reading

Copyright ©2014-2016 Network Depot LLC.

12040 South Lakes Drive Suite 202 Reston, VA 20191 USA

Terms of Service - Refund Policy - Privacy Policy

Skip to toolbar