Collecting System Statistics

Enable SnappyData system statistics using a system procedure, member boot properties, or connection properties.

You can enable statistics collection per-member using the boot properties:

• statistic-sampling-enabled

• enable-time-statistics

• statistic-archive-file

!!! Note You must include the statistic-archive-file and specify a valid file name in order to enable statistics collection.

These boot properties help you configure a member's statistic archive file location and size:

• archive-disk-space-limit

• archive-file-size-limit

• statistic-sample-rate

To collect statement-level statistics and time-based, statement-level statistics for a specific connection (rather than globally or per-member), use these connection properties with a peer client connection:

• enable-stats

• enable-timestats

• statistic-archive-file

These properties can only be used with a peer client connect.

!!! Note

- Because of the overhead required for taking many timestamps, it is recommended that you enable time-based statistics only during testing and debugging.
- Use statement-level statistics only when the number of individual statements is small, such as when using prepared statements. SnappyData creates a separate statistics instance for each individual statement.