Logging SQL Server report generation activity

Log category Server.Database.PerfReport sets the amount of information that PolicyCenter writes to the application server log while generating a performance report. In the base configuration, Guidewire sets the default level for this category to INFO. At this log level, PolicyCenter writes detailed messages about the generation of the performance report to the server log. To minimize the amount of information written to the server log during report generation set the log level to ERROR.

The following example output shows the kinds of information that PolicyCenter writes to the server application log if you set the log level for Server.Database.PerfReport to INFO.

adminuser su  2018-08-01 10:52:14,731 INFO <BatchProcessStarted> Batch process started \{type= "MSDMVReport", processHistoryId=255}
adminuser su  2018-08-01 10:52:14,746 INFO  Process starting...
adminuser su  2018-08-01 10:52:14,746 INFO Starting data collection...
adminuser su  2018-08-01 10:52:14,760 INFO Data collected: 1 of 39
adminuser su  2018-08-01 10:52:18,589 INFO Data collected: 2 of 39
adminuser su  2018-08-01 10:52:18,739 INFO Data collected: 3 of 39
adminuser su  2018-08-01 10:52:18,899 INFO Data collected: 4 of 39
...
adminuser su  2018-08-01 10:52:49,681 INFO Data collected: 38 of 39
adminuser su  2018-08-01 10:52:49,688 INFO Data collected: 39 of 39
adminuser su  2018-08-01 10:52:49,688 INFO Data collection complete
adminuser su  2018-08-01 10:52:51,954 INFO Data analysis completed
adminuser su  2018-08-01 10:52:56,530 INFO Report printer completed
adminuser su  2018-08-01 10:52:56,540 INFO Report was generated and serialized
adminuser su  2018-08-01 10:52:57,122 INFO Status has been saved and process is now complete
adminuser     2018-08-01 10:52:57,134 INFO <BatchProcessCompleted> Batch process complete 
      \{type= "MSDMVReport, processHistoryId=255, elapsedTimeMs=42423, error= null}
adminuser sys 2018-08-01 10:54:59,422 INFO <BatchProcessStarted> Batch process started 
      \{type= "ProcessCompletionMonitor", processHistoryId=256}
adminuser     2018-08-01 10:54:59,472 INFO <BatchProcessCompleted> Batch process completed 
      \{type= "ProcessCompletionMonitor", processHistoryId=256, elapsedTimeMs=74, error= null}