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
356 stars 101 forks source link

Filter drivers report fixes + new table and Missing indexes fixes + new table #202

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 1 year ago
  1. 200

    • make sure the report is published when click-once Setup is used
    • add a where clause on Company to show non-MS drivers in the Filter drivers report
      • Add a new table that show the detailed filter driver instances for all filter drivers
  2. 115

    • Improvement measure is formatted the same, index statement column is wider, added colors for easier navigation, keep all on the same page (no multiple pages)
    • Remove duplicate entries collected at startup and shutdown - in the first report only show at shutdown
    • Add a new table in the same report that shows delta between start and shutdown of data collection
      1. 203