Various additions to SQL Nexus - Githubissues

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

Various additions to SQL Nexus #230

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 1 year ago

Tempdb space usage by object report

PiJoCoder commented 1 year ago

Active Traces and Xevents

This shows up for both Traces and Xevents now

PiJoCoder commented 1 year ago

Expensive events Best practices rule show the right file now

PiJoCoder commented 1 year ago

AlwaysOn event is under Microsoft Xevents

PiJoCoder commented 1 year ago

If you import data Query Store.sql (perf collection) from SQL 2022 server you will see all of these new tables

tbl_query_store_wait_stats tbl_database_query_store_options tbl_query_store_query_hints tbl_query_store_plan_feedback tbl_query_store_query_variant

PiJoCoder commented 1 year ago

@asavioli, if you have a chance to test and review these changes, I'd appreciate your feedback. Thanks

PiJoCoder commented 1 year ago

Created a condition where if there is data in the table - tempdb space by session, we will show it in the report

But if there isn't any data, we won't show it