amachanic/sp_whoisactive
sp_whoisactive observed · 2026-08-28
Health v2 · maintenance only
73/100
- Activity 82
- Release rhythm 46
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 2593
- days_rel: 146
- days_push: 109
- n_releases_24m: 1
Adoption not part of the score
1396 stars · 340 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
sp_WhoIsActive is a comprehensive activity monitoring stored procedure for SQL Server 2005 through 2022 and Azure SQL DB. It is distributed as a T-SQL script that you install into a database to inspect currently running sessions and queries.
Use cases
- see what queries are currently running on my sql server
- find long-running or blocking sessions in sql server
- troubleshoot slow queries and blocking chains
- monitor active sessions on azure sql database
- replace sp_who2 with a richer activity view
- identify which stored procedure is causing blocking
When to choose
- you administer or develop against SQL Server or Azure SQL DB and need real-time session and query activity insight
- you want a free, community-maintained alternative to sp_who2 with richer detail
When to avoid
- you use a database engine other than SQL Server
- you need historical or long-term metrics collection rather than point-in-time activity snapshots
Facets
library · maturity active
monitoring database developer-tools databases monitoring developer-tools windows cli sql-server tsql stored-procedure activity-monitoring dba-tools
1 source
- readme: https://github.com/amachanic/sp_whoisactive · fetched 2026-08-28 · b62cd7f2d813
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| amachanic/sp_whoisactive | main | 73 |
For agents
markdown · JSON · MCP: product_card(name="amachanic/sp_whoisactive")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem