Monitoring

Learn about SQL Server Monitoring from these valuable tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.

Title Author Date
How to setup SQL Server alerts and email operator notifications David Bird2026-06-19
Kill a SQL Server SPID and Check Rollback Progress MSSQL Tips2026-06-17
Monitoring SQL Server – What, When, and How? MSSQL Tips2026-06-15
Sending messages to Slack from SQL Server 2025 Aaron Bertrand2026-06-15
Enterprise SQL Server Performance Tuning and Management Jeremy Kadlec2026-06-03
Monitor Performance Counters with PowerShell in SQL Server Agent Job Pablo Echeverria2026-05-29
Install SQL Server 2012 Performance Dashboard Reports Ashish Kumar Mehta2026-05-22
Configure SQL Server Alerts for Azure SQL Managed Instance Aleksey Vitsko2026-05-13
Manage Long Running SQL Queries and SQL Agent Jobs Temidayo Omoniyi2026-04-29
Monitor SQL Server Performance at Scale with SQLGrease Jared Westover2026-03-03
Monitor SQL Server Performance and Daily Operations with dbWatch Jared Westover2025-01-01
Troubleshooting High CPU Utilization in SQL Server Jeffrey Yao2024-08-19
Monitoring SQL Server database transaction log space Greg Robidoux2024-05-22
Troubleshoot Active Sessions in SQL Server vs. Oracle Pablo Echeverria2023-05-01
Database Monitoring and Management – Manage more, better and for less MSSQL Tips2023-03-02
Check SQL Server Instance and Database Best Practice Settings Jeffrey Yao2022-10-25
Capturing SQL Server Deadlocks using Extended Events Eduardo Pivaral2022-08-03
How to Read Log File in SQL Server using TSQL Greg Robidoux2022-02-24
Troubleshoot SQL Server Network Issues Impacting Performance Joe Gavin2021-10-13
Performance Monitor Counters for SQL Server Storage Joe Gavin2021-09-27
Windows Performance Monitor Counters for SQL Server Joe Gavin2021-08-20
Determining space used for all tables in a SQL Server database Greg Robidoux2021-08-11
Introduction to Windows Performance Monitor for SQL Server Joe Gavin2021-07-30
SQL Server Statistics Collection and Analysis Alejandro Cobar2021-07-16
SQL DROP TABLE Investigation Options Joe Gavin2021-04-29
SQL Server Memory Usage Query Eli Leiba2021-04-15
SSMS Custom Report for SQL Server Database Metrics Eduardo Pivaral2021-04-02
Custom SSMS SQL Server Instance Level Metrics Report Eduardo Pivaral2021-03-24
How To Check Disk Space in SQL Server Alejandro Cobar2021-02-10
Monitor SQL Server Table Size with PowerShell Alejandro Cobar2020-12-15
sp_whoisactive SQL Server Monitoring Alejandro Cobar2020-11-30
Monitoring SQL Server Version and Build Numbers Alejandro Cobar2020-11-09
SQL Server Monitoring with PowerShell for Database Security Alejandro Cobar2020-10-12
SQL Server Monitoring of Buffer Pool Usage by Database Alejandro Cobar2020-09-28
SQL Server High CPU Query Use Monitoring with PowerShell Alejandro Cobar2020-09-11
SQL Server Wait Stats Monitoring with PowerShell Alejandro Cobar2020-08-31
Posting SQL Server Notifications to Slack Ian Fogelman2020-08-27
Monitor all Indexes in SQL Server with PowerShell Alejandro Cobar2020-08-26
How to Check SysAdmin Role in SQL Server with PowerShell Alejandro Cobar2020-08-20
Find Current Running SQL Statement in SQL Server Tim Ford2020-08-14
SQL Server Database and Database File Monitoring with PowerShell Alejandro Cobar2020-07-30
SQL Server Agent Job Monitoring for Last Execution with PowerShell Alejandro Cobar2020-07-27
SQL Server Backup Monitoring with PowerShell Alejandro Cobar2020-06-30
SQL Server Agent Job Monitoring with PowerShell Alejandro Cobar2020-06-29
Monitoring SQL Server with PowerShell Instance Data Collection Alejandro Cobar2020-06-25
Monitoring SQL Server with PowerShell Core Object Setup Alejandro Cobar2020-06-24
SQL Server Table Size Report Eli Leiba2020-03-19
SP_WhoIsActive Data Collection and Analysis Jeffrey Yao2020-03-11
Script to find free space for shrinking SQL Server database files Ken Simmons2020-01-08
SQL Server Function to Measure CPU Usage Per Database Eli Leiba2019-11-05
SQL Server Database Activity Based on Transaction Log Backup Size Jim Evans2019-08-01
SQL Server Forensics Analysis Based on Database Backup Size K. Brian Kelley2019-07-15
SQL Server Configuration Settings Query Alejandro Cobar2019-07-10
Windows Performance Monitor Tutorial Ben Snaidero2019-03-13
Start Windows Performance Monitor Ben Snaidero2019-03-13
Getting Started with Windows Performance Monitor Ben Snaidero2019-03-13
Real-Time Data Collection with Windows Performance Monitor Ben Snaidero2019-03-13
Analyze Windows Performance Monitor Counters Using PerfMon Ben Snaidero2019-03-13
Perfmon Counters for CPU Usage, Memory, Disk and Network Performance Ben Snaidero2019-03-13
Performance Monitor Counters for SQL Server Ben Snaidero2019-03-13
Create Windows Performance Monitor Data Collector Set Ben Snaidero2019-03-13
Schedule Data Collection with Windows Performance Monitor Ben Snaidero2019-03-13
Analyze Windows Performance Monitor Counters Using Excel Ben Snaidero2019-03-13
Windows Performance Monitor Counters List Ben Snaidero2019-03-13
Create Windows Performance Monitor Counter Alert from Data Collector Ben Snaidero2019-03-13
Windows Performance Monitor Log File Configuration Settings Ben Snaidero2019-03-13
Windows Performance Monitor Template Ben Snaidero2019-03-13
SQL Server Disk Space Monitoring for All Instances with PowerShell Alejandro Cobar2019-03-01
SQL Server T-SQL Alerts for Standard and Custom Errors Tim Smith2019-02-08
Monitor CPU and Memory for All SQL Server Instances with PowerShell Alejandro Cobar2019-01-07
Script to Get Error Numbers and Messages from SQL Server Error Log Eduardo Pivaral2018-08-10
Simple Free Disk Space HTML report for SQL Server Diogo Souza2018-08-08
Automate SQL WMI Alerts for Server and Objects Permissions Changes Svetlana Golovko2018-07-24
Comprehensive SQL Server Monitoring Report via Email Pablo Echeverria2018-07-09
Receive SQL Server Alerts through Slack Maria Zakourdaev2018-06-14
Automate a SQL Server Status Report on Server Restart or Scheduled Graham Okely2018-05-15
Function to quickly find the worst performing SQL Server Stored Procedures Eli Leiba2018-04-19
Find all stopped SQL Server services for all instances Pablo Echeverria2018-03-21
SQL Server Performance Troubleshooting Database Health Checklist Ben Snaidero2018-03-16
Improve SQL Server Logging to Reduce Space and Troubleshooting Time Tim Smith2018-03-07
SQL Server Performance Troubleshooting System Health Checklist Ben Snaidero2018-02-26
Automated Notification Email for SQL Server Object Modifications Daniel Calbimonte2018-02-06
SSIS Package to Centrally Monitor SQL Server Backups Atul Gaikwad2017-10-19
SSIS Package to Centrally Monitor All SQL Servers Atul Gaikwad2017-10-13
Create SQL Server Disk Space Report for All Servers Daniel Farina2017-09-13
Standardized table based SQL Server monitoring email with PowerShell Pablo Echeverria2017-07-28
Virtual Log File Monitoring in SQL Server 2017 Aaron Bertrand2017-07-25
Monitor a Windows Service Interacting with SQL Server Tim Smith2017-05-23
Simple free drive space alert for SQL Server databases Eli Leiba2017-01-19
Customized SSRS report to monitor server and database status Scott Murray2016-06-15
Automatically Send Performance Dashboard Reports during a database event using Reporting Services Daniel Farina2016-03-15
Automate Alerting for SQL Server Suspect Database Pages Ben Snaidero2016-01-25
Low Disk Space Alert for SQL Server Svetlana Golovko2015-09-09
SQL Server Monitoring and Reporting with PowerShell – Part 3 Fikrat Azizov2015-06-03
SQL Server Monitoring with Powershell and the SQL Server Platform: Data Processing (Part 2 of 3) Fikrat Azizov2015-05-21
Monitor Remote SQL Server Instance Availability Mike Eastland2015-05-19
SQL Server Monitoring with Powershell and the SQL Server Platform: Data Collection (Part 1 of 3) Fikrat Azizov2015-05-14
Monitor SQL Server Transaction Log File Free Space Mike Eastland2015-05-12
Monitor SQL Server Master Database Changes with WMI Alerts Svetlana Golovko2015-05-06
Monitor Storage Constraints for SQL Server Data Files Mike Eastland2015-03-19
Using sp_server_diagnostics to Monitor SQL Server Ben Snaidero2014-04-03
Automated collection of SQL Server database connections for monitoring Svetlana Golovko2014-03-28
Collect Database and Table Index Grow Statistics for all SQL Servers Using PowerShell Bernard Black2014-03-26
Using Powershell to Monitor the SQL Server system_health Extended Event Session Ben Snaidero2014-03-11
Identify Completion Time for Long Running SQL Server Processes using Dynamic Management Objects Tim Ford2014-03-03
Collect SQL Server Performance Counters and Build Reports with SSRS Brady Upton2014-02-11
Search multiple SQL Server Error Logs at the same time Mike Eastland2014-01-10
Monitor SQL Server Database File Growth with WMI Alerts Svetlana Golovko2013-12-11
Monitor SQL Server Databases Changes Using WMI Alerts Svetlana Golovko2013-11-15
Real Time Auditing Failed SQL Server Logins with Performance Monitor Daniel Farina2013-08-26
Monitoring SQL Server Disk Space Mike Eastland2013-04-19
Report to Capture Table Growth Statistics for SQL Server Brady Upton2012-11-13
Different techniques to identify blocking in SQL Server Basit Farooq2012-07-27
Use PowerShell to gather SQL Server database physical file sizes Dale Kelly2012-05-23
Capture SQL Server Diagnostic and Health Information stored procedure Ashish Kumar Mehta2012-03-30
Automate SQL Server Monitoring with Email Alerts Ben Snaidero2011-12-08
SQL Server Monitoring Checklist Ben Snaidero2011-10-19
What does my SQL Server data look like over the wire? Shawn Melton2011-07-13
Storing Windows Performance Counter Values in SQL Server Ray Barley2011-05-26
Automate Monitoring SQL Server Error Logs with Email Alerts Bru Medishetty2011-02-21
Introduction to Utility Control Points in SQL Server 2008 R2 Ray Barley2010-09-15
Monitor, Start and Stop SQL Server services using xp_servicecontrol Jugal Shah2010-06-11
How to Automatically Monitor Windows Event Log from SQL Server Sadequl Hussain2010-01-15
Performance Analysis Using SQL Server 2008 Activity Monitor Tool Ashish Kumar Mehta2010-01-12
Methods to determine the status of a SQL Server database Greg Robidoux2008-04-15
Collect SQL Server database usage for free space and trending Tim Ford2008-02-04
sp_who for Sql 2005 (sp_who2k5) Chad Boyd2007-10-15
Problems running sp_helpdb in SQL Server Greg Robidoux2007-04-06
Getting operating system content into SQL Server Greg Robidoux2007-02-06
SQL Server Command Line Tools To Manage Your Server Greg Robidoux2006-07-28