SQL-Server-First-Responder-Kit
SQL-Server-First-Responder-Kit copied to clipboard
BrentOzarULTD
sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
**Version of the script** Version '8.10', VersionDate '20220718' **What is the current behavior?** Runs through until check 44 then reports "Database '?' does not exist. Make sure the name is...
Retains checks for Azure SQL DB and tested to work there, but now enables it to work for Azure SQL Managed Instances as (I believe is) intended - also tested....
I perhaps haven't named the variables particularly well. In my local copy I've changed @StopAt to be @StopAtUtc for clarity. This was causing me a problem as the file list...
**Version of the script** SELECT @Version = '8.09', @VersionDate = '20220408'; **What is the current behavior?** In database compat levels 150 (2019) and prior, if you run sp_BlitzCache, you can...
Suggested modifications to sp_BlitzIndex script regarding removal of "sanity"-related language. See readme file for more details.
**Version of the script** SELECT @Version = '8.11', @VersionDate = '20221013'; **What is the current behavior?** Running sp_BlitzQueryStore against a Query Store enabled DB running compatibility mode 100 on SQL...
**Is your feature request related to a problem? Please describe.** I execute `sp_Blitz**` scripts from SQLNotebooks (through PowerShell). The execution of procedures return 2 types of results- - "output_type": "execute_result"...
I decided to clean up anything that bothered me in `sp_BlitzQueryStore` before beginning any serious work on it. These are largely style changes. Summary: 1. Minor edits to some comments,...
Metadata
Owner
Metadata
sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.