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
Categories
Server MonitoringLicense
GNU General Public License version 3.0 (GPLv3)Follow sp_WhoIsActive
Other Useful Business Software
Enterprise-grade ITSM, for every business
Freshservice is an intuitive, AI-powered platform that helps IT, operations, and business teams deliver exceptional service without the usual complexity. Automate repetitive tasks, resolve issues faster, and provide seamless support across the organization. From managing incidents and assets to driving smarter decisions, Freshservice makes it easy to stay efficient and scale with confidence.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of sp_WhoIsActive!