次の表は、SQL Anywhere SNMP Extension Agent を使用して検索できるデータベース・サーバ統計の OID と名前を示します。
値 n は、sasnmp.ini ファイル内のデータベース番号です。
データベース・サーバ統計の詳細については、データベース・サーバ・プロパティとデータベース・プロパティを参照してください。
| OID | 型 | 名前 | 統計情報 |
|---|---|---|---|
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatActiveReq | ActiveReq |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatAvailIO | AvailIO |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatBytesReceived | BytesReceived |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatBytesReceivedUncomp | BytesReceivedUncomp |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatBytesSent | BytesSent |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatBytesSentUncomp | BytesSentUncomp |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatCacheHits | CacheHits |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatCachePinned | CachePinned |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatCacheRead | CacheRead |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatCacheReplacements | CacheReplacements |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatCurrentCacheSize | CurrentCacheSize |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatDiskRead | DiskRead |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatFreeBuffers | FreeBuffers |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatInternal | Internal |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatUniqueClientAddresses | UniqueClientAddresses |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatLockedHeapPages | LockedHeapPages |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatMainHeapBytes | MainHeapBytes |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatMainHeapPages | MainHeapPages |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatMapPhysicalMemoryEng | MapPhysicalMemoryEng |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatMaxCacheSize | MaxCacheSize |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatMinCacheSize | MinCacheSize |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatMultiPacketsReceived | MultiPacketsReceived |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatMultiPacketsSent | MultiPacketsSent |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatPacketsReceived | PacketsReceived |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatPacketsReceivedUncomp | PacketsReceivedUncomp |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatPacketsSent | PacketsSent |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatPacketsSentUncomp | PacketsSentUncomp |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatPeakCacheSize | PeakCacheSize |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatRemoteputWait | RemoteputWait |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatReq | Req |
| 1.3.6.1.4.1.897.2.1.1.n | Counter64 | srvStatSendFail | SendFail |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatTotalBuffers | TotalBuffers |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatUnschReq | UnschReq |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatInternal | Internal |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatCacheFile | CacheFile |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatCacheFileDirty | CacheFileDirty |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatCacheAllocated | CacheAllocated |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatCachePanics | CachePanics |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatCacheFree | CacheFree |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatCacheScavenges | CacheScavenges |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatCacheScavengeVisited | CacheScavengeVisited |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatLockedCursorPages | LockedCursorPages |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatQueryHeapPages | QueryHeapPages |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatCarverHeapPages | CarverHeapPages |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatHeapsRelocatable | HeapsRelocatable |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatHeapsLocked | HeapsLocked |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatHeapsQuery | HeapsQuery |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatHeapsCarver | HeapsCarver |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatMultiPageAllocs | MultiPageAllocs |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatRequestsReceived | RequestsReceived |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatExchangeTasks | ExchangeTasks |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatClientStmtCacheHits | ClientStmtCacheHits |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatClientStmtCacheMisses | ClientStmtCacheMisses |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatQueryMemActiveCurr | QueryMemActiveCurr |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatQueryMemActiveEst | QueryMemActiveEst |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatQueryMemGrantWaiting | QueryMemGrantWaiting |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatQueryMemGrantRequested | QueryMemGrantRequested |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatQueryMemGrantWaited | QueryMemGrantWaited |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatQueryMemGrantFailed | QueryMemGrantFailed |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatQueryMemGrantGranted | QueryMemGrantGranted |
| 1.3.6.1.4.1.897.2.1.1.n | Integer32 | srvStatQueryMemExtraAvail | QueryMemExtraAvail |
| Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |