This issue has been logged as Enhancement ID SSDB-14851 and will be part of the base functionality in the upcoming Spotlight PI product.
Execute the script below in order to increase SQL text size allowed by the agent. Refer to KB 232352 for details on running a groovy script using the script console in the Foglight Management Server.
This script is for a single database agent due to the performance impact that increasing the text size variable can have when multiple database agents are changed.
Change the two parameters in the script for the required text size and Agent name and then execute the script via the Foglight Script Console.
Note 1: Please put your agent name in line 3:
agentName = "<YourAgentName>";
agentName = "abc123-DefaultInstance";
Note 2: For customers including a parenthesis character "(" or ")" in the agent name, please treat the agent name field as a regular expression. For example: agentName="abcd00001234.example.com.*";
The information in the script provided is known to work successfully; however, it has not been officially tested by Quest Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by Quest Support and Development.
© 2020 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz