Tutorials
DBA
Dev
BI
Career
Categories
Webcasts
Scripts
Today's Tip
Join
Tutorials
DBA
Dev
BI
Categories
Webcasts
DBA
Dev
BI
Categories
SQL Server Monitoring Tips
Browse Categories
Amazon AWS
Auditing and Compliance
Availability Groups
Backup
Big Data
Central Management Server
Clustering
Comparison
Compression
Contained Databases
Containers
DAC
Data Quality Services
Database Administration
Database Configurations
Database Mail
Database Mirroring
DBA Best Practices
DBCCs
Deprecated Features
Disaster Recovery
Error Logs
Express Edition
Extended Events
FILESTREAM
Hardware
High Availability
Index Fragmentation
Indexing
Install and Uninstall
Licensing
Linked Servers
Linux
Locking and Blocking
Log Shipping
Maintenance
Master Data Services
Monitoring
Other Database Platforms
Partitioning
Perf Data Warehouse
Performance Tuning
Policy Based Management
PowerShell
Profiler and Trace
Query Store
Recovery Models
Replication
Resource Governor
Restore
Security
SQL Azure
SQL Management Studio
SQL Server 2016
SQL Server 2017
SQL Server 2019
SQL Server Agent
SQL Server Configurations
SSOS
StreamInsight
Surface Area Config
System Databases
Tools
Upgrades and Migrations
Virtualization
Windows Internal Database
Administration
Build and Automate a SQL Server Status Report on Server Restart or Scheduled
Backups
SSIS Package to Centrally Monitor SQL Server Backups
Configuration
SQL Server Configuration Settings Query
Connections
Automated collection of SQL Server database connections for monitoring
Corruption
Automate Alerting for SQL Server Suspect Database Pages
Deadlocks
Capturing SQL Server Deadlocks using Extended Events
Email
Comprehensive SQL Server Monitoring Report via Email
Error Logs
Automate Monitoring SQL Server Error Logs with Email Alerts
Reading the SQL Server log files 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
Use PowerShell to gather SQL Server database physical file sizes
Growth
Collect Database and Table Index Grow Statistics for all SQL Servers Using PowerShell
Logging
Improve SQL Server Logging to Reduce Space and Troubleshooting Time
Memory
Monitor CPU and Memory usage for all SQL Server instances using 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
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
SQL Server Monitoring Checklist
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
Standardized table based SQL Server monitoring email with PowerShell
Processes
Different techniques to identify blocking in SQL Server
How to isolate the current running commands 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
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
Methods to determine the status of a SQL Server database
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
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 and Tuning SQL Server with SQL Diagnostic Manager
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
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
Windows
Getting operating system content into SQL Server
How to Automatically Monitor Windows Event Log from SQL Server
Storing Windows Performance Counter Values in SQL Server
More SQL Server Solutions
