ShowBlockTree



Shows all blocking processes and their blocks as well as the resources they are waiting on.


round-pushpin Shows block process tree.
Exec ShowBlockTree




SQL::ShowSystemFunctions
Displays the list of built-in system functions and their parameters.
SQL::System Procedures
Built in procedures that allow you to evaluate various aspect of the database engine.