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
Try Google Cloud Risk-Free With $300 in Credit Icon
Try Google Cloud Risk-Free With $300 in Credit

No hidden charges. No surprise bills. Cancel anytime.

Use your credit across every product. Compute, storage, AI, analytics. When it runs out, 20+ products stay free. You only pay when you choose to.
Start 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