monOpenObjectActivity

DBID

int

Unique identifier for the database.

ObjectID

int

Unique identifier for the object.

IndexID

int

Unique identifier for the index..

InstanceID

int

(Cluster environments only) Unique identifier for an instance.

DBName

varchar(30)

Null

Name of the database in which the object resides

ObjectName

varchar(30)

Null

Name of the object.

LogicalReads

int

Counter, null

Total number of times a buffer for this object has been retrieved from a buffer cache without requiring a read from disk.

PhysicalReads

int

Counter, null

Number of buffers read from disk.

APFReads

int

Counter, null

Number of APF buffers read from disk.

PagesRead

int

Counter, null

Total number of pages read.

PhysicalWrites

int

Counter, null

Total number of buffers written to disk.

PagesWritten

int

Counter, null

Total number of pages written to disk.

RowsInserted

int

Counter, null

Number of rows inserted.

RowsDeleted

int

Counter, null

Number of rows deleted.

RowsUpdated

int

Counter, null

Number of updates.

Operations

int

Counter, null

Number of times the object was accessed.

LockRequests

int

Counter, null

Number of requests for a lock on the object.

LockWaits

int

Counter, null

Number of times a task waited for an object lock.

OptSelectCount

int

Counter, null

Number of times the optimizer selected this index to be used in a query plan.

LastOptSelectDate

datetime

Null

Last date the index was selected for a plan during compilation.

UsedCount

int

Counter, null

Number of times the object was used in a plan during execution.

LastUsedDate

datetime

Null

Last date the index was used in a plan during execution.

HkgcRequests

int

Total number of events queued for an object. A large value implies the system is generating large amounts of garbage for the specified object.

HkgcPending

int

The number of pending events for an object. A large value implies that a lot of garbage is yet to be collected, although the housekeeper will clean it up. If you reboot Adaptive Server, all entries in the housekeeper queue are lost, and the garbage from those pages is not collected when you restart Adaptive Server.

HkgcOverflows

int

The number of overflow object events. A large value implies the housekeeper queues are filling up. Generated garbage will not then be cleaned up because the housekeeper cannot schedule the job.

PhysicalLocks

int

(Cluster environments only) Number of physical locks requested per object.

PhsycialLocksRetained

int

(Cluster environments only) Number of physical locks retained. Use to identify the lock hit ratio for each object. Good hit ratios imply balanced partitioning for this object.

PhysicalLocksRetainWaited

int4

(Cluster environments only) Number of physical lock requests waiting before a lock is retained.

PhysicalLocksDeadlocks

int

(Cluster environments only) Number of times a requested physical lock returned a deadlock. The Cluster Physical Locks subsection of sp_sysmon uses this counter to report deadlocks while acquiring physical locks for each object.

PhysicalLocksWaited

int

(Cluster environments only) Number of times an instance waited for a physical lock request.

PhysicalLocksPageTransfer

int

(Cluster environments only) Number of page transfers that occurred when an instance requested a physical lock. The Cluster Physical Locks subsection of sp_sysmon uses this counter to report the node-to-node transfer and physical-lock acquisition as a node affinity ratio for this object

TransferReqWaited

int4

(Cluster environments only) Number of times physical lock requests waiting before receiving page transfers.

AvgPhysicalLocksWaitTime

int4

(Cluster environments only) Average amount of time clients spend before the physical lock is granted.

MaxPhysicalLockWaitTime

real

(Cluster environments only) Maximum amount of time this object waited for before a physical lock was granted.

AvgTransferReqWaitTime

int4

(Cluster environments only) Average amount of time physical lock requests wait before receiving page transfers.

MaxTransferReqWaitTime

real

(Cluster environments only) Maximum amount of time physical lock requests waited to receive page transfers.

TotalServiceRequests

int4

(Cluster environments only) Number of physical lock requests serviced by the cluster cache manager of an instance.

PhysicalLocksDowngraded

int4

(Cluster environments only) Number of physical lock downgrade requests serviced by the cluster cache manager of an instance.

PagesTransferred

int4

(Cluster environments only) Number of pages transferred at an instance by the cluster cache manager.

ClusterPageWrites

int4

(Cluster environments only) Number of pages written to disk by the cluster cache manager of an instance.

AvgServiceTime

int4

(Cluster environments only) Average amount of service time spent by the cluster cache manager of an instance.

MaxServiceTime

real

(Cluster environments only) Maximum amount of service time spent by the cluster cache manager of an instance.

AvgQueueWaitTime

real

(Cluster environment only) Average amount of time, in milliseconds, spent waiting for Adpative Server to complete buffer transfers for this object.

MaxQueueWaitTime

real

(Cluster environment only) Maximum amount of time, in milliseconds, spent waiting for Adaptive Server to complete a buffer transfer for this object .

AvgTimeWaitedOnLocalUsers

int4

(Cluster environments only) Average amount of time, in milliseconds, an instance’s cluster cache manager waited because of page use by users on this instance.

MaxTimeWaitedOnLocalUsers

real

(Cluster environments only) Maximum amount of time, in milliseconds, an instance’s cluster cache manager waited because of page use by users on this instance.

AvgTransferSendWaitTime

int4

(Cluster environments only) Average amount of time an instance’s cluster cache manager spends for page transfer.

MaxTransferSendWaitTime

real

(Cluster environments only) Maximum amount of time an instance’s cluster cache manager waited for a page transfer to complete.

AvgIOServiceTime

int4

(Cluster environments only) Average amount of time used by an instance’s cluster cache manager for page transfer.

MaxIOServiceTime

real

(Cluster environments only) Maximum amount of time the Cluster Cache Manager took to write pages to disk.

AvgDowngradeServiceTime

int4

(Cluster environments only) Average amount of time the cluster cache manager uses to downgrade physical locks.

MaxDowngradeServiceTime

real

(Cluster environments only) Maximum time a task spent waiting for the physical lock to be downgraded on a page.

SharedLockWaitTime

int

Counter, reset, null

The total amount of time, in milliseconds, that all tasks spent waiting for a shared lock.

ExclusiveLockWaitTime

int

Counter, reset, null

The total amount of time, in milliseconds, that all tasks spent waiting for an exclusive lock.

UpdateLockWaitTime

int

Counter, reset, null

The total amount of time, in milliseconds, that all tasks spent waiting for an update lock.

ObjectCacheDate

datetime

Counter, reset, null

Indicates the date and time when the object was added to the cache.

PRSSelectCount

int

Counter, null

The number of times the precomputed result set was used in a query.

LastPRSSelectDate

datetime

null

Date for the last time the precomputed result set was used in a query.

PRSRewriteCount

int

Counter, null

Number of times the optimizer determined that the precomputed result set was valid for use in a query. the optimizer may not have used the precomputed result set because it found a better choice.

LastPRSRewriteDate

datetime

null

Date for the last time the optimizer determined that the precomputed result set was valid for use in a query.