Using Regex SQL Normalization to group SQL Statements

Document ID : KB000032008
Last Modified Date : 14/02/2018
Show Technical Document Details
  Question:

   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?

  Answer:

  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: https://support.ca.com/cadocs/0/CA%20Application%20Performance%20Management%209%206-ENU/Bookshelf_Files/PDF/APM--Java%20Agent%20Implementation%20Guide.pdf 

 
  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.