Understanding FusionReactor Log Files
A free log parser to analyze FusionReactor 3 Log Files
Content taken from FusionReactor Google Group page created by Charlie Arehart and Bill Shelton.
Join the FusionReactor Google Group
FusionReactor Log Files
FusionReactor creates great logs which can be very helpful in analyzing what's going on within your CF (or other J2EE server) environment. For example, there are several useful logs in FR, which details each request, each query, all crash protection events, and a log that tracks resource utilization every 5 seconds.
Free Log Parser
Of course, when logs have lots of data, it can be a challenge pulling out meaningful information. There's a great free tool that can help with that! It is a command-line tool from Microsoft, which enables you to process FusionReactor (and other) log files using SQL syntax. You can download the Log Parser here.
Using the Log Parser with FR
FusionReactor 3.x provides a set of "header" files which are perfect for use with Log Parser. There's one for each of the log file, and the header file identifies for its corresponding log file the column names. This page serves as a repository for variants of LP SQL statements created to be used with FR, as offered by different FR users. You can read more about FusionReactor log files in the FR online help.
Uses
You can do many things with the log parser. For example you can create tabular reports, charts and graphs, or store the results in a database. It's also possible to read multiple log files (of the same type) at once, as shown in some examples below. In addition you can store the SELECT statements in a separate file to be reused within the tool, passing in arguments for variation.
Learning More
Example LP SQL statements created to be used with FR
Monitoring Your ColdFusion Environment with the Free Log Parser Toolkit
