Enabling Recording of Data Source Usage in the Events Log
Several configuration parameters can be set to record detailed data source usage information which can then be found in the events log (<TDV_install_dir>\logs\cs_server_events.log). Each of the configuration parameters below specify that certain values be added to the events log and are used in combination to control what is collected.
Configuration Parameter that You Set to True | Values Added to Events Log |
Enable System Events | Request ID, Transaction ID, Session ID, Session Host, Session Client Type, User Name, Domain Name, Internal (True for system-generated events), Bytes In, Bytes Out, Rows Affected (number of rows processed) |
Include Data Source Timings | All of the above, plus Time to First Row, which is the time, in milliseconds, from the moment TDV received a request to the moment that TDV has fetched the first row from a data source. |
Detailed Profiling Enabled | All of the above, plus Data Source Time which is the time, in milliseconds, spent in the data source—not including any time spent in TDV. |
The values listed in the table are added to the events log only if the listed combinations of parameters are set to True.
To enable recording of data source usage in the events log
1. Start the TDV Server.
2. Open and log in to Studio as an admin user.
3. From the Administration menu, choose Configuration.
4. Navigate to Server > Events and Logging.
5. Make sure that Enable System Events is set to True.
6. Optionally locate Include Data Source Timings, and set it to True.
7. Optionally locate Detailed Profiling Enabled, and set it to True.
Setting Detailed Profiling Enabled to True can have significant negative impact on performance.
Here is an example of the data source usage information (the last 13 fields of the message) recorded in cs_server_events.log with the Enable System Events, Include Data Source Timings, and Detailed Profiling Enabled configuration parameters all set to True:
...16338 40803072 318257 x.y.com JDBC test yz false 578 315 2 73 2
These fields are interpreted as follows:
Req ID | Transaction
ID | Session ID | Host | Client Type | User | Domain | Internal | Bytes In | Bytes Out | Rows Affected | Time to First
Row | Data Source Time |
16338 | 40803072 | 318257 | x.y.com | JDBC | test | yz | false | 578 | 315 | 2 | 73 | 2 |
Log files are discussed in
About TDV Log Files.