Evaluating System and Application Performance

SQLFire provides statistics for analyzing system performance. Any member of a distributed system, including SQLFire servers, locators, and peer clients, can collect and archive this statistical data.

SQLFire samples statistics at a configurable interval and writes them to an archive. The archives can be read at any time, including at runtime.

You can view and analyze runtime or archived historical data using these tools:

sqlf stats is a command-line tool provided with the SQLFire product.
VMware vFabric GemFire Visual Statistics Display (VSD) is a graphical tool provided in a separate download. See Using VSD to Analyze Statistics.

Note: SQLFire statistics use the Java System.nanoTimer for nanosecond timing. This method provides nanosecond precision, but not necessarily nanosecond accuracy. For more information, see the online Java documentation for System.nanoTimer for the JRE you are using with SQLFire.

Note: Runtime viewing of statistics archives files is not necessarily real-time, because of file system buffering.

Collecting System Statistics
You use boot properties, connection properties, and system properties to enable system statistics.
Collecting Application Statistics
You can collect your own application-defined statistics to record anything of interest to your application, such as throughput and latency for multi-statement transactions and application-specific configuration values.
Using VSD to Analyze Statistics
The Visual Statistics Display (VSD) reads the sampled statistics from one or more archives and produces graphical displays for analysis. VSD is a separate download.

Parent topic: Managing and Monitoring vFabric SQLFire