Note: Documentation for Pivotal SQLFire 1.1.x is now available at http://docs.gopivotal.com/sqlfire/index.html. Please reference the docs.gopivotal.com site for the latest and most up-to-date documentation on SQLFire. The vFabric SQLFire documentation site will no longer be updated.

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 installed with vFabric SQLFire in the tools subdirectory.

The statistics values (Y-axis) are plotted over time (X-axis). This makes it easy to see how statistics are trending, and to correlate different statistics.

Start VSD by entering the command:

<SQLFireInstallDir>/bin/vsd/bin/vsd

Archives are usually loaded by passing them in on the command line:

<SQLFireInstallDir>/bin/vsd/bin/vsd <archiveFileName> …

VSD’s extensive online help offers complete reference information about the tool. The sections that follow show examples of analyzing the SQLFire performance metrics.