dbatools is a free PowerShell module with over 300 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


Install-DbaFirstResponderKit

Downloads, extracts and installs the First Responder Kit stored procedures:
sp_Blitz, sp_BlitzWho, sp_BlitzFirst, sp_BlitzIndex, sp_BlitzCache and sp_BlitzTrace.

First Responder Kit links:
http://FirstResponderKit.org
https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit

Screenshots

dbatools - Install-DbaFirstResponderKit

Examples

Logs into server1 with Windows authentication and then installs the FRK in the master database.

Install-DbaFirstResponderKit -SqlInstance server1 -Database master

Logs into server1\instance1 with Windows authentication and then installs the FRK in the DBA database.

Install-DbaFirstResponderKit -SqlInstance server1\instance1 -Database DBA

Logs into server1\instance1 with SQL authentication and then installs the FRK in the master database.

Install-DbaFirstResponderKit -SqlInstance server1\instance1 -Database master -SqlCredential $cred

Logs into sql2016\standardrtm, sql2016\sqlexpress and sql2014 with Windows authentication and then installs the FRK in the master database.

Install-DbaFirstResponderKit -SqlInstance sql2016\standardrtm, sql2016\sqlexpress, sql2014

Logs into sql2016\standardrtm, sql2016\sqlexpress and sql2014 with Windows authentication and then installs the FRK in the master database.

$servers = “sql2016\standardrtm”, “sql2016\sqlexpress”, “sql2014”
$servers | Install-DbaFirstResponderKit

Author

This command was created by Tara Kizer. You can find Tara on her blog.

Get-Help

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

Source Code

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

Related commands