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
Our Free Plans just got better! | Auth0 Icon
Our Free Plans just got better! | Auth0

With up to 25k MAUs and unlimited Okta connections, our Free Plan lets you focus on what you do bestโ€”building great apps.

You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
Try free now
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