search cancel

Using Regex SQL Normalization to group SQL Statements


Article ID: 32008


Updated On:


CA Application Performance Management Agent (APM / Wily / Introscope) INTROSCOPE



   I am using Regex SQL Normalization to group SQL Statements and have followed the suggested steps. However, I still see lot of my existing SQL statements un-  grouped. Do I need to restart the EM server?


  Regex normalization will only be applicable for any new SQL queries post property specification. The agent cannot go undo all previous metrics that were reported   before the new regex was deployed and then group them under the desired node


Note: However, they will report zero values until aged out.  It will work only on new incoming, or  any sort of filtering in the agent (JMX\Sockets).


  Additional Information:

  The agent implementation guide has details to configure regex: 

  Though all the regex configuration properties specified in the documentation are hot properties, this explains a restart is suggested. The properties are hot config but they will only get applied to any new SQL metrics that are seen by the Agent matching the regex, and also incur temporary overhead to the application. Typically all this work of filtering\regex testing or getting right monitoring setup is recommended as a part of testing in a Development environment, where you can freely restart or test multiple combinations.


Release: CEMUGD00200-10.1-Introscope to CA Application-Performance Management-Upgrade Mai