Connections Advisor

The Connections advisor is accessible from the Connections Report.

The connections advisor allows you to see what queries other sessions are using.

This gives you the ability to snoop on what others are doing.

Just the other day someone was asking me questions about a query, and instead of asking them to save the query to a network drive or to email it to me, I just used the Connections Report to find their session, then I grabbed the query from the Connections Advisor and was able to immediately see what they were asking questions about. Its a handy tool.

It is accessed from the Connections Report.