The last SQL statement executed is shown in the SQL Statement block.
For Adaptive Servers prior to v12.5.0.3, the SQL shown is what is in the network buffer when it was collected. In cases where the SQL statement is larger than the buffer, what is shown is the last part left in the buffer.
Increasing the network buffer size will make more of the SQL statement available.
Starting with Adaptive Server v12.5.0.3, the default is 256 bytes. This value can be increased by raising the configuration value "max SQL text monitored."
Note: If you do not see SQL Statements, check to make sure the account you are using has the "sybase_ts_role" assigned to it if the Adaptive Server version being monitored was released prior to 12.5.0.3.
