Install SQL Server First Responder Kit

https://www.brentozar.com/first-aid/

https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit#how-to-install-the-scripts

Run Install-All-Scripts.sql in master database.

Run sp_BlitzIndex.sql in individual database.

--EXEC sp_Blitz @CheckUserDatabaseObjects = 0, @CheckServerInfo = 1;
EXEC sp_BlitzFirst @SinceStartup = 1;


EXEC sp_BlitzCache @SortOrder = 'totals reads' ------------------ use master
EXEC sp_BlitzCache @SortOrder = 'cpu' ------------------ use master
EXEC sp_BlitzCache @SortOrder = 'executions' ------------------ use master
Exec sp_Blitz ------------------ use master
EXEC sp_BlitzFirst @seconds=60 ------------------ use master
EXEC sp_BlitzCache @SortOrder = 'avg reads' --, @ExportToExcel = 1 ------------------ use master
EXEC sp_BlitzIndex  ------------------ use master
EXEC sp_BlitzWho ------------------ use master
EXEC sp_BlitzIndex @BringThePain= 1 ----- Use after hours – Use in the DB