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 Database server properties and Database properties.
OID | Type | Name | Statistic |
---|---|---|---|
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 |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |