Sybase


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:

Select Infrastructure and click Resources.
Click the Settings icon on the top-right and click Add.
On the Add Device page, enter the Device Type and any other information you want to enter.
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.

Supported templates

Collector Type	Template Name
Gateway	Sybase - Cache
	Sybase - Engine
	Sybase - HeapMemory
	Sybase - Network
	Sybase - Statistics
	Sybase - ThreadPool

Supported metrics

Metric	Metric Display Name	Unit
sybase.cache.object.cachedkb The number of kilobytes occupied by the cache.	Sybase Object Cache	kilobytes(KB)
sybase.cache.procedure.loads The number of stored procedures loaded into the cache.	Sybase Cache Procedure Loads	count
sybase.cachepool.allocated The number of bytes allocated for the pool.	Sybase Cachepool Allocated	kilobytes(KB)
sybase.cachepool.pages.read The number of pages read into the pool.	Sybase Cachepool Pages Read	count
sybase.cachepool.pages.touched The number of pages currently used within the pool.	Sybase Cachepool Pages Touched	count
sybase.cachepool.writes The number of write operations performed in this pool (one write operation can include multiple pages).	Sybase Cachepool Writes	count
sybase.datacache.bufferpools The number of buffer pools within the cache.	Sybase Datacache Bufferpools	count
sybase.datacache.cachesize Total size of cache in kilobytes.	Sybase Datacache Cache Size	kilobytes(KB)
sybase.datacache.status The Status of cache.	Sybase Datacache Status	-
sybase.engine.connections The number of connections handled by the engine.	Sybase Engine Connections	count
sybase.engine.cpu.time The total time, in seconds, the engineran.	Sybase Engine CPU Time	seconds(s)
sybase.locks.active The number of active locks.	Sybase Active Locks	count
sybase.locks.free The number of inactive locks.	Sybase Inactive Locks	count
sybase.networkio.packets.received The number of packets received.	Sybase NetworkIO Packets Received	count
sybase.networkio.packets.sent The number of packets sent.	Sybase NetworkIO Packets Sent	count
sybase.netwrokio.bytes.received The number of bytes received by the server.	Sybase NetworkIO Bytes Received	megabytes(MB)
sybase.netwrokio.bytes.sent The number of bytes sent by the server.	Sybase NetworkIO Bytes Sent	megabytes(MB)
sybase.process.activity.heap.memory.allocated The amount of allocated heap memory.	Sybase Process Activity Allocated Heap Memory	kilobytes(KB)
sybase.process.activity.heap.memory.inuse The amount of heap memory currently in use.	Sybase Process Activity In Use Heap Memory	kilobytes(KB)
sybase.process.activity.heap.memory.reserved The amount of reserved heap memory.	Sybase Process Activity Reserved Heap Memory	kilobytes(KB)

Assign templates from setup

Assign Sybase templates to one or more resources for a selected client and change 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 Parameter	Description
Connection Time-out	The 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 Type	To 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 Port	The 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 Name	The 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 Type	The application type value to identify the adapter. For example, SYBASE. Warning: Do not change the default application type value.