ttStats
The ttStats
utility monitors database metrics (statistics,
states, and other information) or takes and compares snapshots of metrics for SQL
statements.
The ttStatsConfig
built-in procedure configures the collection of
metrics for SQL statements. See ttStatsConfig.
This utility can be used in TimesTen Classic and TimesTen Scaleout, but supports
different syntax and options. The following sections describe the
ttStats
utility for:
The table Differences between ttStats in TimesTen Classic
and TimesTen Scaleout the main differences of how the
ttStats
utility works in TimesTen Classic
and TimesTen Scaleout.
Differences between ttStats in TimesTen Classic and TimesTen Scaleout
Action | TimesTen Classic | TimesTen Scaleout |
---|---|---|
Create a snapshot |
Run the |
The If you run |
Drop a snapshot |
Run the |
The The |
View information about a snapshot |
Run the |
Run the |
Generate a report between two snapshots |
Run the |
Run the You can only generate a text version of a report in TimesTen Scaleout. |