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.
Global templates
Collector Type | Template Name |
---|---|
Gateway | Sybase - Cache |
Sybase - Engine | |
Sybase - HeapMemory | |
Sybase - Network | |
Sybase - Statistics | |
Sybase - ThreadPool |
Global 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 engine has been running. | 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 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 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.
|
Application Type | The application type value to identify the adapter. For example, SYBASE. Warning: Do not change the default application type value. |