Setting query statistics logging properties
In Server Configuration Templates—Settings—Integration Service—Query Management—Query Statistics, shown in
Figure 10‑9, the administrator accepts or sets the value for each of the following query statistics logging properties:
Enable query statistics logging
Enables and disables logging of the statistics.
Query statistics log level
Standard logs query‑level statistics.
Info logs query‑ and operator-level statistics.
Detail logs query‑, operator‑, and database-level statistics.
The cumulative execution time is logged at the Info level.
Figure 10‑9 Specifying query statistics logging settings
