New best practices rule for unhealthy AG + checking for gaps in data collection + virtual file IO stats rowset

microsoft / SqlNexus

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQL LogScout, SQLDiag or PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.

MIT License

348 stars 99 forks source link

New best practices rule for unhealthy AG + checking for gaps in data collection + virtual file IO stats rowset #225

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 1 year ago

Added 2 Best practices rules for AG health check and endpoint check #196
Updated Best practices rule to detect abnormal gaps in data collection script outputs #91
Added rowsets for the tbl_dm_io_virtual_file_stats: #222 NOTE: You can collect a SQL LogScout IO scenario to get this output
Allow for Best Practices main report to be visible even when no Perf data is collected #223

PiJoCoder commented 1 year ago