Deploy SQL-Server-First-Responder-Kit with Powershell

Spread the love

There are many tools in market that can help you troubleshoot in specific situations. My personal favorite for finding out issue with SQL Server is SQL-Server-First-Responder-Kit created by Brent Ozar Unlimited team.

Now, the problem is if you have hundreds of server to support, copying, pasting, and compiling the procedures provided by SQL-Server-First-Responder-Kit is a tedious task. So, now the kit includes a sql script named ‘Install-All-Procs.sql’ for compiling all procs all together. But, for me, I never intended to use all of the procedures rather only specific ones like sp_Blitz, sp_BlitzFirst, sp_BlitzCache, sp_BlitzIndex, and Adam Mechanic’s sp_whoIsActive. In order to achieve this, I have created a PowerShell module that will help us to compile all the required procedures scripts against any server as per our need just by calling Apply-FirstResponderKit function as below.

Apply-FirstResponderKit on SQL Server

If we ever want to read more about Apply-FirstResponderKit function, we can get its details using Get-Help.
Help on Apply-FirstResponderKit

Now, we can either import the module explicitly by using Import-Module command like below, or we can place the entire module in any of the directory inside $env:PSModulePath path.

PFA the entire FirstResponderKit PowerShell Module as attachment.

Friends, please feel free to connect with me for any query. Also, if you like the scripts, do Like & Share. Happy Coding 🙂

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.