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
sp_BlitzQueryStore
sp_DatabaseRestore
sp_ineachdb
sp_AllNightLog
sp_AllNightLog_Setup
SQLServerVersions
Bibliography
Permissions for non-DBAshttps://dba.stackexchange.com/questions/188192/minimum-permissions-required-to-run-sp-blitz