This table lists the OIDs and names of the database server statistics that can be retrieved using the SQL Anywhere SNMP Extension Agent.
The value n is the database number in the sasnmp.ini file.
For more information about the database server statistics, see Server-level properties, and Database-level properties.
| OID | Type | Name | Statistic |
|---|---|---|---|
| 1.3.6.1.4.1.897.2.1.1.1.n | Integer32 | srvStatActiveReq | ActiveReq |
| 1.3.6.1.4.1.897.2.1.1.2.n | Integer32 | srvStatAvailIO | AvailIO |
| 1.3.6.1.4.1.897.2.1.1.3.n | Counter64 | srvStatBytesReceived | BytesReceived |
| 1.3.6.1.4.1.897.2.1.1.4.n | Counter64 | srvStatBytesReceivedUncomp | BytesReceivedUncomp |
| 1.3.6.1.4.1.897.2.1.1.5.n | Counter64 | srvStatBytesSent | BytesSent |
| 1.3.6.1.4.1.897.2.1.1.6.n | Counter64 | srvStatBytesSentUncomp | BytesSentUncomp |
| 1.3.6.1.4.1.897.2.1.1.7.n | Counter64 | srvStatCacheHitsEng | CacheHitsEng |
| 1.3.6.1.4.1.897.2.1.1.8.n | Integer32 | srvStatCachePinned | CachePinned |
| 1.3.6.1.4.1.897.2.1.1.9.n | Counter64 | srvStatCacheReadEng | CacheReadEng |
| 1.3.6.1.4.1.897.2.1.1.10.n | Counter64 | srvStatCacheReplacements | CacheReplacements |
| 1.3.6.1.4.1.897.2.1.1.11.n | Integer32 | srvStatCurrentCacheSize | CurrentCacheSize |
| 1.3.6.1.4.1.897.2.1.1.12.n | Counter64 | srvStatDiskReadEng | DiskReadEng |
| 1.3.6.1.4.1.897.2.1.1.13.n | Integer32 | srvStatFreeBuffers | FreeBuffers |
| 1.3.6.1.4.1.897.2.1.1.14.n | Integer32 | srvStatInternal | Internal |
| 1.3.6.1.4.1.897.2.1.1.15.n | Integer32 | srvStatUniqueClientAddresses | UniqueClientAddresses |
| 1.3.6.1.4.1.897.2.1.1.16.n | Integer32 | srvStatLockedHeapPages | LockedHeapPages |
| 1.3.6.1.4.1.897.2.1.1.17.n | Counter64 | srvStatMainHeapBytes | MainHeapBytes |
| 1.3.6.1.4.1.897.2.1.1.18.n | Integer32 | srvStatMainHeapPages | MainHeapPages |
| 1.3.6.1.4.1.897.2.1.1.19.n | Integer32 | srvStatMapPhysicalMemoryEng | MapPhysicalMemoryEng |
| 1.3.6.1.4.1.897.2.1.1.20.n | Integer32 | srvStatMaxCacheSize | MaxCacheSize |
| 1.3.6.1.4.1.897.2.1.1.21.n | Integer32 | srvStatMinCacheSize | MinCacheSize |
| 1.3.6.1.4.1.897.2.1.1.22.n | Counter64 | srvStatMultiPacketsReceived | MultiPacketsReceived |
| 1.3.6.1.4.1.897.2.1.1.23.n | Counter64 | srvStatMultiPacketsSent | MultiPacketsSent |
| 1.3.6.1.4.1.897.2.1.1.24.n | Counter64 | srvStatPacketsReceived | PacketsReceived |
| 1.3.6.1.4.1.897.2.1.1.25.n | Counter64 | srvStatPacketsReceivedUncomp | PacketsReceivedUncomp |
| 1.3.6.1.4.1.897.2.1.1.26.n | Counter64 | srvStatPacketsSent | PacketsSent |
| 1.3.6.1.4.1.897.2.1.1.27.n | Counter64 | srvStatPacketsSentUncomp | PacketsSentUncomp |
| 1.3.6.1.4.1.897.2.1.1.28.n | Integer32 | srvStatPeakCacheSize | PeakCacheSize |
| 1.3.6.1.4.1.897.2.1.1.29.n | Integer32 | srvStatRemoteputWait | RemoteputWait |
| 1.3.6.1.4.1.897.2.1.1.30.n | Integer32 | srvStatReq | Req |
| 1.3.6.1.4.1.897.2.1.1.31.n | Counter64 | srvStatSendFail | SendFail |
| 1.3.6.1.4.1.897.2.1.1.32.n | Integer32 | srvStatTotalBuffers | TotalBuffers |
| 1.3.6.1.4.1.897.2.1.1.33.n | Integer32 | srvStatUnschReq | UnschReq |
| 1.3.6.1.4.1.897.2.1.1.34.n | Integer32 | srvStatInternal | Internal |
| 1.3.6.1.4.1.897.2.1.1.35.n | Integer32 | srvStatCacheFile | CacheFile |
| 1.3.6.1.4.1.897.2.1.1.36.n | Integer32 | srvStatCacheFileDirty | CacheFileDirty |
| 1.3.6.1.4.1.897.2.1.1.37.n | Integer32 | srvStatCacheAllocated | CacheAllocated |
| 1.3.6.1.4.1.897.2.1.1.38.n | Integer32 | srvStatCachePanics | CachePanics |
| 1.3.6.1.4.1.897.2.1.1.39.n | Integer32 | srvStatCacheFree | CacheFree |
| 1.3.6.1.4.1.897.2.1.1.40.n | Integer32 | srvStatCacheScavenges | CacheScavenges |
| 1.3.6.1.4.1.897.2.1.1.41.n | Integer32 | srvStatCacheScavengeVisited | CacheScavengeVisited |
| 1.3.6.1.4.1.897.2.1.1.42.n | Integer32 | srvStatLockedCursorPages | LockedCursorPages |
| 1.3.6.1.4.1.897.2.1.1.43.n | Integer32 | srvStatQueryHeapPages | QueryHeapPages |
| 1.3.6.1.4.1.897.2.1.1.44.n | Integer32 | srvStatCarverHeapPages | CarverHeapPages |
| 1.3.6.1.4.1.897.2.1.1.45.n | Integer32 | srvStatHeapsRelocatable | HeapsRelocatable |
| 1.3.6.1.4.1.897.2.1.1.46.n | Integer32 | srvStatHeapsLocked | HeapsLocked |
| 1.3.6.1.4.1.897.2.1.1.47.n | Integer32 | srvStatHeapsQuery | HeapsQuery |
| 1.3.6.1.4.1.897.2.1.1.48.n | Integer32 | srvStatHeapsCarver | HeapsCarver |
| 1.3.6.1.4.1.897.2.1.1.49.n | Integer32 | srvStatMultiPageAllocs | MultiPageAllocs |
| 1.3.6.1.4.1.897.2.1.1.50.n | Integer32 | srvStatRequestsReceived | RequestsReceived |
| 1.3.6.1.4.1.897.2.1.1.51.n | Integer32 | srvStatExchangeTasks | ExchangeTasks |
| 1.3.6.1.4.1.897.2.1.1.52.n | Integer32 | srvStatClientStmtCacheHits | ClientStmtCacheHits |
| 1.3.6.1.4.1.897.2.1.1.53.n | Integer32 | srvStatClientStmtCacheMisses | ClientStmtCacheMisses |