SAP ASE, originally known as Sybase SQL Server, is a relational model database server developed by Sybase Corporation, which is predominantly used on the Unix platform but is also available for Microsoft Windows. The administrators can monitor the Sybase database and track the availability and performance issues.

Prerequisite

  • Database and port(5002) are reachable from the gateway.
  • A gateway management profile mapped to a resource.
  • Create credentials with type Database before assigning a template to a resource. The Port, Connection Time Out, and Is Secure values are not used to create credentials.

Supported version

Sybase ASE 160 or higher.

Database discovery and monitoring

The administrator can deploy a gateway to support Sybase agentless monitoring.

Discovery using the gateway

The gateway establishes a connection to the database using the management profile and collects metrics from the templates and starts monitoring. To monitor Sybase, install gateway version 5.0.0 or later.

Use one of the following mechanisms to discover Sybase servers to add them to your inventory:

  • WMI
  • SSH
  • SNMP

Optionally, add a database server manually to the infrastructure inventory.

To add a resource manually to the inventory:

  1. Select Infrastructure.
  2. Click the Settings > Resource > Add.
  3. From the Add Device window, provide the required details such as Device Type and Management Profile.
  4. Click Save.

Prepare the resource to start monitoring

To monitor Sybase:

  • Associate appropriate database credentials to the discovered database.
  • Assign one or more database-specific global templates on the device.

Global templates and metrics

Global templates

Collector TypeTemplate Name
GatewaySybase - Cache
Sybase - Engine
Sybase - HeapMemory
Sybase - Network
Sybase - Statistics
Sybase - ThreadPool

Global metrics

OpsRamp MetricMetric Display NameUnitDescription
sybase.cache.object.cachedkbSybase Object Cachekilobytes(KB)The number of kilobytes occupied by the cache.
sybase.cache.procedure.loadsSybase Cache Procedure LoadscountThe number of stored procedures loaded into the cache.
sybase.cachepool.allocatedSybase Cachepool Allocatedkilobytes(KB)The number of bytes allocated for the pool.
sybase.cachepool.pages.readSybase Cachepool Pages ReadcountThe number of pages read into the pool.
sybase.cachepool.pages.touchedSybase Cachepool Pages TouchedcountThe number of pages currently used within the pool.
sybase.cachepool.writesSybase Cachepool WritescountThe number of write operations performed in this pool (one write operation can include multiple pages).
sybase.datacache.bufferpoolsSybase Datacache BufferpoolscountThe number of buffer pools within the cache.
sybase.datacache.cachesizeSybase Datacache Cache Sizekilobytes(KB)Total size of cache in kilobytes.
sybase.datacache.statusSybase Datacache Status-The Status of cache.
sybase.engine.connectionsSybase Engine ConnectionscountThe number of connections handled by the engine.
sybase.engine.cpu.timeSybase Engine CPU Timeseconds(s)The total time, in seconds, the engine has been running.
sybase.locks.activeSybase Active LockscountThe number of active locks.
sybase.locks.freeSybase Inactive LockscountThe number of inactive locks.
sybase.networkio.packets.receivedSybase NetworkIO Packets ReceivedcountThe number of packets received.
sybase.networkio.packets.sentSybase NetworkIO Packets SentcountThe number of packets sent.
sybase.netwrokio.bytes.receivedSybase NetworkIO Bytes Receivedmegabytes(MB)The number of bytes received by the server.
sybase.netwrokio.bytes.sentSybase NetworkIO Bytes Sentmegabytes(MB)The number of bytes sent by the server.
sybase.process.activity.heap.memory.allocatedSybase Process Activity Allocated Heap Memorykilobytes(KB)The amount of allocated heap memory.
sybase.process.activity.heap.memory.inuseSybase Process Activity In Use Heap Memorykilobytes(KB)The amount of heap memory currently in use.
sybase.process.activity.heap.memory.reservedSybase Process Activity Reserved Heap Memorykilobytes(KB)The amount of reserved heap memory.

Assign templates from setup

Assign Sybase templates to one or more resources for a selected client and modify the configuration parameters while assigning templates. For more information, see Assign Templates from Setup.

Assign templates at the device level

Applying Sybase templates at the device level helps assign one or more templates to a specific resource. You can change the configuration parameter default values while assigning the templates. For more information, see Assign Templates at the Device Level.

Resource template configuration parameters:

Configuration ParameterDescription
Connection Time OutThe maximum time to connect to the database. The driver waits for the specified time before timing out due to connection failure. The default time is 15000 milliseconds(ms).
Service Transport TypeTo configure the database at a secure end-point. The default type is In-secure. The connection is Secure when the data sent between the client and server is encrypted.
Service PortThe port number where the database is running. The connection is made to the specified port if you specify the port and the database name. The default port is 5002.
DB Instance NameThe name of the database to connect to. The default names are SYBASE and SYBASEASE.
  • If you have multiple database names with different ports, use the following syntax: `DBname1:Port1, DBname2:Port2,..` (Comma-separated). For example, if DBname 1 has credential set A and DBname 2 has credential set B, create separate credentials sets on the resource.
    Important! Create separate credential sets on the resource if databases consist of different users.
  • If you have multiple database names with the same port, use the following syntax: `DBname1, DBname2,..` (Comma-separated).
Application TypeThe application type value to identify the adapter. For example, SYBASE.

Warning: Do not change the default application type value.

Assign template from device management policies

Device management policies help manage resources. You can assign monitoring templates, knowledge base articles, and custom attributes using device management policies. The device management policy can be applied to one or a set of resources. For more information, see Creating Policies.

View resource metrics

The gateway monitors the application using the assigned templates and displays the results in graphical format. To view resource metrics, click the database resource name > resource Details > Metrics.

Troubleshooting

Verify the following if the graphs are not plotted correctly:

  • The resource is accessible and Telnet is established for the IP address and port.
  • Valid credentials are used for the resource.