sp_WhoIsActive is a comprehensive activity monitoring stored procedure that works for all versions of SQL Server from 2005 through 2022 and Azure SQL DB. sp_whoisactive is a SQL Server stored procedure for monitoring active queries and troubleshooting database performance issues.

Features

  • Provides detailed insights into active SQL queries
  • Tracks resource usage (CPU, IO, memory) per query
  • Easy integration into SQL Server workflows
  • Identifies blocking and long-running queries
  • Real-time monitoring for database health
  • Customizable output for specific needs

Project Samples

sp_WhoIsActive Screenshot 1

Project Activity

See All Activity >

Categories

Server Monitoring

License

GNU General Public License version 3.0 (GPLv3)

Follow sp_WhoIsActive

sp_WhoIsActive Web Site

Other Useful Business Software
99.99% Uptime for MySQL and PostgreSQL Databases Icon
99.99% Uptime for MySQL and PostgreSQL Databases

Sub-second maintenance. 2x read/write performance. Built-in vector search for AI apps.

Cloud SQL Enterprise Plus delivers near-zero downtime with 35 days of point-in-time recovery. Supports MySQL, PostgreSQL, and SQL Server.
Try Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of sp_WhoIsActive!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Registered

2024-11-20
Report inappropriate content