WhoIsActive

Install-DbaCommunitySoftware

the dbatools team + Claude

Install-DbaCommunitySoftware View Source the dbatools team + Claude Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Installs community-maintained SQL Server tooling through a single command Description Installs one or more of the community stored procedure kits that dbatools ships installers for, without needing to remember six separate command names. This is the install-side counterpart to Save-DbaCommunitySoftware, which already unifies the download step behind one -Software parameter.

Install-DbaWhoIsActive

Chrissy LeMaire (@cl), netnerds.net

Install-DbaWhoIsActive View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

Invoke-DbaWhoIsActive

Chrissy LeMaire (@cl), netnerds.net

Invoke-DbaWhoIsActive View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.