Resets statistics gathering for a specified persistence and scope. Each of the statistics tables available using the GETPERFSTATS ESSCMD command has a pre-defined persistence and scope. When you issue RESETPERFSTATS without parameters, statistics-gathering is reset for all of the tables.
Collecting and analyzing performance statistics can assist you in determining whether databases are in good running condition, or could use modifications to improve performance.
Depending on your database and production needs, you create a statistical measurement profile by resetting the appropriate levels of persistence (length of events to measure) and scope (granularity of the entity to measure).
Syntax
RESETPERFSTATS persistence scope
Parameter | Description |
---|---|
persistence [default=long] |
|
scope [default=all] |
|
Notes
This command resets to zero any previously collected statistics of a persistence shorter than or equal to the reset persistence. For example, entering RESETPERFSTATS LONG resets both long and medium statistics tables back to zero.
Example
RESETPERFSTATS ENABLE; RESETPERFSTATS MEDIUM SERVER;
See Also