No more new SQL metrics can be created
search cancel

No more new SQL metrics can be created


Article ID: 195060


Updated On:


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


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


Application Performance Management Java Agent 10.7 release.


It is due to the clamp setting under Agent configuration.


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

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