Select data from sap tables SYBM

Display SAP table details
  



SYBMON_ASEINSTANCE - SYB: ASE instance level performance

SYBMON_ASERESOURCES - SYB: data of sp_monitorconfig

SYBMON_CACHEDPROC - SYB: monCachedProcedure

SYBMON_CACHEDSTMT - SYB: master..monCachedStatement

SYBMON_CACHEDSTMTCOND - SYB: copy of SYBMON_CACHEDSTMT for alternative RDI mapping

SYBMON_CACHEDSTMT_META - SYB: master..monCachedStatement

SYBMON_CACHEPOOL - SYB: master..monCachePool

SYBMON_CACHE_OBJ - SYBMON_CACHE_OBJ

SYBMON_DATACACHE - SYB: master..monDataCache

SYBMON_DEVICEIO - SYB: master..monDeviceIO

SYBMON_DTA_TABLE - SYB: Table with deferred allocation

SYBMON_ENGINE - SYB: Engine

SYBMON_ERRORLOG - SYB: Error Log

SYBMON_EXECCOMPONENTINFO - SYB: Info on ASE execution components (monSysExecutionTime)

SYBMON_FILESYSTEM - SYB: File System Details

SYBMON_HADRMEMBERS - SYB: master..monHADEMembers

SYBMON_HISTOGRAM_FLAT - flattened history table for monitoring

SYBMON_INDEX_PERF - SYB: Index related data (performace/IO only)

SYBMON_INDEX_SPACE - SYB: Index related data (space only)

SYBMON_IOCONTROLLER - SYB: monIOController

SYBMON_KEYVAL_LIMIT - DBA: Integer Key + String value

SYBMON_KEYVAL_LOGIN - DBA: Integer Key + String value

SYBMON_LICENSE - SYB: master..monLicense

SYBMON_LOCK - SYB: master..monLocks

SYBMON_MEMORYUSAGE - SYB: master..monMemoryUsage

SYBMON_PROCCACHEUSAGE - SYB: master..monProcedureCacheModuleUsage

SYBMON_PROCESS - SYB: master..monProcess

SYBMON_PROCESSLOOKUP - SYB: master..monProcess

SYBMON_PROCESSSQLTEXT - SYB: master..monProcessSQLText

SYBMON_PROCESSSTMT - SYB: master..monProcessStatement

SYBMON_PROC_ACIVITY - DDIC structure for process activity trace

SYBMON_PROC_DETAIL - SYBMON_PROC_DTL_TRACE

SYBMON_PROC_NET_IO - SYBMON_PROC_NET_IO_TRACE

SYBMON_PROC_WAITS - SYBMON_PROC_WAITS_TRACE

SYBMON_REPSCANNERS - SYB: master..monRepScanners

SYBMON_REPSENDERS - SYB: master..monRepSenders

SYBMON_RESOURCE_LIMIT - resource limit for controller view

SYBMON_RES_LIMIT_DEFINE - Difine Resource limit for change (view)

SYBMON_ROW_TO_COL - SYB: row- to column-based structure

SYBMON_ROW_TO_COL_MAP - mapping for row- to column-based data conversion

SYBMON_SPINLOCKACT - SYB: master..monSpinLockActivity

SYBMON_STATE - SYB: master..monState

SYBMON_STMTCACHEUSAGE - SYB: master..monStatementCache

SYBMON_SYSLOAD - SYB: master..monSysLoad

SYBMON_SYSTIMESPENT - SYB: System Time Spent Breakdown

SYBMON_SYSWAITS - SYB: master..monSysWaits

SYBMON_TABLE_PERF - SYB: Table related data (performace/IO only)

SYBMON_TABLE_SPACE - SYB: Table related data (space only)

SYBMON_TABLE_STATS - SYB: Table with special/missing statistics

SYBMON_TEMPDBACTIVITY - SYB: master..monTempdbActivity

SYBMON_THREAD - SYB: master..monThread

SYBMON_THRESHOLD_EVENT - structure for threshold event

SYBMON_THRESHOLD_EVENT_D - details structure of threshold event

SYBMON_THR_EVT_TIME_RANGE - time range table for threshold event

SYBMON_WAITEVENTINFO - SYB: master..monWaitEventInfo

Return Table index