PSBlitz v3.6.0

What's new:

Enhancements

• Execution log - if index frag info is skipped due to xlock on table(s) -> log the table names - #125
• Get and export execution plans for any opened transactions found during the opened transactions check - #133
• Increase -MaxTimeout default from 800 to 1000 seconds - #135
• HTML output - specify in the index page if database-specific check or instance-wide - #137
• Execution log - record if CheckDB's value is changed as a result of the "2/3 of BlitzCache results" check - #139
• Add the same switch logic for query store related checks - #131
• Add parameter -CacheTop to retrieve more/less than the top 10 queries from the plan cache - only compatible with HTML output - #134

Bug fixes:

• Fix comments in scripts - #126
• Occasionally if NULL shows up as a database for more than 2/3 of the plan cache records, the switch to run stats and index frag checks is triggered - #132
• $SqlConnection.Close() not in a finally block - #124
• HTML output - in-depth check - Queries by Recent Compilations - wrong number in table title - #140
• Incorrect database file size in Database Info report page, Database Files Info table - #128
• Arithmetic overflow error in GetDbInfo.sql when calculating sizes of large databases with multiple data files - #141

More Info

• Dev by @VladDBA in #142

Full Changelog: v3.5.0...v3.6.0