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

Project Activity

See All Activity >

License

GNU General Public License version 3.0 (GPLv3)

Follow sp_WhoIsActive

sp_WhoIsActive Web Site

Other Useful Business Software
LinkSquares: All-in-One Contract Management Platform Icon
LinkSquares: All-in-One Contract Management Platform

#1 Customer Rated CLM Any Contract. Every Department. One Platform.

LinkSquares is the leading Contract Lifecycle Management (CLM) software designed to help legal, procurement, and business operations teams master the entire contract lifecycle, from creation to execution and renewal. The platform transforms how companies manage agreements by centralizing data, automating routine work, and providing actionable insights powered by AI. This single, connected source of truth helps teams eliminate manual processes, streamline workflows, boost visibility, and ensure compliance across thousands of contracts, ultimately reducing risk and administrative burden.
Learn More
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