What's Changed
- changed column name to remove duplicate by @DForck42 in #509
- added QUOTENAME to the output of the 'original_index_definition' colu… by @HannahVernon in #529
- added note about index_count column to the README.md by @HannahVernon in #530
There's no way to quickly or easily summarize this many changes, but:
sp_HealthParser:
- Added new event collections around errors, memory, and more cpu stuff
- Added the ability to log to tables
- Removed a lot of repetitive code by templating dynamic sql
sp_HumanEventsBlockViewer:
- Added the ability to log to a table. I know it's somewhat redundant to sp_HumanEvents, but it focuses purely on blocking and uses the final results from here rather than somewhat raw data with a view over it
- Added the ability to read from a table storing the blocked process report in an XML column
sp_PressureDetector
- Added table logging
sp_QuickieStore:
- Made the results query far less repetitive, no longer broken up over four sections of annoying to maintain code
- Pushed @include_query_hashes data deeper into the procedure so it's not just based on the results
AND THE BIG ONE!
sp_IndexCleanup
- No longer in beta!
- Reasonably functional, but still needs testing
Also fixed up some annoying formatting inconsistencies, etc. in various places.
New Contributors
Full Changelog: Updates_20250101...Updates_20250401