3.29 Open Objects Statistics

The metrics in this category provide statistics for all open objects.

Collection frequency - Every 12 hours

Table 3-34 Open Objects Statistics Metrics

Metric	Description
For Release 6 Number of APF buffers read For Release 7 APF buffers read (OpenObject) rate (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of APF buffers read since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the APF buffers were read since last collection, that is, the number of APF buffers read since last collection divided by the elapsed time between two collections.
LastOptSelectDate	Last date.
Last Used Date	Last used date.
For Release 6 Number of lock requests on object For Release 7 Lock request rate for the object (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of requests for a lock on the object since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the requests were made for a lock on the object since last collection, that is, the number of requests for a lock on the object since last collection divided by the elapsed time between two collections.
For Release 6 Number lock waits For Release 7 Lock waits rate for the object (per sec)t	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of times a task waited for a lock for the object since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which a task waited for a lock for the object since last collection, that is, the number of times a task waited for a lock for the object since last collection divided by the elapsed time between two collections.
For Release 7 Lock waits % for the object	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Percentage of lock waits.
For Release 6 OptSelectCount For Release 7 Object selection rate for plan during compilation (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of objects selected for plan during compilation (per sec). For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the objects were selected for plan during compilation.
For Release 6 Total number of buffers read For Release 7 Buffers read (OpenObject) rate (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Total number of buffers read since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the buffers were read since last collection, that is, the number of buffers read since last collection divided by the elapsed time between two collections.
For Release 6 Object Name	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Name of the object.
For Release 6 Number of times the object is accessed For Release 7 Object access rate (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of times the object was accessed since last collection. The upload frequency is after every sample. The operator is >. Alert text is - The total number of times the object accessed are %Operations%. It has crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. For this metric, you can set different warning and critical threshold values for each unique combination of "DBID", "Object ID", and "Index ID" objects. If warning or critical threshold values are currently set for any unique combination of "DBID", "Object ID", and "Index ID" objects, those thresholds can be viewed on the Metric Detail page for this metric. To specify or change warning or critical threshold values for each unique combination of "DBID", "Object ID", and "Index ID" objects, use the Edit Thresholds page. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the object was accessed since last collection, that is, the number of times the object was accessed since last collection divided by the elapsed time between two collections.
For Release 6 Total number of pages read For Release 7 Page read (OpenObject) rate (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Total number of pages read since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) rate at which the pages were read since last collection, that is, the number of pages read since last collection divided by the elapsed time between two collections.
For Release 6 Total number of pages written to disk For Release 7 Page write (OpenObject) rate to disk (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Total number of pages written to the disk since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the pages were written to the disk since last collection, that is, the number of pages written to the disk since last collection divided by the elapsed time between two collections.
For Release 6 Number of buffers read from disk For Release 7 Buffers read (OpenObject) rate from disk (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Total number of buffers read from the disk since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the buffers were read from the disk since last collection, that is, the number of buffers read from the disk since last collection divided by the elapsed time between two collections.
For Release 6 Number of buffers written to disk For Release 7 Buffers write (OpenObject) rate to disk (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Total number of buffers written to the disk since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the buffers were written to the disk since last collection, that is, the number of buffers written to the disk since last collection divided by the elapsed time between two collections.
For Release 6 Number of deleted rows For Release 7 Row deletion (OpenObject) rate (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of rows deleted since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the rows were deleted since last collection, that is, the number of rows deleted since last collection divided by the elapsed time between two collections.
For Release 6 Number of inserted rows For Release 7 Row insertion (OpenObject) rate (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of rows inserted since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the rows were inserted since the last collection, that is, number of rows inserted divided by the elapsed time between two collections.
For Release 6 Number of updated rows For Release 7 Row updates (OpenObject) rate (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of updates. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the rows were updated since last collection, that is, the number of rows updated since last collection divided by the elapsed time between two collections.
For Release 6 Used Count For Release 7 Object usage rate in plan during execution (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of times the object was used in the plan during compilation since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the object was used in the plan during compilation since last collection, that is, the number of times the object was used in the plan during compilation since last collection divided by the elapsed time between two collections.
DBID	Database identifier.
DB Name	The name of the database.
Index ID	Index identifier.
Object ID	Object identifier.

Metric

Description

For Release 6

Number of APF buffers read

For Release 7

APF buffers read (OpenObject) rate (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of APF buffers read since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the APF buffers were read since last collection, that is, the number of APF buffers read since last collection divided by the elapsed time between two collections.

LastOptSelectDate

Last date.

Last Used Date

Last used date.

For Release 6

Number of lock requests on object

For Release 7

Lock request rate for the object (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of requests for a lock on the object since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the requests were made for a lock on the object since last collection, that is, the number of requests for a lock on the object since last collection divided by the elapsed time between two collections.

For Release 6

Number lock waits

For Release 7

Lock waits rate for the object (per sec)t

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of times a task waited for a lock for the object since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which a task waited for a lock for the object since last collection, that is, the number of times a task waited for a lock for the object since last collection divided by the elapsed time between two collections.

For Release 7

Lock waits % for the object

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Percentage of lock waits.

For Release 6

OptSelectCount

For Release 7

Object selection rate for plan during compilation (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of objects selected for plan during compilation (per sec).

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the objects were selected for plan during compilation.

For Release 6

Total number of buffers read

For Release 7

Buffers read (OpenObject) rate (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Total number of buffers read since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the buffers were read since last collection, that is, the number of buffers read since last collection divided by the elapsed time between two collections.

For Release 6

Object Name

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Name of the object.

For Release 6

Number of times the object is accessed

For Release 7

Object access rate (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of times the object was accessed since last collection. The upload frequency is after every sample. The operator is >. Alert text is - The total number of times the object accessed are %Operations%. It has crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.

For this metric, you can set different warning and critical threshold values for each unique combination of "DBID", "Object ID", and "Index ID" objects. If warning or critical threshold values are currently set for any unique combination of "DBID", "Object ID", and "Index ID" objects, those thresholds can be viewed on the Metric Detail page for this metric. To specify or change warning or critical threshold values for each unique combination of "DBID", "Object ID", and "Index ID" objects, use the Edit Thresholds page.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the object was accessed since last collection, that is, the number of times the object was accessed since last collection divided by the elapsed time between two collections.

For Release 6

Total number of pages read

For Release 7

Page read (OpenObject) rate (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Total number of pages read since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

rate at which the pages were read since last collection, that is, the number of pages read since last collection divided by the elapsed time between two collections.

For Release 6

Total number of pages written to disk

For Release 7

Page write (OpenObject) rate to disk (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Total number of pages written to the disk since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the pages were written to the disk since last collection, that is, the number of pages written to the disk since last collection divided by the elapsed time between two collections.

For Release 6

Number of buffers read from disk

For Release 7

Buffers read (OpenObject) rate from disk (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Total number of buffers read from the disk since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the buffers were read from the disk since last collection, that is, the number of buffers read from the disk since last collection divided by the elapsed time between two collections.

For Release 6

Number of buffers written to disk

For Release 7

Buffers write (OpenObject) rate to disk (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Total number of buffers written to the disk since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the buffers were written to the disk since last collection, that is, the number of buffers written to the disk since last collection divided by the elapsed time between two collections.

For Release 6

Number of deleted rows

For Release 7

Row deletion (OpenObject) rate (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of rows deleted since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the rows were deleted since last collection, that is, the number of rows deleted since last collection divided by the elapsed time between two collections.

For Release 6

Number of inserted rows

For Release 7

Row insertion (OpenObject) rate (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of rows inserted since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the rows were inserted since the last collection, that is, number of rows inserted divided by the elapsed time between two collections.

For Release 6

Number of updated rows

For Release 7

Row updates (OpenObject) rate (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of updates.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the rows were updated since last collection, that is, the number of rows updated since last collection divided by the elapsed time between two collections.

For Release 6

Used Count

For Release 7

Object usage rate in plan during execution (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

Number of times the object was used in the plan during compilation since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the object was used in the plan during compilation since last collection, that is, the number of times the object was used in the plan during compilation since last collection divided by the elapsed time between two collections.

DBID

Database identifier.

DB Name

The name of the database.

Index ID

Index identifier.

Object ID

Object identifier.