SQL

• BLOCKTREE
  Blocked processes
• DMV_CURRENTSHOWPLAN
  SQL plans for current executing statements
• DMV_CURRENTSQLTEXT
  SQL text of current executing statements
• DMV_CURRENTSTMT
  Current executing statements