Page History

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

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

5. Revert the Perflogs configuration and restart services.