The monitor access to SQL batch text feature allows a user with the System Administrator role to display the SQL batch text of any client command that is running on Adaptive Server. Although you configure Adaptive Server to save the SQL batch text, the batches are viewable only through Adaptive Server Monitor‘ Server.
Monitor access includes sp_showplan, which allows you to view the query plan for the query that is currently running. Monitor Server is not required to retrieve the query plans.
Both monitor access and sp_showplan are particularly useful for determining why a client session is hanging or using large amounts of CPU time or physical I/O.
