SQL subsystem statistics

Attribute

Description

ArcValueCalls/sec

Rate of RPC calls made to PI Archive Subsystem to obtain a single archived value.

ArcValueCompCalls/sec

Rate of RPC calls made to PI Archive Subsystem for compressed events.

ArcValueCompEvents/sec

Rate at which compressed data events are returned by PI Archive Subsystem.

ArcValueTimedCalls/sec

Rate of RPC calls made to PI Archive Subsystem for interpolated or timed events.

ArcValueTimedEvents/sec

Rate at which interpolated or timed data events are returned by PI Archive Subsystem.

Callbacks/sec

Rate of calls to PI-SQL execution callback routine.

Dot Variable Evaluations/sec

Rate of "dot" variable evaluations made within the PI SQL Library. A dot variable in SQL is a table alias and column name, such as "picomp.tag.” This rate is a measure of PI SQL Subsystem processing not related to obtaining data from other subsystems.

Handles

Number of PI SQL handles currently allocated in PI SQL Subsystem. This is an indication of how many clients are actively processing SQL statements.

Next Point With Source Calls/sec

Rate at which points are returned by PI Base Subsystem in searches for points with a specific PointSource attribute.

PostCalls/sec

Rate of RPC calls made to PI Snapshot Subsystem to post events from execution of SQL INSERT or UPDATE statements.

PostEvents/sec

Rate at which data events are posted to PI Snapshot Subsystem from execution of SQL INSERT or UPDATE statements.

SnapshotCalls/sec

Rate of RPC calls made to PI Snapshot Subsystem to obtain a single snapshot value.

SummaryArcValueCalls/sec

Rate of RPC calls made to PI Archive Subsystem for summarized values (such as average, total, and standard deviation).

WHERE Clause Evaluations/sec

Rate of full evaluations of the WHERE clause of a SELECT statement.

WildcardPoints/sec

Rate at which points are returned when performing wildcard searches of the PI point database.

WildcardSearches/sec

Rate at which new wildcard searches are initiated in the PI point database.