SQL
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…
Read MoreMonitors 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…
Read MoreMonitor 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 MoreDownload and install SQL Express
Read MoreScript 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.
Read MoreMonitor 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…
Read MoreMonitors 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…
Read MoreMonitor 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 More