Activate enhanced logging for the Idera - Collector service in SQL Workload Analysis, following these steps:

  1. Stop the Idera - Collector and the Idera - Framework
  2. Change the configuration of properties file:
    1. Locate the following paths:

<<Idera SQLWA InstallationDir>>\deploy\etc\perflog.properties

<<Idera SQLWA InstallationDir>>\etc\perflog.properties

  b. By default, the first line would be: logger.performanceLogger=FATAL , requestAppender

  c. Change the line, as follows: logger.performanceLogger=DEBUG , requestAppender

3. Start the Idera - Collector and the Idera - Framework

        The Collector perflogs are created at: <<Idera SQLWA InstallationDir>>\deploy\var\logs

        While the Framework JMS perflogs: <<Idera SQLWA InstallationDir>>\tomcat\logs

Wait half an hour or so to have actionable insights from the logs.

4. Stop the Idera - Collector and the Idera - Framework

5. Revert the Perflogs configuration and restart services.




IDERA |  Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels