SAP Sybase IQ

Supported OS Linux Windows

marketplace
Integration version1.0.0

Overview

SAP Sybase IQ, known for its high-speed analytics and extreme-scale data warehousing capabilities, is an essential tool for businesses requiring efficient data analysis and reporting. By integrating with Datadog, organizations can directly monitor their Sybase IQ environments, gaining insights into database performance, resource utilization, and operational health.

This integration collects live server statistics (CPU, disk, network usage, etc.) as metrics and events, allowing you to visualize database server health in Datadog.

Dashboards

This integration includes one out-of-the-box dashboard:

  • SAP Sybase IQ - Overview: Tracks CPU, network, disk I/O, connection, cache, and request statistics at the min_collection_interval.

Data Collected

Metrics

cds.sybase_iq.engine_stats.CpuTotalTime
(gauge)
Total CPU time in seconds consumed by the IQ server since last server startup
Shown as second
cds.sybase_iq.engine_stats.CpuUserTime
(gauge)
CPU user time in seconds consumed by the IQ server since last server startup
Shown as second
cds.sybase_iq.engine_stats.CpuSystemTime
(gauge)
CPU system time in seconds consumed by the IQ server since last server startup
Shown as second
cds.sybase_iq.engine_stats.MemoryAllocated
(gauge)
Allocated memory
Shown as megabyte
cds.sybase_iq.engine_stats.MemoryMaxAllocated
(gauge)
Maximum allocated memory
Shown as megabyte
cds.sybase_iq.engine_stats.ThreadsFree
(gauge)
Number of free IQ threads
cds.sybase_iq.engine_stats.ThreadsInUse
(gauge)
Number of IQ threads in use
cds.sybase_iq.connection_stats.ConnectionsActive
(gauge)
Number of active connections
Shown as connection
cds.sybase_iq.connection_stats.ConnectionsTotalConnections
(gauge)
Total number of connections since server startup
Shown as connection
cds.sybase_iq.connection_stats.ConnectionsTotalDisconnections
(gauge)
Total number of disconnections since server startup
Shown as connection
cds.sybase_iq.connection_stats.MaxConnections
(gauge)
The maximum number of concurrent connections to the server
Shown as connection
cds.sybase_iq.connection_cursor_stats.ConnectedTime
(gauge)
Total time connections have been connected
Shown as second
cds.sybase_iq.connection_cursor_stats.DeclaredCursor
(gauge)
Declared cursors
Shown as cursor
cds.sybase_iq.connection_cursor_stats.CursorOpen
(gauge)
Open cursors
Shown as cursor
cds.sybase_iq.network_stats.BytesReceived
(gauge)
Bytes received by server
Shown as byte
cds.sybase_iq.network_stats.BytesReceivedUncomp
(gauge)
Bytes received after decompression
Shown as byte
cds.sybase_iq.network_stats.BytesSent
(gauge)
Bytes sent to client
Shown as byte
cds.sybase_iq.network_stats.BytesSentUncomp
(gauge)
Bytes sent before compression
Shown as byte
cds.sybase_iq.network_stats.PacketsReceived
(gauge)
Packets received by server
Shown as packet
cds.sybase_iq.network_stats.PacketsSent
(gauge)
Packets sent to client
Shown as packet
cds.sybase_iq.network_stats.TotalBuffers
(gauge)
Total communication buffers
Shown as buffer
cds.sybase_iq.network_stats.StreamsUsed
(gauge)
Number of engine streams in use
cds.sybase_iq.network_stats.FreeBuffers
(gauge)
Free communication buffers
Shown as buffer
cds.sybase_iq.catalog_cache_stats.MaxCacheSize
(gauge)
Maximum cache size in kilobytes
Shown as kilobyte
cds.sybase_iq.catalog_cache_stats.CurrentCacheSize
(gauge)
Current cache size in kilobytes
Shown as kilobyte
cds.sybase_iq.catalog_cache_stats.CacheRead
(gauge)
Cache reads
Shown as read
cds.sybase_iq.catalog_cache_stats.CacheHits
(gauge)
Cache hits
Shown as hit
cds.sybase_iq.catalog_cache_stats.CachePinned
(gauge)
Pinned cache pages
Shown as page
cds.sybase_iq.catalog_cache_stats.CachePinnedPercent
(gauge)
Percentage of pinned cache
Shown as percent
cds.sybase_iq.catalog_cache_stats.CacheInUsePercent
(gauge)
Percentage of cache in use
Shown as percent
cds.sybase_iq.catalog_cache_stats.DirtyPagesPercent
(gauge)
Percentage of cache pages that are dirty
Shown as percent
cds.sybase_iq.main_cache_stats.MainCacheCurrentSize
(gauge)
Main cache current size
Shown as megabyte
cds.sybase_iq.main_cache_stats.MainCacheFinds
(gauge)
Main cache total number of lookup requests
cds.sybase_iq.main_cache_stats.MainCacheHits
(gauge)
Main cache total number of hits
Shown as hit
cds.sybase_iq.main_cache_stats.MainCachePagesPinned
(gauge)
Main cache number of pages pinned
Shown as page
cds.sybase_iq.main_cache_stats.MainCachePagesPinnedPercentage
(gauge)
Percentage of main cache pages pinned
Shown as percent
cds.sybase_iq.main_cache_stats.MainCachePagesInUsePercentage
(gauge)
Percentage of main cache pages in use
Shown as percent
cds.sybase_iq.main_cache_stats.MainCachePagesDirtyPercentage
(gauge)
Percentage of main cache pages dirtied
Shown as percent
cds.sybase_iq.temp_cache_stats.TempCacheCurrentSize
(gauge)
Temporary cache current size in megabytes
Shown as megabyte
cds.sybase_iq.temp_cache_stats.TempCacheFinds
(gauge)
Temporary cache total number of lookup requests
cds.sybase_iq.temp_cache_stats.TempCacheHits
(gauge)
Temporary cache total number of hits
Shown as hit
cds.sybase_iq.temp_cache_stats.TempCachePagesPinned
(gauge)
Temporary cache number of pages pinned
Shown as page
cds.sybase_iq.temp_cache_stats.TempCachePagesPinnedPercentage
(gauge)
Percentage of temporary cache pages pinned
Shown as percent
cds.sybase_iq.temp_cache_stats.TempCachePagesInUsePercentage
(gauge)
Percentage of temporary cache pages in use
Shown as percent
cds.sybase_iq.temp_cache_stats.TempCachePagesDirtyPercentage
(gauge)
Percentage of temporary cache pages dirtied
Shown as percent
cds.sybase_iq.operation_stats.OperationsActive
(gauge)
Number of active concurrent operations admitted by IQ resource governor
Shown as operation
cds.sybase_iq.operation_stats.OperationsWaiting
(gauge)
Number of operations waiting for IQ resource governor
Shown as operation
cds.sybase_iq.request_stats.NumCommit
(gauge)
Number of commit requests
Shown as commit
cds.sybase_iq.request_stats.CompletedReq
(gauge)
Completed requests
Shown as request
cds.sybase_iq.request_stats.Req
(gauge)
Requests
Shown as request
cds.sybase_iq.request_stats.RequestsReceived
(gauge)
Requests received by server
Shown as request
cds.sybase_iq.request_stats.Rlbk
(gauge)
Rollback requests handled
Shown as request
cds.sybase_iq.request_stats.ActiveReq
(gauge)
Active requests
Shown as request
cds.sybase_iq.request_stats.UnschReq
(gauge)
Unscheduled requests
Shown as request
cds.sybase_iq.catalog_disk_stats.DiskReads
(gauge)
Disk reads
Shown as read
cds.sybase_iq.catalog_disk_stats.DiskWrites
(gauge)
Disk writes
Shown as write
cds.sybase_iq.main_disk_stats.MainStoreDiskReads
(gauge)
Number of kilobytes read from main store
Shown as kilobyte
cds.sybase_iq.main_disk_stats.MainStoreDiskWrites
(gauge)
Number of kilobytes written to main store
Shown as kilobyte
cds.sybase_iq.temp_disk_stats.TempStoreDiskReads
(gauge)
Number of kilobytes read from temp store
Shown as kilobyte
cds.sybase_iq.temp_disk_stats.TempStoreDiskWrites
(gauge)
Number of kilobytes written to temp store
Shown as kilobyte
cds.sybase_iq.disk_stats.DiskRetryRead
(gauge)
Disk read retries
cds.sybase_iq.disk_stats.DiskRetryWrite
(gauge)
Disk write retries
cds.sybase_iq.disk_stats.CurrRead
(gauge)
Active disk read requests
Shown as request
cds.sybase_iq.disk_stats.CurrWrite
(gauge)
Active disk write requests
Shown as request
cds.sybase_iq.disk_stats.AvailIO
(gauge)
Number of available I/O control blocks
cds.sybase_iq.dbspace_stats.Usage
(gauge)
Percent of dbspace currently in use by all files in the dbspace.
Shown as percent
cds.sybase_iq.dbspace_stats.TotalSize
(gauge)
Total size of all files in the dbspace
Shown as byte
cds.sybase_iq.dbspace_stats.Reserve
(gauge)
Total reserved space that can be added to all files in the dbspace
Shown as byte
cds.sybase_iq.dbspace_stats.NumFiles
(gauge)
Number of files in the dbspace
cds.sybase_iq.dbspace_stats.NumRWFiles
(gauge)
Number of read/write files in the dbspace

Service Checks

cds.sybase_iq.can_connect

Returns CRITICAL if the user configurations are invalid or Sybase IQ server authentication fails. Returns OK otherwise.

Statuses: ok, critical

Support

For support or feature requests, contact Crest Data through the following channels:

Troubleshooting

Need help? Contact Datadog support.


This application is made available through the Marketplace and is supported by a Datadog Technology Partner. Click Here to purchase this application.