Sybase ASE

Sybase ASE

Monitor Sybase ASE database for performance and health, using remote monitoring

Extension

Free trial Documentation

Product information
Release notes

Overview

This Dynatrace extension monitors Sybase Adaptive Server Enterprise's health and performance. It is a remote monitoring solution implemented as an extension for Dynatrace ActiveGates. Metrics are obtained from the Sybase ASE monitoring tables using the Dynatrace JDBC datasource.

This is intended for users, who:

Want to monitor the health and performance of their individual Sybase ASE databases
Look for a dedicated out-of-the-box dashboard for Sybase Monitoring

This extension enables you to:

Monitor Sybase ASE Databases, Devices, IO Controllers, and Cache Pools
Monitor database transactions, IO rates, and statement operations
Receive alerts on performance and health issues detected in your ASE
Take proactive actions based on anomalies detected in the database infrastructure before they affect your applications

Use cases

Operational monitoring of your Sybase Adaptive Server Enterprise setup.
Monitor resource utilization and receive alerts for detected anomalies; detect anomalies and alert on them.
Take pre-emptive measures to avoid service degradations.

Get started

Activate this extension on your Dynatrace tenant using the Dynatrace Hub.

This extension requires you to place the JDBC driver in the correct directory on their ActiveGate.

The jconn42.jar JDBC driver jar file can be found in your Sybase installation directory under:
<Sybase Installation Directory>/jConnect/classes/jconn42.jar

If you have jconn4.jar inside the directory above instead of jconn42.jar, download the updated version from the SAP marketplace following instructions in the SAP jConnect for JDBC Installation Guide

This Jar file must be placed in the libs directory of your ActiveGate:

Windows: C:\ProgramData\dynatrace\remotepluginmodule\agent\conf\userdata\lib
Linux: /var/lib/dynatrace/remotepluginmodule/agent/conf/userdata/libs

The extension also must be provided a user account to use when querying the monitoring views. This account can be created using the following statement:

CREATE LOGIN dynatrace WITH PASSWORD <password>;
GRANT ROLE mon_role TO dynatrace;

This user must be granted the mon_role role in order to read from the monitoring tables. Other user creation parameters can be found on the Sybase documentation.

Once your user is created and granted the correct permissions, you can create a monitoring configuration on an ActiveGate that can connect to the database. The host, port, connection string, and credentials are all required in order to connect to Sybase ASE. The connection string should be in a format similar to jdbc:sybase:Tds:<Ip Address>:<Port>

Details

The Sybase Adaptive Server Enterprise extension is built on top of the Extension Framework 2.0, utilizing the JDBC datasource to obtain metrics. The extension uses features added in Dynatrace version 1.300 so your ActiveGate must be running version 1.300 or higher. This extension is limited to metrics available in the Sybase monitoring views.

The extension package contains:

A recipe with SQL queries that the Dynatrace's extensions SQL datasource executes to get the metrics from ASE
Topology and relationship definitions for physical and logical entities that comprise the ASE
A sample dashboard offering the ASE monitoring overview and status
Unified analysis views for each entity, leveraging the topology model for interactive analysis

Summary of the database entities monitored: The following entities are monitored:

Database
Device
IO Controller
Cache Pool

Compatibility information

This extension supports remote monitoring via ActiveGate. It can't be installed on Sybase servers.
ActiveGate must be running version 1.300 or higher
Network connection between ActiveGate where this extension runs and monitored ASE is required.
This extension was tested on and supports Sybase ASE 15.7 and higher.

Q&A

Q: What is the DDU Consumption of this extension?

A: The formula for DDU consumption of the extension is:

( (40 * # of Databases)
+ (9  * # of Devices)
+ (11 * # of IO Controllers)
+ (14 * # of Cache Pools)
) * 525.6 DDUs/year

DDU cost above does not include any possible Log events or Custom events triggered by the extension. For more information on this, please visit the DDU log event cost and DDU custom event cost pages.

Subscribe to new releases

Copy to clipboard

Extension content

Content typeNumber of items included

screen metric tables

2

generic relationship

3

screen layout

4

dashboards

1

generic type

4

screen chart groups

19

screen properties

4

metric metadata

75

screen entities lists

3

Feature sets

Below is a complete list of the feature sets provided in this version. To ensure a good fit for your needs, individual feature sets can be activated and deactivated by your administrator during configuration.

Feature setsNumber of metrics included

Metric name	Metric key	Description	Unit
Number of Buffer Pools	sybase.cache.buffer_pools	Number of buffer pools within the cache	Count
Cache Searches	sybase.cache.searches.count	Cache searches directed to the cache	PerMinute
Data Cache Physical Reads	sybase.cache.physical_reads.count	Number of buffers read into the cache from disk	PerMinute
Data Cache Logical Reads	sybase.cache.logical_reads.count	Number of buffers retrieved from the cache	PerMinute
Data Cache Physical Writes	sybase.cache.physical_writes.count	Number of buffers written from the cache to disk	PerMinute
Data Cache Stalls	sybase.cache.io_stalls.count	Number of times I/O operations were delayed because no clean buffers were available in the wash area	PerMinute
Data Cache Size	sybase.cache.size	Total size of cache, in kilobytes	KiloByte
Data Cache APF Reads	sybase.cache.apf_reads.count	Number of asynchronous prefetch (APF) reads for this data cache	PerMinute
APF Limit	sybase.cache.apf_limit	The configured asynchronous prefetch limit for this pool	Percent
Cache Hit Rate	sybase.cache.hit_percent	The percent of reads that hit the Data Cache	Percent
Cache Miss Rate	sybase.cache.miss_percent	The percent of reads that missed the Data Cache and read from disk	Percent
IO Buffer Size	sybase.cache.io_buffer_size	Size (in bytes) of the I/O buffer for the pool	Byte
Allocated Bytes	sybase.cache.memory_allocated	Number of bytes allocated for the pool	KiloByte
Cache Pool Wash Size	sybase.cache.wash_size	The wash size, in kilobytes, for a memory pool	KiloByte

Metric name	Metric key	Description	Unit
Deadlocks	sybase.database.deadlocks.count	Total number of deadlocks that have occurred.	PerMinute
Connections	sybase.database.active_connections.count	Number of active inbound connections.	PerMinute
Transactions	sybase.database.transactions.count	Number of transactions run, server-wide.	PerMinute
Transaction Rollbacks	sybase.database.transaction_rollbacks.count	Total number of transactions rolled back	PerMinute
Select Operations	sybase.database.selects.count	Total number of select operations executed	PerMinute
Update Operations	sybase.database.updates.count	Total number of update operations executed	PerMinute
Insert Operations	sybase.database.inserts.count	Total number of insert operations executed	PerMinute
Delete Operations	sybase.database.deletes.count	Total number of delete operations executed	PerMinute
Merge Operations	sybase.database.merges.count	Total number of merge operations executed	PerMinute
Temporary Tables	sybase.database.temporary_tables.count	Total number of temporary tables created	PerMinute

Metric name	Metric key	Description	Unit
User CPU Busy	sybase.database.percent_user_busy	Percent User CPU Busy	Percent
System CPU Busy	sybase.database.percent_system_busy	Percent System CPU Busy	Percent
IO CPU Busy	sybase.database.percent_io_busy	Percent IO CPU Busy	Percent
Run Queue Length	sybase.database.run_queue_length	Run queue length	Count
Kernel Run Queue Length	sybase.database.kernel_run_queue_length	Kernel run queue length	Count
Outstanding disk I/Os	sybase.database.outstanding_disk_ios	Outstanding disk I/Os	Count
Disk Reads	sybase.database.disk_reads_per_second	Disk reads per second	PerSecond
Disk Writes	sybase.database.disk_writes_per_second	Disk writes per second	PerSecond
Network Reads	sybase.database.network_reads_per_second	Network reads per second	PerSecond
Network Writes	sybase.database.network_writes_per_second	Network writes per second	PerSecond

Metric name	Metric key	Description	Unit
Blocking Polls	sybase.io_controller.blocking_polls.count	Number of blocking polls	PerMinute
Non-Blocking Polls	sybase.io_controller.non_blocking_polls.count	Number of nonblocking polls	PerMinute
Event Polls	sybase.io_controller.blocking_event_polls.count	Number of polls returning an event	PerMinute
Non-Blocking Event Polls	sybase.io_controller.non_blocking_event_polls.count	Number of nonblocking polls returning an event	PerMinute
Full Polls	sybase.io_controller.full_polls.count	Number of polls returning the maximum number of events	PerMinute
Events Polled	sybase.io_controller.events.count	Number of events polled	PerMinute
Pending IOPS	sybase.io_controller.iops_pending.count	Number of pending I/O operations	PerMinute
Completed IOPS	sybase.io_controller.iops_completed.count	Number of completed I/O operations	PerMinute
Deferred IOPS	sybase.io_controller.iops_deferred.count	Number of I/O operations deferred or delayed	PerMinute
IO Controller Reads	sybase.io_controller.io_reads.count	Number of read or receive operations	PerMinute
IO Controller Writes	sybase.io_controller.io_writes.count	Number of write or send operations	PerMinute

Metric name	Metric key	Description	Unit
License Quantity	sybase.database.license_quantity	Quantity of licenses used for this feature.	Count
License Expiration	sybase.database.license_expiry	Time Until License Expiration	Second
Grace Period Expiration	sybase.database.grace_expiry	Time Until Grace Period Expiration	Second

Metric name	Metric key	Description	Unit
Database Status	sybase.database.database_status	The status of a database	Unspecified

Metric name	Metric key	Description	Unit
CPU Time	sybase.database.cpu_time.count	Total time, in seconds, the engine has been running.	Second
System CPU Time	sybase.database.system_cpu_time.count	Time, in seconds, the engine has been executing system database services.	Second
User CPU Time	sybase.database.user_cpu_time.count	Time, in seconds, the engine has been executing user commands.	Second
IO CPU Time	sybase.database.io_cpu_time.count	The amount of time, in seconds, the engine has been waiting for issued IOs to complete.	Second
IDLE CPU Time	sybase.database.idle_cpu_time.count	Time, in seconds, the engine has been in idle spin mode.	Second
Database Connections	sybase.database.connections.count	Number of connections this engine handles.	PerMinute
Disk IO Checks	sybase.database.disk_io_checks.count	Number of times the engine or disk controller (for process or threaded mode, respectively) checks for asynchronous disk I/O. In process mode, use i/o polling process count to modify the frequency of these checks.	PerMinute
Disk IO Polled	sybase.database.disk_io_polled.count	Number of times the engine or disk controller (for process or threaded mode, respectively) polls for completion of outstanding asynchronous disk I/O, which occurs when disk I/O checks indicate that asynchronous I/O has been posted, but is not yet complete.	PerMinute
Disk IO Completed	sybase.database.disk_io_completed.count	Number of asynchronous disk I/Os completed when the engine or disk controller (for process or threaded mode, respectively) polls for outstanding asynchronous disk I/O.	PerMinute
Context Switches	sybase.database.context_switches.count	Number of context switches.	PerMinute
Max GC Queue Size	sybase.database.max_gc_queue_size	Maximum number of items the SAP ASE server can queue for housekeeper garbage collection in this engine.	PerMinute
GC Pending Items	sybase.database.gc_pending_items	Number of items yet to be collected by housekeeper garbage collector on this engine.	PerMinute
GC Overflows	sybase.database.gc_overflows	Number of items that could not be queued to housekeeper garbage collector due to queue overflows.	PerMinute

Metric name	Metric key	Description	Unit
Device Size	sybase.device.size	Size of the device, in megabytes	MegaByte
Filesystem Size	sybase.device.fs_size	Size of the file system, in megabytes	MegaByte
Filesystem Free Space	sybase.device.fs_free	Amount of available free space, in megabytes, on the file system	MegaByte

Metric name	Metric key	Description	Unit
Packets Sent	sybase.database.network.io_packets_sent.count	Number of packets sent	PerMinute
Packets Received	sybase.database.network.io_packets_received.count	Number of packets received	PerMinute
Bytes Sent	sybase.database.network.io_bytes_sent.count	Number of bytes sent	PerMinute
Bytes Received	sybase.database.network.io_bytes_received.count	Number of bytes received	PerMinute

Metric name	Metric key	Description	Unit
Reads	sybase.device.io_reads.count	Number of reads from the device	PerMinute
APF Reads	sybase.device.io_apf_writes.count	Number of asynchronous prefetch (APF) reads from the device	PerMinute
Writes	sybase.device.io_write.count	Number of writes to the device	PerMinute
Mirrored Device IO Requests	sybase.device.io_mirrored_device_requests.count	Number of I/O requests to a mirrored device (if mirrored)	PerMinute
Mirrored Device Tasks Waiting	sybase.device.io_mirrored_device_tasks_waiting.count	Number of tasks forced to wait for synchronization of an I/O request to a mirrored device (if mirrored)	PerMinute
Device IO Time	sybase.device.io_time.count	Total amount of time (in milliseconds) spent waiting for I/O requests to be satisfied	MilliSecond

Related to Sybase ASE

SAP HANA Database (remote monitoring)

Easily understand the health and performance of your SAP HANA databases.

SAP JVM

Automatically and intelligently monitor, analyze, and optimize the performance of your virtual machine.

SAP GUI and ABAP Platform

Monitor your SAP Application Server's user transactions, RFC and jobs.

Full version history

To have more information on how to install the downloaded package, please follow the instructions on this page.

ReleaseDate

Full version history

New features:

Added sysdatabases status metric

Full version history

New features

This is the initial release of this extension. Looking for your feedback through Community!

Discover recent additions to Dynatrace

Problems

Analyze abnormal system behavior and performance problems detected by Davis AI.

Logs

Explore all your logs without writing a single query.

Security Investigator

Fast and precise forensics for security and logs on Grail data with DQL queries.

Business Flow

Track, analyze, and optimize your critical business processes.

Cost & Carbon Optimization

Track, analyze, and optimize your IT carbon footprint and public cloud costs.

Davis Anomaly Detection

Detect anomalies in timeseries using the Davis AI

Analyze your data

Understand your data better with deep insights and clear visualizations.

Notebooks

Create powerful, data-driven documents for custom analytics and collaboration.

Dashboards

Transform complex data into clear visualizations with custom dashboards.

Automate your processes

Turn data and answers into actions, securely, and at scale.

Workflows

Automate tasks in your IT landscape, remediate problems, and visualize processes

Jira

Create, query, comment, transition, and resolve Jira tickets within workflows.

Slack

Automate Slack messaging for security incidents, attacks, remediation, and more.

Secure your cloud application

See vulnerabilities and attacks in your environment.

Security Overview

Get a comprehensive overview of the security of your applications.

Code-Level Vulnerabilities

Detect vulnerabilities in your code in real time.

Threats & Exploits

Understand, triage, and investigate application security findings and alerts.

Are you looking for something different?

We have hundreds of apps, extensions, and other technologies to customize your environment

Leverage our newest innovations of Dynatrace Saas

Kick-start your app creation

Kick-start your app creation

Whether you’re a beginner or a pro, Dynatrace Developer has the tools and support you need to create incredible apps with minimal effort.

Go to Dynatrace Developer

Upgrading from Dynatrace Managed to SaaS

Upgrading from Dynatrace Managed to SaaS

Drive innovation, speed, and agility in your organization by seamlessly and securely upgrading.

Log Management and Analytics

Log Management and Analytics

Innovate faster and more efficiently with unified log management and log analytics for actionable insights and automation.