![]() Execute sp_Blitz: $results = Invoke-DbaQuery -SqlInstance $s.Name -Database master -Query "EXEC sp_blitz = 1" This command will install the latest version of the FRK or update a previously installed version to the latest. ![]() Install or Update the First Responder Kit on each SQL Server: Install-DbaFirstResponderKit -SqlInstance $s.Name -Database master -Force ![]() Now that we have all of our servers we can proceed to gather all the sp_Blitz data. $ servers variable with all the SQL Servers in my local Central Management Server. Gather your list of servers: $servers = Get-DbaRegisteredServer -SqlInstance "localhostsql2017" A pre-requisite to run the script is to install the dbatools.io module and have it on the system you execute the script from. Let us walk through the steps in the script now to see what you can accomplish. Sounds like an awesome tool right? What if I told you I put together a PowerShell script that will allow you to perform this action against ALL your SQL Servers and store the results in a Central Database to analyze from one location and build your corrective action plan. This will evaluate your SQL Server and present you with a prioritized output list of actionable items for you to analyze. ![]() This is a free set of tools that help you check the health of your SQL Servers.Īre you aware of SQL Server configuration settings that differ on your servers compared to best practices? If not, then the FRK tool sp_Blitz is the tool for you. Are you a Microsoft SQL Server DBA managing one or more servers? Then you should know about the First Responder Kit from Brent Ozar Unlimited. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |