When clicking the "SQL Text" column on the Performance Investigator (PI) Blocking dashboard to get the details of the blocking/blocked statement displayed, nothing happen.
When clicking on another statement of another block, it shows all details of the statement.
Why does Foglight behaves so differently?
Foglight can only display only those statements which are appearing in the list left handside. For example:
If a statement is blocking another another statement, but it does not consume much resources, it may not appear in the SQL Statement list, but it appears in the blocking dashboard. By default Foglight displays only the top 25 resource consumers in each dimension.
This filter can be changed here:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center