Top SQL statements are truncated in the Top SQL database agent pages (4295027)

Top SQL statements are truncated in the Top SQL drilldown pages of the agent for the monitored database.

Change the setting in the Agent Properties increasing the Top SQL size.

1. Navigate to Administration | Agents | Agent Status
2. Highlight the database agent
3. Click the Edit Properties button
4. Click the link to Modify Properties for this agent only.
5. Scroll down to the Top SQLs area and update the value for SQL text size (bytes) to 8192 (for example)
6. Click the Save button

This change would be applicable to the text for SQL queries collected after the change has been made.

Increasing the SQL size should not cause performance issues but it may have lead to memory issues in cases where the FglAM doesn't have enough memory since the memory cache will maintain more data if the values are increased.