This temporary stored procedure is part of the "Recent Expensive Queries" tab in Activity Monitor.

This along with a bunch of other queries are executed to populate the data in your recent expensive queries tab in Activity Monitor.

-Paul N.