To Setup Blitz Stored Procedure

performance
#performance#monitoring#health-check#blitz
IF OBJECT_ID('dbo.sp_Blitz') IS NULL
 EXEC ('CREATE PROCEDURE dbo.sp_Blitz AS RETURN 0;');
GO

ALTER PROCEDURE [dbo].[sp_Blitz]
 @Help TINYINT = 0 ,
 @CheckUserDatabaseObjects TINYINT = 1 ,
 @CheckProcedureCache TINYINT = 0 ,
 @OutputType VARCHAR(20) = 'TABLE' ,
 @OutputProcedureCache TINYINT = 0 ,
 @CheckProcedureCacheFilter VARCHAR(10) = NULL ,
 @CheckServerInfo TINYINT = 0 ,
 @SkipChecksServer NVARCHAR(256) = NULL ,
 @SkipChecksDatabase NVARCHAR(256) = NULL ,
 @SkipChecksSchema NVARCHAR(256) = NULL ,
 @SkipChecksTable NVARCHAR(256) = NULL ,
 @IgnorePrioritiesBelow INT = NULL ,
 @IgnorePrioritiesAbove INT = NULL ,
 @OutputServerName NVARCHAR(256) = NULL ,
 @OutputDatabaseName NVARCHAR(256) = NULL ,
 @OutputDatabaseNameLong NVARCHAR(256) = NULL ,
 @EmailRecipients NVARCHAR(MAX) = NULL ,
 @EmailProfile sysname = NULL ,
 @SummaryMode TINYINT = 0 ,
 @BringThePain TINYINT = 0 ,
 @IgnoreDates NVARCHAR(MAX) = NULL ,
 @OutputXMLFileName NVARCHAR(MAX) = NULL ,
 @OutputXML XML = NULL ,
 @CompressXML TINYINT = 0 ,
 @Debug TINYINT = 0 ,
 @Version VARCHAR(30) = NULL OUTPUT ,
 @VersionDate DATETIME = NULL OUTPUT ,
 @VersionCheckMode TINYINT = 0
AS
 SET NOCOUNT ON;
 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

 DECLARE @Version VARCHAR(30) = '8.01';
 DECLARE @VersionDate DATETIME = '20231013';

Note: This is a reference stub for the sp_Blitz stored procedure. The full source code (~39,000 lines) is maintained by Brent Ozar as part of the First Responder Kit.

Download the complete script: github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit

To install: run the full sp_Blitz.sql from the repository against your SQL Server instance.