[frs-144] Is there any way we can log slow requests, and or the request history directly into a SQL database? I’d like to be able to have long term storage of slow requests, and run reports off of this data if this is possible?

It is possible to log requests from FusionReactor into log files. This can be done by enabling Request Logging in the Request Settings. You can have the log file rotate automatically and you can set the size of the logs too. These settings are in the advanced setting screen. Note: Please do not activate Request Capture as this really captures all of the request, it's headers and page content and it can use a lot of disk space quickly. It's very powerful, but you have to be careful.

The records written to the log can be imported into a database relatively easily however because each field is delimited by a space character. Here are the field definitions:

log_entry_date
log_entry_time
request_status (Starting: / Finished: )
request_status_date
request_status_time
request_status_time_millis
request_id (incrementing request id since the server was started)
thread_name (from Java)
client_ip_address
request_url
execution_time (ms)
used_memory_percentage
max_memory (KB)
used_memory (KB)
total_memory (KB)
free_memory (KB)
query_string
return_status_code

Issue Details

Type: Technote
Issue Number: FRS-144
Components: Metrics
Environment:
Resolution: Fixed
Last Updated: 25/Jun/07 12:25 PM
Affects Version:
Fixed Version:
Server:
Platform:
Related Issues:

Comments are closed.