{"repo":"amachanic/sp_whoisactive","free":true,"listed":false,"github":"https://github.com/amachanic/sp_whoisactive","clone":"git clone https://github.com/amachanic/sp_whoisactive.git","description":"sp_whoisactive","language":"TSQL","stars":1393,"topics":["sql","sqlserver","monitoring"],"license":"GPL-3.0","category":"databases-storage","readme_excerpt":"sp WhoIsActive [![licence badge]][licence] [![stars badge]][stars] [![forks badge]][forks] [![issues badge]][issues] 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 now officially versioned and maintained here on GitHub. The license is now GPLv3. Documentation is still available at http://whoisactive.com/docs If you have enhancements, please consider a PR instead of a fork. I would like to continue to maintain this project for the community. Installation instructions Download the script sp WhoIsActive.sql from this root folder, open it in SQL Server Management Studio, and run it! [!TIP] The script will run in the database of the current connected session. If you want, you can change the database to master so the procedure will be available to run from every database in the instance. Previous version compatibility The script root folder is focused on supporting the latest SQL Server release features and compatibility. To use it with older versions, do the following: - For 2012 to 2019, use the sp WhoIsActive.sql from the 2019 folder - For 2008 or earlier, use the sp WhoIsActive.sql from the 2008 folder Going forward new folders will be created every two versions, so that the script can continue to grow and mature with SQL Server. Script version numbering Version numbering indicates the minimum and maximum supported versions, and the release date, in the f","default_branch":null,"files":null,"tree":[],"storefront":"/r/amachanic","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/amachanic/sp_whoisactive/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}