You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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 paths:

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

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

                b. By default, the first like 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.

  • No labels