Display all running queries

Source:
http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3

Code:

Another query is available here: https://github.com/amachanic/sp_whoisactive/

More info: https://www.brentozar.com/archive/2019/07/sp_whoisactive-is-now-open-source/

Same query for Azure Database (Withtout master.dbo.sysprocesses)

Code:

Pin It on Pinterest

Shares
Share This