SQL Server Monitoring Tips

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

SubCategory Tip Title Author
Administration Build and Automate a SQL Server Status Report on Server Restart or Scheduled Graham Okely
Backups SSIS Package to Centrally Monitor SQL Server Backups Atul Gaikwad
Configuration SQL Server Configuration Settings Query Alejandro Cobar
Connections Automated collection of SQL Server database connections for monitoring Svetlana Golovko
Corruption Automate Alerting for SQL Server Suspect Database Pages Ben Snaidero
CPU SQL Server Function to Measure CPU Usage Per Database Eli Leiba
CPU SQL Server High CPU Query Use Monitoring with PowerShell Alejandro Cobar
Dashboard Custom SSMS SQL Server Instance Level Metrics Report Eduardo Pivaral
Dashboard SSMS Custom Report for SQL Server Database Metrics Eduardo Pivaral
Deadlocks Capturing SQL Server Deadlocks using Extended Events Eduardo Pivaral
DROP TABLE Who Dropped the SQL Table Joe Gavin
Email Comprehensive SQL Server Monitoring Report via Email Pablo Echeverria
Error Logs Automate Monitoring SQL Server Error Logs with Email Alerts Bru Medishetty
Error Logs How to Read Log File in SQL Server using TSQL Greg Robidoux
Error Logs Script to Retrieve All Error Numbers and Messages from the SQL Server Error Log Eduardo Pivaral
Error Logs Search multiple SQL Server Error Logs at the same time Mike Eastland
Free Space Collect SQL Server database usage for free space and trending Tim Ford
Free Space Determining space used for all tables in a SQL Server database Greg Robidoux
Free Space How To Check Disk Space in SQL Server Alejandro Cobar
Free Space Monitor SQL Server Transaction Log File Free Space Mike Eastland
Free Space Monitoring SQL Server Disk Space Mike Eastland
Free Space Report to Capture Table Growth Statistics for SQL Server Brady Upton
Free Space Script to determine free space to support shrinking SQL Server database files Ken Simmons
Free Space Simple free drive space alert for SQL Server databases Eli Leiba
Free Space SQL Server Disk Space Monitoring for all Instances with PowerShell Script Alejandro Cobar
Free Space SQL Server Table Size Report Eli Leiba
Free Space Use PowerShell to gather SQL Server database physical file sizes Dale Kelly
Growth Collect Database and Table Index Grow Statistics for all SQL Servers Using PowerShell Bernard Black
Growth Monitor SQL Server Table Size with PowerShell Alejandro Cobar
Indexing Monitor all Indexes in SQL Server with PowerShell Alejandro Cobar
Logging Improve SQL Server Logging to Reduce Space and Troubleshooting Time Tim Smith
Logins Monitoring SQL Server logins and server roles with PowerShell for Database Security Alejandro Cobar
Memory Monitor CPU and Memory usage for all SQL Server instances using PowerShell Alejandro Cobar
Memory Monitoring SQL Server Buffer Pool Usage by Database with PowerShell Alejandro Cobar
Memory SQL Server Memory Usage Query Eli Leiba
Network SQL Server Network Related Performance Monitor Counters Joe Gavin
Notifications Automate SQL Server Monitoring with Email Alerts Ben Snaidero
Notifications Automated Notification Email for SQL Server Object Modifications Daniel Calbimonte
Notifications Automated SQL Server WMI Alerts for Server Scope and Server Objects Permissions Changes Svetlana Golovko
Notifications How to setup SQL Server alerts and email operator notifications David Bird
Notifications Monitor SQL Server Database File Growth with WMI Alerts Svetlana Golovko
Notifications Monitor SQL Server Databases Changes Using WMI Alerts Svetlana Golovko
Notifications Monitor SQL Server Master Database Changes with WMI Alerts Svetlana Golovko
Notifications Posting SQL Server Notifications to Slack Ian Fogelman
Notifications Receive SQL Server Alerts through Slack Maria Zakourdaev
Notifications SQL Server T-SQL Alerts for Standard and Custom Errors Tim Smith
Notifications Using Powershell to Monitor the SQL Server system_health Extended Event Session Ben Snaidero
Overview SQL Server Monitoring Checklist Ben Snaidero
Perfmon Introduction to Windows Performance Monitor for SQL Server Joe Gavin
Perfmon SQL Server Disk Related Performance Monitor Counters Joe Gavin
Perfmon Windows Performance Monitor Counters for SQL Server Joe Gavin
Performance Collect SQL Server Performance Counters and Build Reports with SSRS Brady Upton
Performance Enterprise SQL Server Performance Tuning and Management with dbWatch Jeremy Kadlec
Performance Function to quickly find the worst performing SQL Server Stored Procedures Eli Leiba
Performance Identify Completion Time for Long Running SQL Server Processes using Dynamic Management Objects Tim Ford
Performance Monitor Performance Counters using PowerShell in SQL Server Agent Job Step Pablo Echeverria
Performance SQL Server Performance Troubleshooting Database Health Checklist Ben Snaidero
Performance SQL Server Performance Troubleshooting System Health Checklist Ben Snaidero
PowerShell How to Check SysAdmin Role in SQL Server with PowerShell Alejandro Cobar
PowerShell Quickly Evaluate SQL Server Best Practices with Invoke-SqlAssessment Jeffrey Yao
PowerShell SQL Server Agent Job Monitoring with PowerShell Alejandro Cobar
PowerShell SQL Server Backup Monitoring with PowerShell Alejandro Cobar
PowerShell SQL Server Database and Database File Monitoring with PowerShell Alejandro Cobar
PowerShell Standardized table based SQL Server monitoring email with PowerShell Pablo Echeverria
Processes Different techniques to identify blocking in SQL Server Basit Farooq
Processes Find Current Running SQL Statement in SQL Server Tim Ford
Processes Killing a SPID and Checking Rollback progress in SQL Server Armando Prato
Processes sp_who for Sql 2005 (sp_who2k5) Chad Boyd
Processes sp_whoisactive SQL Server Monitoring Alejandro Cobar
Reporting Automatically Send Performance Dashboard Reports during a database event using Reporting Services Daniel Farina
Reporting Customized SSRS report to monitor server and database status Scott Murray
Scripts Monitoring SQL Server with PowerShell Core Object Setup Alejandro Cobar
Scripts Monitoring SQL Server with PowerShell Instance Data Collection Alejandro Cobar
Scripts SP_WhoIsActive Data Collection and Analysis Jeffrey Yao
Scripts SQL Server vs Oracle: Active Session Queries Pablo Echeverria
Security Real time auditing of failed SQL Server logins with user settable performance counters in Performance Monitor Daniel Farina
Security What does my SQL Server data look like over the wire? Shawn Melton
Server Methods to determine the status of a SQL Server database Greg Robidoux
Services Find all stopped SQL Server services for all instances Pablo Echeverria
Services Monitor a Windows Service Interacting with SQL Server Tim Smith
Services Monitor, Start and Stop SQL Server services using xp_servicecontrol Jugal Shah
SQL Server Agent SQL Server Agent Job Monitoring for Last Execution with PowerShell Alejandro Cobar
Statistics SQL Server Statistics Collection and Analysis Alejandro Cobar
Storage Create SQL Server Disk Space Report for All Servers Daniel Farina
Storage Low Disk Space Alert for SQL Server Svetlana Golovko
Storage Monitor Storage Constraints for SQL Server Data Files Mike Eastland
Storage Simple Free Disk Space HTML report for SQL Server Diogo Souza
Tools Capture Diagnostic Data and Health Information in SQL Server 2012 using sp_server_diagnostics System Stored Procedure Ashish Kumar Mehta
Tools Fast and Efficient Way to Monitor and Solve SQL Server Performance Issues Rajendra Gupta
Tools Install SQL Server 2012 Performance Dashboard Reports Ashish Kumar Mehta
Tools Introduction to Utility Control Points in SQL Server 2008 R2 Ray Barley
Tools Monitor Remote SQL Server Instance Availability Mike Eastland
Tools Monitor SQL Server Performance and Daily Operations with dbWatch Jared Westover
Tools Monitoring SQL Server 2012 - Capture and Parse sp_server_diagnostics output Ben Snaidero
Tools Performance Analysis Using SQL Server 2008 Activity Monitor Tool Ashish Kumar Mehta
Tools SQL Server Command Line Tools To Manage Your Server Greg Robidoux
Tools SQL Server Monitoring with PowerShell and the SQL Server Platform: Analysis and Reporting (Part 3 of 3) Fikrat Azizov
Tools SQL Server Monitoring with Powershell and the SQL Server Platform: Data Collection (Part 1 of 3) Fikrat Azizov
Tools SQL Server Monitoring with Powershell and the SQL Server Platform: Data Processing (Part 2 of 3) Fikrat Azizov
Tools SSIS Package to Centrally Monitor All SQL Servers Atul Gaikwad
Transaction Logs Monitoring SQL Server database transaction log space Greg Robidoux
Transaction Logs SQL Server Database Activity Based on Transaction Log Backup Size Jim Evans
Transaction Logs Virtual Log File Monitoring in SQL Server 2017 Aaron Bertrand
Troubleshooting Problems running sp_helpdb in SQL Server Greg Robidoux
Troubleshooting SQL Server Forensics Analysis Based on Database Backup Size K. Brian Kelley
Versions Monitoring SQL Server Instance Version and Builds with PowerShell Alejandro Cobar
Wait Types SQL Server Wait Stats Monitoring with PowerShell Alejandro Cobar
Windows Getting operating system content into SQL Server Greg Robidoux
Windows How to Automatically Monitor Windows Event Log from SQL Server Sadequl Hussain
Windows Storing Windows Performance Counter Values in SQL Server Ray Barley
Tutorial Topic Author
Windows Performance Monitor Tutorial Windows Performance Monitor Tutorial Ben Snaidero
Windows Performance Monitor Tutorial Start Windows Performance Monitor Ben Snaidero
Windows Performance Monitor Tutorial Getting Started with Windows Performance Monitor Ben Snaidero
Windows Performance Monitor Tutorial Create Windows Performance Monitor Data Collector Set Ben Snaidero
Windows Performance Monitor Tutorial Create Windows Performance Monitor Counter Alert from Data Collector Ben Snaidero
Windows Performance Monitor Tutorial Windows Performance Monitor Log File Configuration Settings Ben Snaidero
Windows Performance Monitor Tutorial Windows Performance Monitor Template Ben Snaidero
Windows Performance Monitor Tutorial Real-Time Data Collection with Windows Performance Monitor Ben Snaidero
Windows Performance Monitor Tutorial Schedule Data Collection with Windows Performance Monitor Ben Snaidero
Windows Performance Monitor Tutorial Analyze Windows Performance Monitor Counters Using PerfMon Ben Snaidero
Windows Performance Monitor Tutorial Analyze Windows Performance Monitor Counters Using Excel Ben Snaidero
Windows Performance Monitor Tutorial Windows Performance Monitor Counters List Ben Snaidero
Windows Performance Monitor Tutorial Perfmon Counters for CPU Usage, Memory, Disk and Network Performance Ben Snaidero
Windows Performance Monitor Tutorial Windows Performance Monitor Counters for SQL Server Ben Snaidero
Windows Performance Monitor Tutorial Get Free SQL Tips - Windows Performance Monitor Tutorial Ben Snaidero
CategoryGroup Category (articles)
Analysis Services Analysis Services Administration (33)
Analysis Services Analysis Services Development (95)
Analysis Services Analysis Services Dimensions (16)
Analysis Services Analysis Services Measure Groups (7)
Analysis Services Analysis Services Performance (14)
Analysis Services Analysis Services Security (7)
Analysis Services Analysis Services Tutorials (6)
Business Intelligence Artificial Intelligence (22)
Business Intelligence Big Data (25)
Business Intelligence Data Science (3)
Business Intelligence Data Warehousing (7)
Business Intelligence Import and Export (81)
Business Intelligence R Language (11)
Business Intelligence Snowflake (29)
Cloud Amazon AWS (38)
Cloud Amazon AWS RDS (21)
Cloud Azure (149)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (15)
Cloud Azure Functions (7)
Cloud Azure SQL Database (51)
Cloud Azure SQL Managed Instance (5)
Cloud Cloud Strategy (24)
Cloud Google Cloud (10)
Cloud Analytics Apache Spark (13)
Cloud Analytics Azure Data Factory (73)
Cloud Analytics Azure Databricks (39)
Cloud Analytics Azure Integration Services (14)
Cloud Analytics Azure Synapse Analytics (41)
Cloud Analytics Microsoft Fabric (17)
Data Quality Data Cleansing for Validation (4)
Data Quality Data Quality Services (10)
Data Quality Master Data Services (41)
Database Administration Central Management Servers (10)
Database Administration Comparison Data and Objects (14)
Database Administration Database Administration (208)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Scripts (35)
Database Administration System Databases (31)
Database Configuration Compression (22)
Database Configuration Database Configurations (19)
Database Configuration Database Mail (18)
Database Configuration FILESTREAM (9)
Database Configuration Full Text Search (21)
Database Configuration In Memory OLTP (32)
Database Configuration Linked Servers (18)
Database Configuration Policy Based Management (29)
Database Configuration Recovery Models (4)
Database Configuration Resource Governor (5)
Database Configuration SQL Server Configurations (75)
Database Design Constraints (20)
Database Design Data Types (22)
Database Design Database Design (92)
Database Design Identities (17)
Database Design JOIN Tables (23)
Database Design Synonyms (5)
Database Design Table Valued Parameters (4)
Database Design Temp Tables (15)
Database Design Temporal Tables (13)
Database Design User Defined Type UDT (3)
Database Design Views (17)
Database Development Application Development (46)
Database Development Common Runtime Language (13)
Database Development Debugging (4)
Database Development DevOps (36)
Database Development Entity Framework (13)
Database Development Language Integrated Query LINQ (7)
Database Development Paging (5)
Database Development Referential Integrity (5)
Database Development Service Broker (11)
Database Development Testing (32)
Database Development XML (14)
Database Maintenance Database Console Commands DBCCs (25)
Database Maintenance Fragmentation and Index Maintenance (28)
Database Maintenance Maintenance (34)
Disaster Recovery / High Availability Availability Groups (79)
Disaster Recovery / High Availability Backup (81)
Disaster Recovery / High Availability Clustering (77)
Disaster Recovery / High Availability Database Mirroring (33)
Disaster Recovery / High Availability Disaster Recovery (23)
Disaster Recovery / High Availability High Availability (3)
Disaster Recovery / High Availability Log Shipping (18)
Disaster Recovery / High Availability Replication (77)
Disaster Recovery / High Availability Restore (42)
Functions Dates (56)
Functions Functions System (99)
Functions Functions User Defined UDF (41)
Infrastructure Contained Databases (4)
Infrastructure Containers (12)
Infrastructure Hardware (14)
Infrastructure Spatial Data Storage (9)
Infrastructure Virtualization (25)
Integration Services Admin Integration Services Administration (10)
Integration Services Admin Integration Services Best Practices (12)
Integration Services Admin Integration Services Configuration Options (22)
Integration Services Admin Integration Services Performance (12)
Integration Services Admin Integration Services Security (7)
Integration Services Admin Integration Services Upgrade (4)
Integration Services Development Data Transformation Services (6)
Integration Services Development Integration Services Analysis Services Tasks (5)
Integration Services Development Integration Services Connection Managers (5)
Integration Services Development Integration Services Control Flow Transformations (14)
Integration Services Development Integration Services Data Flow Transformations (19)
Integration Services Development Integration Services Development (116)
Integration Services Development Integration Services Error Handling (8)
Integration Services Development Integration Services Excel (14)
Integration Services Development Integration Services Execute Package Options (8)
Integration Services Development Integration Services Oracle (4)
Microsoft Office Microsoft Access Integration (8)
Microsoft Office Microsoft Excel Integration (44)
Microsoft Office Microsoft Flow (1)
Other RDBMS Other Database Platforms (16)
Other RDBMS PostgreSQL (11)
Other RDBMS SQL Server and Oracle Comparison (29)
Other RDBMS SQL Server on Linux (78)
Other RDBMS SQL Server vs Oracle vs PostgreSQL Comparison (20)
Performance Dynamic Management Views and Functions (34)
Performance Error Logs (11)
Performance Extended Events (22)
Performance Indexing (94)
Performance Locking and Blocking (43)
Performance Monitoring (110)
Performance Partitioning (17)
Performance Performance Data Warehouse (4)
Performance Performance Tuning (124)
Performance Profiler and Trace (20)
Performance Query Optimization (15)
Performance Query Plans (20)
Performance Query Store (7)
Power Platform Power Apps (20)
Power Platform Power BI (170)
Power Platform Power BI Charts (57)
Power Platform Power BI Formatting (17)
Professional Development Professional Development Branding (16)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (20)
Professional Development Professional Development Certifications (62)
Professional Development Professional Development Community (16)
Professional Development Professional Development Interview Questions BI (18)
Professional Development Professional Development Interview Questions DBA (23)
Professional Development Professional Development Interview Questions Developer (9)
Professional Development Professional Development Interviewing (39)
Professional Development Professional Development Job Search (24)
Professional Development Professional Development Management (14)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Python Python (88)
Reporting Services Admin Reporting Services Administration (21)
Reporting Services Admin Reporting Services Best Practices (6)
Reporting Services Admin Reporting Services Configuration (10)
Reporting Services Admin Reporting Services Installation (10)
Reporting Services Admin Reporting Services Migration (5)
Reporting Services Admin Reporting Services Monitoring (5)
Reporting Services Admin Reporting Services Network Load Balancing (4)
Reporting Services Admin Reporting Services Performance (6)
Reporting Services Admin Reporting Services Security (8)
Reporting Services Development Reporting Services Analysis Services (4)
Reporting Services Development Reporting Services Charts (25)
Reporting Services Development Reporting Services Data Sources (10)
Reporting Services Development Reporting Services Development (67)
Reporting Services Development Reporting Services Dynamic Reports (11)
Reporting Services Development Reporting Services Formatting (26)
Reporting Services Development Reporting Services KPI (5)
Reporting Services Development Reporting Services Overview (5)
Reporting Services Development Reporting Services Parameters (15)
Reporting Services Development Reporting Services Report Builder (9)
Security Auditing and Compliance (47)
Security Encryption (35)
Security Security (199)
Security SQL Injection (5)
Security Surface Area Configuration Manager (4)
SharePoint SharePoint (131)
SharePoint SharePoint Administration (46)
SharePoint SharePoint Configuration (27)
SharePoint Sharepoint Design (46)
SharePoint SharePoint Document Management (20)
SQL Coding Change Data Capture (16)
SQL Coding Common Table Expressions (4)
SQL Coding Dynamic SQL (7)
SQL Coding Error Handling (11)
SQL Coding Stored Procedures (30)
SQL Coding Transactions (9)
SQL Coding Triggers (44)
SQL Coding TSQL (340)
Tools Azure Data Studio (18)
Tools PowerShell (131)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (94)
Tools SQL Server Management Objects SMO (3)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (35)
Versions Deprecated Features (6)
Versions Express Edition (16)
Versions Install and Uninstall (33)
Versions Licensing (4)
Versions SQL Server 2016 (96)
Versions SQL Server 2017 (44)
Versions SQL Server 2019 (20)
Versions SQL Server 2022 (21)
Versions Upgrades and Migrations (55)










get free sql tips
agree to terms