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