Supported Versions
Sybase ASE 160 or higher

This describes the discovery and monitoring setup for the Sybase database.

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.
  • Gateway version 5.0.0 or later.

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.

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:

  1. Select Infrastructure and click Resources.
  2. Click the Settings icon on the top-right and click Add.
  3. On the Add Device page, enter the Device Type and any other information you want to enter.
  4. Click Save.

Prepare the resource for monitoring

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

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

If you have database monitoring issues, verify:

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

Global templates

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

Global metrics

OpsRamp MetricMetric Display NameUnit
sybase.cache.object.cachedkb

The number of kilobytes occupied by the cache.
Sybase Object Cachekilobytes(KB)
sybase.cache.procedure.loads

The number of stored procedures loaded into the cache.
Sybase Cache Procedure Loadscount
sybase.cachepool.allocated

The number of bytes allocated for the pool.
Sybase Cachepool Allocatedkilobytes(KB)
sybase.cachepool.pages.read

The number of pages read into the pool.
Sybase Cachepool Pages Readcount
sybase.cachepool.pages.touched

The number of pages currently used within the pool.
Sybase Cachepool Pages Touchedcount
sybase.cachepool.writes

The number of write operations performed in this pool (one write operation can include multiple pages).
Sybase Cachepool Writescount
sybase.datacache.bufferpools

The number of buffer pools within the cache.
Sybase Datacache Bufferpoolscount
sybase.datacache.cachesize

Total size of cache in kilobytes.
Sybase Datacache Cache Sizekilobytes(KB)
sybase.datacache.status

The Status of cache.
Sybase Datacache Status-
sybase.engine.connections

The number of connections handled by the engine.
Sybase Engine Connectionscount
sybase.engine.cpu.time

The total time, in seconds, the engine has been running.
Sybase Engine CPU Timeseconds(s)
sybase.locks.active

The number of active locks.
Sybase Active Lockscount
sybase.locks.free

The number of inactive locks.
Sybase Inactive Lockscount
sybase.networkio.packets.received

The number of packets received.
Sybase NetworkIO Packets Receivedcount
sybase.networkio.packets.sent

The number of packets sent.
Sybase NetworkIO Packets Sentcount
sybase.netwrokio.bytes.received

The number of bytes received by the server.
Sybase NetworkIO Bytes Receivedmegabytes(MB)
sybase.netwrokio.bytes.sent

The number of bytes sent by the server.
Sybase NetworkIO Bytes Sentmegabytes(MB)
sybase.process.activity.heap.memory.allocated

The amount of allocated heap memory.
Sybase Process Activity Allocated Heap Memorykilobytes(KB)
sybase.process.activity.heap.memory.inuse

The amount of heap memory currently in use.
Sybase Process Activity In Use Heap Memorykilobytes(KB)
sybase.process.activity.heap.memory.reserved

The amount of reserved heap memory.
Sybase Process Activity Reserved Heap Memorykilobytes(KB)

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. 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.