monOpenPartitionActivity

DBID

int

Unique identifier for the database.

ObjectID

int

Unique identifier for the object.

IndexID

int

Unique identifier for the index.

PartitionID

int

Unique identifier for the partition.

InstanceID

int

ID of an instance in a shared-disk cluster.

DBName

varchar(30)

Null

Name of the database in which the object resides.

ObjectName

varchar(30)

Null

Name of the object.

PartitionName

varchar(30)

Null

Name of the partition.

LogicalReads

int

Counter, null

Total number of buffers read.

PhysicalReads

int

Counter, null

Number of buffers read from disk.

APFReads

int

Counter, null

Number of asynchronous prefetch (APF) buffers read.

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.

OptSelectCount

int

Counter, null

Number of times object was selected for plan during compilation.

LastOptSelectDate

datetime

Null

Last date the index was selected for 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 a partition. A large value implies the system is generating large amounts of garbage for the specified partition.

HkgcPending

int

The number of pending events for a partition. 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 partition 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

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 physical lock requested 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.

MaxPhysicalLockWaitTime

real

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

AvgPhysicalLockWaitTime

int4

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

MaxTransferReqWaitTime

real

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

AvgTransferReqWaitTime

int4

(Cluster environments only) Average amount of time physical lock requests wait before receiving 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 time spent by the cluster cache manager of an instance.

MaxServiceTime

real

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

AvgQueueWaitTime

int

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

MaxQueueWaitTime

int

(Cluster environments 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 service time an instance’s cluster cache manager waits 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 for a physical lock because the object in question was in use by another process.

AvgTransferSendWaitTime

int4

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

MaxTransferSendWaitTime

real

(Cluster environments only) Maximum amount of time the Cluster Cache Manager for an instance waited for page transfer to complete

AvgIOServiceTime

int4

(Cluster environments only) Average amount of service 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.

ObjectCacheDate

datetime

Counter, reset, null

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

HkgcRequestsDcomp

int

Total number of data pages of the partition that were queued for page compression

HkgcPendingDcomp

int

Number of data pages of the partition that are still pending for page compression

HkgcOverflowsDcomp

int

Total number of pages that could not be compressed because the housekeeper queue was full.

IOSize1Page

int

Number of IO operations performed for each IO one page in size

IOSize2Pages

int

Number of IO operations performed for each IO that is 2 pages in size

IOSize4Pages

int

Number of IO operations performed for each IO that is 4 pages is size

IOSize8Pages

int

Number of IO operations performed for each IO that is 8 pages in size