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

Best practices Report rules addition and report improvements. Plus query performance improvements for post-import #205

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 1 year ago

To test:

  1. Examine the Best Practices report in SQL Nexus after you have imported a collection and see if you have any feedback
  2. To check for the performance optimizations improvement look at the SQL Nexus log and check how long the time is between the start and end of Perfstats analysis

image

For example in my case the time difference was about 2 seconds. Used to be about 3 min before this change.

SQLNexus Information: 0 : Running Perfstats Analysis     DateTime=2023-01-19T04:30:16.1623753ZSQLNexus Information: 0 : End of Perfstats Analysis     DateTime=2023-01-19T04:30:18.1270947ZYou can see it took about 2 seconds in my case

PiJoCoder commented 1 year ago

@hdharshana and @asavioli - can you test this out and provide feedback. Actually, I'll send a beta.