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

More Best practices rules+ SQL Nexus main report new look #220

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 1 year ago

To test #217

Just explore the new design of the SQL Nexus main form

image

To test #216

To test, try to import data in an existing SQL Nexus db that has prior data imported into it. You will be told that there is already data but the Import diaglog will not close like it used to do.

To test #215

This may be a bit challenging to test unless you re-created the conditions which hit these rules or manually engineer the raw data in the output files to match the conditions. But if you have feedback on output - here are screenshots

image

image

image

image

To test #210

Explore the database properties report

image

image

image

PiJoCoder commented 1 year ago

Additional VLF report

image

image