--- title: SAP Sybase IQ description: Monitor the performance and usage of SAP Sybase IQ databases. breadcrumbs: Docs > Integrations > SAP Sybase IQ --- # SAP Sybase IQ Supported OS marketplaceIntegration version1.0.0 SAP Sybase ASE - OverviewSAP Sybase ASE - Overview (Disk & Connection)SAP Sybase ASE - Overview (Cache & DBSpace) ## Overview{% #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{% #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{% #data-collected %} ### Metrics{% #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{% #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{% #support %} For support or feature requests, contact Crest Data through the following channels: - Support email: [datadog.integrations@crestdata.ai](mailto:datadog.integrations@crestdata.ai) - Sales email: [datadog-sales@crestdata.ai](mailto:datadog-sales@crestdata.ai) - Website: [crestdata.ai](https://www.crestdata.ai/) - FAQ: [Crest Data Datadog Marketplace Integrations FAQ](https://docs.crestdata.ai/datadog-integrations-readme/Crest_Data_Datadog_Integrations_FAQ.pdf) ### Troubleshooting{% #troubleshooting %} Need help? Contact [Datadog support](https://docs.datadoghq.com/help/). This application is made available through the Marketplace and is supported by a Datadog Technology Partner. Click Here to purchase this application.