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
$300 Free Credits for Your Google Cloud Projects Icon
$300 Free Credits for Your Google Cloud Projects

Start building on Google Cloud with $300 in free credits. No commitment, no credit card required until you're ready to scale.

Launch your next project with $300 in free Google Cloud creditsโ€”no strings attached. Test, build, and deploy without risk. Use your credits across the entire Google Cloud platform to find what works best for your needs. After your credits are used, continue with always-free tier services. Only pay when you're ready to scale. Sign up in minutes and start exploring.
Start Free Trial
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