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


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.

Screenshots

Install-SqlWhoIsActive

Install-SqlWhoIsActive-2

Examples

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

 

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.

 

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.

 

Get-Help

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

Source Code

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

Related commands