First Responder Kit
Check
DECLARE @VersionOutput VARCHAR(30),
@VersionDateOutput DATETIME;
EXEC sp_Blitz @Version = @VersionOutput OUTPUT,
@VersionDate = @VersionDateOutput OUTPUT,
@VersionCheckMode = 1;
SELECT @VersionOutput AS Version,
@VersionDateOutput AS VersionDate;
Install
Recommendation is to install the first responder kit in the Master database.
Install-Core-Blitz-No-Query-Store.sql
Recommended for SQL Versions lower than SQL2016Install-Core-Blitz-With-Query-Store.sql
Recommended for SQL2016 and aboveInstall-All-Scripts.sql
Recommended if you have already installed the Ola Hallengren Maintenance SolutionDeinstall
Uninstall.sql
See the README.md file shipped in the FirstResponderKit.zip file for a good introduction. See the links in the Bibliography at the bottom of this page for further details.
sp_BlitzIndex
sp_BlitzLock
sp_BlitzWho
sp_BlitzAnalysis
sp_BlitzCache
sp_BlitzInMemoryOLTP (deprecated) - See this instead: https://github.com/ktaranov/sqlserver-kit/tree/master
sp_BlitzQueryStore (deprecated) - See this instead: https://erikdarling.com/sp_quickiestore/
sp_DatabaseRestore
sp_ineachdb
sp_AllNightLog (deprecated)
sp_AllNightLog_Setup (deprecated)
SQLServerVersions
Bibliography
Permissions for non-DBAshttps://dba.stackexchange.com/questions/188192/minimum-permissions-required-to-run-sp-blitz
Slack Channelhttps://sqlcommunity.slack.com/messages/firstresponderkit/https://www.brentozar.com/slack/