SQL Anywhere MIB server statistics

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
1.3.6.1.4.1.897.2.1.1.n Integer32 srvStatThreadDeadlocksAvoided ThreadDeadlocksAvoided
1.3.6.1.4.1.897.2.1.1.n Integer32 srvStatThreadDeadlocksReported ThreadDeadlocksReported