dbatools is a free PowerShell module with over 200 SQL Server administration, best practice and migration commands included.

Please note that documentation and command names may be out of date while we work furiously towards 1.0

This command has been renamed to Install-DbaWhoIsActive in 0.8.950.

Automatically installs or updates sp_WhoIsActive by Adam Machanic by downloading, extracting and installing sp_whoisactive.

Please consider donating to Adam if you find his stored procedure helpful.

TODO: Allow -Path to be specified for networks without Internet access.





To install sp_WhoIsActive to sqlserver2014a’s master database using Windows Authentication to login.

Install-SqlWhoIsActive -SqlServer sqlserver2014a -Database master

If no database is specified, you will be presented with a dialog box asking which database on sqlserver2014a you want to install the procedure within. If you’d like to use SQL authentication instead of Windows authentication, use the SqlCredential parameter.

$cred = Get-Credential
Install-SqlWhoIsActive -SqlServer sqlserver2014a -SqlCredential $cred

This command doesn’t support passing both servers and default database, but you can accomplish the same thing by passing an array and specifying a database.

$servers = Get-SqlRegisteredServerName sqlserver
Install-SqlWhoIsActive -SqlServer $servers -Database master


From PowerShell, execute Get-Help Install-SqlWhoIsActive -Detailed for more information on this function.

Source Code

Want to see the source code? View Install-SqlWhoIsActive.ps1 on GitHub

Related commands