TSQL first-responder-kit Projects
sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.Project mention: How to find applications using a database. | reddit.com/r/SQLServer | 2021-05-20
Brent's First Responder Kit has sp_BlitzWho which I imagine is similar but I haven't gotten into the habit of using it.
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2021-05-20.