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 Find, Analyze and Optimize SQL Server Performance with SolarWinds Database Performance Analyzer 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 End to End Application Performance Management Dashboard with PerfStack Jeremy Kadlec
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 Intelligent SQL Server and VMware Performance Monitoring Software - Database Performance Analyzer Jeremy Kadlec
Tools Introduction to Utility Control Points in SQL Server 2008 R2 Ray Barley
Tools Monitor Remote SQL Server Instance Availability Mike Eastland
Tools Monitoring SQL Server 2012 - Capture and Parse sp_server_diagnostics output Ben Snaidero
Tools Optimize SQL Server estate monitoring with Redgate SQL Monitor Jeremy Kadlec
Tools Performance Analysis Using SQL Server 2008 Activity Monitor Tool Ashish Kumar Mehta
Tools Quickly Pinpoint SQL Server Performance Issues with SolarWinds Database Performance Analyzer Jeremy Kadlec
Tools Seamless Monitoring and Reporting for SQL Server Scott Murray
Tools SQL Server Command Line Tools To Manage Your Server Greg Robidoux
Tools SQL Server Monitoring On-premises and Cloud for Management and DBAs Eric Blinn
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
Tools Using SolarWinds Database Performance Analyzer to Diagnose Performance Issues Ben Snaidero
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 (31)
Analysis Services Analysis Services Development (94)
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 Tools (1)
Analysis Services Analysis Services Tutorials (6)
Analysis Services Cortana (5)
Analysis Services Performance Point (4)
Business Intelligence Big Data (25)
Business Intelligence Data Warehousing (6)
Cloud Amazon AWS (51)
Cloud Apache Spark (9)
Cloud Azure (146)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (14)
Cloud Azure Data Factory (69)
Cloud Azure Databricks (26)
Cloud Azure Integration Services (14)
Cloud Azure SQL Database (48)
Cloud Azure SQL Managed Instance (2)
Cloud Azure Synapse Analytics (39)
Cloud Cloud Strategy (20)
Data Quality Data Quality Services (9)
Data Quality Master Data Services (41)
Database Administration Amazon AWS RDS (1)
Database Administration Availability Groups (79)
Database Administration Backup (78)
Database Administration Central Management Servers (10)
Database Administration Clustering (74)
Database Administration Comparison Data and Objects (14)
Database Administration Compression (22)
Database Administration Contained Databases (4)
Database Administration Containers (12)
Database Administration Database Administration (197)
Database Administration Database Configurations (19)
Database Administration Database Console Commands DBCCs (25)
Database Administration Database Mail (18)
Database Administration Database Mirroring (33)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Deprecated Features (5)
Database Administration DevOps (36)
Database Administration Disaster Recovery (23)
Database Administration Error Logs (11)
Database Administration Express Edition (16)
Database Administration Extended Events (22)
Database Administration FILESTREAM (9)
Database Administration Fragmentation and Index Maintenance (27)
Database Administration Google Cloud (5)
Database Administration Hardware (14)
Database Administration High Availability (3)
Database Administration Indexing (87)
Database Administration Install and Uninstall (32)
Database Administration Licensing (4)
Database Administration Linked Servers (18)
Database Administration Locking and Blocking (40)
Database Administration Log Shipping (18)
Database Administration Maintenance (34)
Database Administration Monitoring (117)
Database Administration Other Database Platforms (85)
Database Administration Partitioning (17)
Database Administration Performance Data Warehouse (4)
Database Administration Performance Tuning (124)
Database Administration Policy Based Management (29)
Database Administration PowerShell (130)
Database Administration Profiler and Trace (20)
Database Administration Query Store (7)
Database Administration Recovery Models (4)
Database Administration Referential Integrity (4)
Database Administration Replication (75)
Database Administration Resource Governor (5)
Database Administration Restore (42)
Database Administration Snowflake (1)
Database Administration SQL Server 2016 (96)
Database Administration SQL Server 2017 (44)
Database Administration SQL Server 2019 (20)
Database Administration SQL Server 2022 (22)
Database Administration SQL Server Configurations (75)
Database Administration SQL Server on Linux (76)
Database Administration StreamInsight (2)
Database Administration System Databases (31)
Database Administration Upgrades and Migrations (54)
Database Administration Virtualization (25)
Database Administration Windows Internal Database (1)
Database Development Application Development (40)
Database Development Artificial Intelligence (1)
Database Development Azure Functions (7)
Database Development Change Data Capture (15)
Database Development Common Runtime Language (13)
Database Development Common Table Expressions (3)
Database Development Constraints (19)
Database Development Data Cleansing for Validation (2)
Database Development Data Science (3)
Database Development Data Types (18)
Database Development Database Design (77)
Database Development Dates (54)
Database Development Debugging (4)
Database Development Dynamic Management Views and Functions (33)
Database Development Dynamic SQL (7)
Database Development Entity Framework (13)
Database Development Error Handling (10)
Database Development Full Text Search (21)
Database Development Functions System (72)
Database Development Functions User Defined UDF (41)
Database Development Identities (17)
Database Development Import and Export (77)
Database Development In Memory OLTP (32)
Database Development JOIN Tables (21)
Database Development Language Integrated Query LINQ (7)
Database Development Microsoft Access Integration (8)
Database Development Microsoft Excel Integration (41)
Database Development Microsoft Flow (1)
Database Development Paging (5)
Database Development Python (72)
Database Development Query Optimization (14)
Database Development Query Plans (20)
Database Development R Language (11)
Database Development Scripts (35)
Database Development Service Broker (11)
Database Development Spatial Data Storage (9)
Database Development SQL Injection (5)
Database Development SQL Server Management Objects SMO (3)
Database Development Stored Procedures (29)
Database Development Synonyms (5)
Database Development Table Valued Parameters (4)
Database Development Temp Tables (10)
Database Development Temporal Tables (13)
Database Development Testing (31)
Database Development Transactions (9)
Database Development Triggers (44)
Database Development TSQL (365)
Database Development User Defined Type UDT (3)
Database Development Views (16)
Database Development XML (14)
Integration Services Data Transformation Services (5)
Integration Services Integration Services Administration (10)
Integration Services Integration Services Analysis Services Tasks (5)
Integration Services Integration Services Best Practices (12)
Integration Services Integration Services Configuration Options (22)
Integration Services Integration Services Connection Managers (5)
Integration Services Integration Services Control Flow Transformations (14)
Integration Services Integration Services Data Flow Transformations (19)
Integration Services Integration Services Development (110)
Integration Services Integration Services Email (3)
Integration Services Integration Services Error Handling (8)
Integration Services Integration Services Excel (14)
Integration Services Integration Services Execute Package Options (8)
Integration Services Integration Services Import and Export Wizard (2)
Integration Services Integration Services NULL Management (4)
Integration Services Integration Services Oracle (4)
Integration Services Integration Services Performance (12)
Integration Services Integration Services Security (7)
Integration Services Integration Services Upgrade (4)
Power Platform Power Apps (20)
Power Platform Power BI (147)
Power Platform Power BI Charts (51)
Power Platform Power BI Formatting (16)
Professional Development Professional Development Books (3)
Professional Development Professional Development Branding (14)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (16)
Professional Development Professional Development Career Transition (4)
Professional Development Professional Development Certifications (50)
Professional Development Professional Development Community (16)
Professional Development Professional Development Conferences (2)
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 (18)
Professional Development Professional Development Management (11)
Professional Development Professional Development Recruiters (6)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Reporting Services Reporting Services Administration (20)
Reporting Services Reporting Services Analysis Services (4)
Reporting Services Reporting Services Best Practices (6)
Reporting Services Reporting Services Charts (25)
Reporting Services Reporting Services Configuration (10)
Reporting Services Reporting Services Custom Report (2)
Reporting Services Reporting Services Dashboard (1)
Reporting Services Reporting Services Data Sources (10)
Reporting Services Reporting Services Development (38)
Reporting Services Reporting Services Drill Through (4)
Reporting Services Reporting Services Dynamic Reports (11)
Reporting Services Reporting Services Filtering (3)
Reporting Services Reporting Services Formatting (26)
Reporting Services Reporting Services Functions (5)
Reporting Services Reporting Services Images (2)
Reporting Services Reporting Services Installation (9)
Reporting Services Reporting Services KPI (5)
Reporting Services Reporting Services Maps (4)
Reporting Services Reporting Services Migration (5)
Reporting Services Reporting Services Monitoring (5)
Reporting Services Reporting Services Network Load Balancing (4)
Reporting Services Reporting Services Overview (5)
Reporting Services Reporting Services Parameters (15)
Reporting Services Reporting Services Performance (6)
Reporting Services Reporting Services Report Builder (9)
Reporting Services Reporting Services Report Models (1)
Reporting Services Reporting Services Security (8)
Reporting Services Reporting Services SharePoint (1)
Reporting Services Reporting Services Subreports (4)
Reporting Services Reporting Services Tutorials (1)
Security Auditing and Compliance (46)
Security Encryption (38)
Security Security (196)
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)
Tools Azure Data Studio (17)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (93)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (33)










get free sql tips
agree to terms