a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files.
If spBlitzIndex_NonSPLatest.sql returns more than 30k records in an instance-wide check, the output to HTML will be limited to the databases found in the plan cache results (the ones returned by spBlitzCache_NonSPLatest.sql) and priority 250 is excluded.
If spBlitzIndex_NonSPLatest.sql returns more than 30k records in an instance-wide check, the output to HTML will be limited to the databases found in the plan cache results (the ones returned by spBlitzCache_NonSPLatest.sql) and priority 250 is excluded.