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).
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