SQL Server Monitoring Tips
Administration
Backups
Configuration
Connections
Corruption
CPU
- SQL Server Function to Measure CPU Usage Per Database
- SQL Server High CPU Query Use Monitoring with PowerShell
Deadlocks
Email
Error Logs
- Automate Monitoring SQL Server Error Logs with Email Alerts
- How to Read Log File in SQL Server using TSQL
- Script to Retrieve All Error Numbers and Messages from the SQL Server Error Log
- Search multiple SQL Server Error Logs at the same time
Free Space
- Collect SQL Server database usage for free space and trending
- Determining space used for all tables in a SQL Server database
- Monitor SQL Server Transaction Log File Free Space
- Monitoring SQL Server Disk Space
- Report to Capture Table Growth Statistics for SQL Server
- Script to determine free space to support shrinking SQL Server database files
- Simple free drive space alert for SQL Server databases
- SQL Server Disk Space Monitoring for all Instances with PowerShell Script
- SQL Server Table Size Report
- Use PowerShell to gather SQL Server database physical file sizes
Growth
Indexing
Logging
Memory
- Monitor CPU and Memory usage for all SQL Server instances using PowerShell
- Monitoring SQL Server Buffer Pool Usage by Database with PowerShell
Notifications
- Automate SQL Server Monitoring with Email Alerts
- Automated Notification Email for SQL Server Object Modifications
- Automated SQL Server WMI Alerts for Server Scope and Server Objects Permissions Changes
- How to setup SQL Server alerts and email operator notifications
- Monitor SQL Server Database File Growth with WMI Alerts
- Monitor SQL Server Databases Changes Using WMI Alerts
- Monitor SQL Server Master Database Changes with WMI Alerts
- Posting SQL Server Notifications to Slack
- Receive SQL Server Alerts through Slack
- SQL Server T-SQL Alerts for Standard and Custom Errors
- Using Powershell to Monitor the SQL Server system_health Extended Event Session
Overview
Performance
- Collect SQL Server Performance Counters and Build Reports with SSRS
- Find, Analyze and Optimize SQL Server Performance with SolarWinds Database Performance Analyzer
- Function to quickly find the worst performing SQL Server Stored Procedures
- Identify Completion Time for Long Running SQL Server Processes using Dynamic Management Objects
- Monitor Performance Counters using PowerShell in SQL Server Agent Job Step
- SQL Server Performance Troubleshooting Database Health Checklist
- SQL Server Performance Troubleshooting System Health Checklist
PowerShell
- How to Check SysAdmin Role in SQL Server with PowerShell
- SQL Server Agent Job Monitoring with PowerShell
- SQL Server Backup Monitoring with PowerShell
- SQL Server Database and Database File Monitoring with PowerShell
- Standardized table based SQL Server monitoring email with PowerShell
Processes
- Different techniques to identify blocking in SQL Server
- Find Current Running SQL Statement in SQL Server
- Killing a SPID and Checking Rollback progress in SQL Server
- sp_who for Sql 2005 (sp_who2k5)
Reporting
- Automatically Send Performance Dashboard Reports during a database event using Reporting Services
- Customized SSRS report to monitor server and database status
Scripts
- Monitoring SQL Server with PowerShell Core Object Setup
- Monitoring SQL Server with PowerShell Instance Data Collection
- SP_WhoIsActive Data Collection and Analysis
Security
- Real time auditing of failed SQL Server logins with user settable performance counters in Performance Monitor
- What does my SQL Server data look like over the wire?
Server
Services
- Find all stopped SQL Server services for all instances
- Monitor a Windows Service Interacting with SQL Server
- Monitor, Start and Stop SQL Server services using xp_servicecontrol
SQL Server Agent
Storage
- Create SQL Server Disk Space Report for All Servers
- Low Disk Space Alert for SQL Server
- Monitor Storage Constraints for SQL Server Data Files
- Simple Free Disk Space HTML report for SQL Server
Tools
- Capture Diagnostic Data and Health Information in SQL Server 2012 using sp_server_diagnostics System Stored Procedure
- End to End Application Performance Management Dashboard with PerfStack
- Install SQL Server 2012 Performance Dashboard Reports
- Intelligent SQL Server and VMware Performance Monitoring Software - Database Performance Analyzer
- Introduction to Utility Control Points in SQL Server 2008 R2
- Monitor Remote SQL Server Instance Availability
- Monitoring SQL Server 2012 - Capture and Parse sp_server_diagnostics output
- Monitoring SSAS, SSRS and SSIS with SQL BI Manager
- Performance Analysis Using SQL Server 2008 Activity Monitor Tool
- Quickly Pinpoint SQL Server Performance Issues with SolarWinds Database Performance Analyzer
- Seamless Monitoring and Reporting for SQL Server
- SQL Server Command Line Tools To Manage Your Server
- SQL Server Monitoring with Powershell and the SQL Server Platform: Analysis and Reporting (Part 3 of 3)
- SQL Server Monitoring with Powershell and the SQL Server Platform: Data Collection (Part 1 of 3)
- SQL Server Monitoring with Powershell and the SQL Server Platform: Data Processing (Part 2 of 3)
- SQL Server Performance and Operational Monitoring for DBAs with ManageEngine Applications Manager
- SSIS Package to Centrally Monitor All SQL Servers
Transaction Logs
- Monitoring SQL Server database transaction log space
- SQL Server Database Activity Based on Transaction Log Backup Size
- Virtual Log File Monitoring in SQL Server 2017
Troubleshooting
- Problems running sp_helpdb in SQL Server
- SQL Server Forensics Analysis Based on Database Backup Size
Wait Types
Windows
