HTML/Excel report - stats info - add commands to update stats

VladDBA / PSBlitz

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.

https://vladdba.com/2022/09/15/psblitz-easily-outputs-sql-server-diagnostic-data/

Other

78 stars 17 forks source link

HTML/Excel report - stats info - add commands to update stats #207

Closed VladDBA closed 5 months ago

VladDBA commented 5 months ago

Add commands (either as a new column or new table) to update stats for tables with stale stats. Three sets of commands:

for whole table
for specific statistics
for a specific partition in the case of incremental statistics

Also include suggestions (as comments) for FULLSCAN or SAMPLE # PERCENT, based on table sizes