No more new SQL metrics can be created

Products

• DX Application Performance Management
• CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

Java Agents started to log below message, what it means?

7/12/20 06:02:53 AM EDT [WARN] [IntroscopeAgent.Agent] Absolute metric clamp of 100 reached, no more new SQL metrics can be created. All metrics will be reported under the default bucket. If you wish to increase the clamp value, change the property - introscope.agent.sqlagent.statement.clamp

Environment

Application Performance Management Java Agent 10.7 release.

Cause

It is due to the clamp setting under Agent configuration.

Resolution

This message means that SQL agent got clamped after report more than 100 metrics in a period as set under IntroscopeAgent.Profile, you can adjust the setting as below:

#This property specifies the number of unique normalized SQL statement metrics that the 
#SQL agent can report. Once the clamp is hit, the SQL agent reports all additional normalized
#SQL statement metrics under the SQL | Default metric node in the Metric Browser tree. 
# Changes to this property take effect immediately and do not 
# require managed application restart
introscope.agent.sqlagent.statement.clamp=100

You can raise the value of 100 to 300 and see the results.
You must restart the managed application to this properties take effect.