Missing Indexes remove duplicate entries for each index in the report + add Deltas report from collection period

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

Missing Indexes remove duplicate entries for each index in the report + add Deltas report from collection period #115

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 3 years ago

Missing indexes is imported from Perfstats Snapshot script in PSSDIAG/SQLLogScout. That script is run at startup and shutdown of the log collector and thus the data shows twice for each index. A query that computes the delta/difference between the values is needed to show if there was a major change during data collection, but also to show only one line for each recommended missing index.

PiJoCoder commented 2 years ago

We will use the enhancement that https://github.com/microsoft/SqlNexus/issues/138 will introduce. Then the report needs to be changed. Proposing the following information displayed:

Show the improvement measure from start of SQL Server Show the delta between startup and shutdown of PSSDIAG and see if any index would have offered a significant improvement if it were there during PSSDIAG collection

PiJoCoder commented 1 year ago

Here is a snapshot