Monitoring tables that return specific instance information

Table 4-3 lists monitoring tables that contain the InstanceID column.

Table 4-3: monitoring tables with InstanceID column

monCachePool

monDataCache

monCachedProcedures

monDeviceIO

monDeadLock

monErrorLog

monEngine

monIOQueue

monLicense

monLocks

monOpenDatabases

monNetworkIO

monOpenPartitionActivity

monOpenObjectActivity

monProcess

monProcedureCache

moProcessLookup

monProcessActivity

monProcessObject

monProcessNetIO

monProcessSQLText

monProcessProcedures

monProcessWaits

monProcessStatement

monResourceUsage

monProcessWorkerThread

monSysPlanText

monState

monSysStatement

monSysSQLText

monSysWorkerThread

monSysWaits

monCachedObject