Head blocker trigger not showing on Nexus Tables

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

Head blocker trigger not showing on Nexus Tables #110

Closed asavioliMSFT closed 2 years ago

asavioliMSFT commented 3 years ago

After collecting data with pssdiag and loading it into nexus, I noticed the following issue:

1 - On the perfstat raw file, a trigger is showing as head blocker frequently

2 - On the table tbl_HEADBLOCKERSUMMARY generated by nexus, the trigger is no there.

raw_file nexus_table

PiJoCoder commented 2 years ago

This was fixed in 025bca55e8a5deac2c95c2494d58f9067d50d189 and related to #113