RESETPERFSTATS

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
ParameterDescription

persistence [default=long]

  • disable

    Turn off performance-statistics gathering.

  • enable

    Turn on performance-statistics gathering. You might do this when you want to tune the system, change hardware configuration, or monitor I/O. The measurement begins for current processes as soon as you enable it. Any subsequent queries for statistics return measurements spanning from the time of enablement to the time of the query.

  • medium

    Reset tables that measure medium-length events:

    • kernel I/O Statistics table

    • Cache Endtrans Statistics table

    • Database Synchronous I/O table

    • Database Asynchronous I/O table

  • long (default)

    Reset tables that measure events over the course of the entire session. Long measurements rarely need to be reset. Example: kernel Cache Statistics table.

scope [default=all]

  • db

    Reset per-database statistics tables.

  • server

    Reset per-application statistics tables.

  • all (default)

    Reset all statistics tables: for threads, databases, and applications.

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

  • GETPERFSTATS