Monitor Sets
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…
Read MoreMonitor 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…
Read MoreMonitor 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.…
Read MoreAlarms when any existing drive falls below 750MB for 5 minutes and re-arms after 8 hours. 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…
Read MoreOld script that alarms at 2% low disk space for ALL Logical Disk drives. Uses both *ALL command as well as individual drive letters to ensure it works.
Read MoreDownloads and installs Microsoft baseline security analyzer. Works on x86 & x64
Read MoreScript downloads txt files with dl location, current version, & install argument. Script then installs or repairs if already installed. Writes to script log if successful. Script then deletes installer and all txt files. Able to report by filtering Agent Procedure logs for $dotNET4$=All entries regarding .NET 4.0, $Audit$=All entries regarding all audit scripts, $Installed$=All…
Read MoreScript clears the application event log and backs up event entries in the kworking directory as the prompted file name. Script then writes to script log if successful it also writes file name and location of backup.
Read MoreScript clears the security event log and backs up event entries in the kworking directory as the prompted file name. Script then writes to script log if successful it also writes file name and location of backup.
Read MoreScript clears the system event log and backs up event entries in the kworking directory as the prompted file name. Script then writes to script log if successful it also writes file name and location of backup.
Read More