Every warning includes a URL for deep-dive fixes.
: Filters results to only show critical issues.
Run the script against your preferred database (usually master ). Run: Open a new query window and type: EXEC sp_Blitz; Use code with caution. Key Parameters for Better Results You can customize the output using these common parameters: sp_blitz download
Checks backups, security, memory, and hardware settings. How to Install and Run Installing is as simple as running a single T-SQL script. Download: Get the zip file from BrentOzar.com or GitHub.
: Saves the results to a table for long-term tracking. Every warning includes a URL for deep-dive fixes
It performs read-only checks on system diagnostic data.
: Adds hardware details like CPU, memory, and OS. Run: Open a new query window and type:
sp_Blitz is a "consultant in a box." It scans your SQL Server for common performance, security, and reliability issues. Returns a prioritized list of issues.
: Skips deep database scans to run faster.
Locate sp_Blitz.sql and open it in SQL Server Management Studio (SSMS) .