10.5.1 HotFix 51:
In the Application Server configuration add this Java property and set a larger number than the default value of 128:
The 10.5.1 implementation has changed to be via a dynamic/hot agent profile property and set a larger number than the default value of 1024:
The required value to ensure that all applications with large number of simultaneous SQL prepared and callable statements can be successfully monitored without "Unknown SQL" nodes will depend on the application and example values could be 3000, 10000. The value used will have no impact on resources required. Once the application closes a prepared statement the agent will remove it from the cache so aside from the specified size limit the cache is also being constantly cleaned.