WhoIsActive

Install-DbaWhoIsActive

Chrissy LeMaire (@cl), netnerds.net

Install-DbaWhoIsActive View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Downloads and installs sp_WhoIsActive stored procedure for real-time SQL Server session monitoring Description Installs Adam Machanic’s sp_WhoIsActive stored procedure, the most widely-used tool for monitoring active SQL Server sessions in real-time. This procedure provides detailed information about currently running queries, blocking chains, wait statistics, and resource consumption without the overhead of SQL Server Profiler. The function automatically downloads the latest version from GitHub or uses a local file you specify.

Invoke-DbaWhoIsActive

Chrissy LeMaire (@cl), netnerds.net

Invoke-DbaWhoIsActive View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves real-time information about active SQL Server sessions and currently running queries Description Executes Adam Machanic’s sp_WhoIsActive stored procedure to display detailed information about currently running sessions, active queries, and their resource consumption. This is the go-to command for troubleshooting performance issues, identifying blocking chains, and monitoring SQL Server activity in real-time. Provides comprehensive session details including wait statistics, query plans, lock information, and transaction details that would otherwise require querying multiple DMVs manually.