Sybase SQL Anywhere

Version 1

    This template assesses the performance of the server database by retrieving performance data from the monitoring tables.

    Prerequisites: Sybase SQL Anywhere Administrative Tools must be installed on the APM server, (Administrative Tools can be found on installation media during installation process).

    Credentials: Database user name and password with DBA authorities.


    Monitored Components

    Note: before using this template you should put correct database name (DBN property) in Connection String. Example:

    Driver={SQL Anywhere 12};DBN=demo;Host=${IP};Uid=${USER};Pwd=${PASSWORD};

    Note: Components without predetermined threshold values provide guidance such as "Use the lowest threshold possible" or "Use the highest threshold possible" to help you find a threshold appropriate for your application. For more information, see http://knowledgebase.solarwinds.com/kb/questions/2415.


    CPU usage (s)

    This monitor returns the CPU usage for the database server process. Values are in seconds. The value returned for this property is cumulative since the database server was started.


    Current Cache Size (kB)

    This monitor returns the current cache size, in kilobytes.


    Main Heap Pages

    This monitor returns the number of pages used for global server data structures.


    Pinned Cache Pages

    This monitor returns the number of pinned cache pages.


    Dirty Cache Pages

    This monitor returns the number of cache pages that are dirty (needing a write).


    Replaced Pages in Cache

    This monitor returns the number of pages in the cache that have been replaced.


    Disk Reads

    This monitor returns the number of disk reads.

    Note: By default, this monitor has the Count statistic as difference box checked. It will only show the new statistic since the last polling period.


    Free Space in System Dbspace (MB)

    This monitor returns the amount of free disk space for System dbspace in MB.


    Free Space in Translog Dbspace (MB)

    This monitor returns the amount of free disk space for Translog dbspace in MB.


    Free Space in Temporary Dbspace (MB)

    This monitor returns the amount of free disk space for Translog dbspace in MB.


    Current Connetions

    This monitor returns count of the number of licensed connections in use.


    Unique Connections

    This monitor returns the number of unique client network addresses connected to a network database server.


    Open HTTP Connections

    This monitor returns the number of HTTP connections that are currently open within the database server. They may be actively processing a request or waiting in a queue of long lived (keep-alive) connections.


    Actively Processing HTTP Connections

    This monitor returns the number of HTTP connections that are actively processing an HTTP request. An HTTP connection that has sent its response is not included.


    Open HTTPS Connections

    This monitor returns the number of HTTPS connections that are currently open within the database server. They may be actively processing a request or waiting in a queue of long lived (keep-alive) connections.


    Actively Processing HTTPS Connections

    This monitor returns the number of secure HTTPS connections that are actively processing an HTTPS request. An HTTPS connection that has sent its response is not included.


    Requests in Queue

    This monitor returns the number of requests that are currently queued up waiting for an available server thread. Returned value should be less than 5.


    Bytes Received

    This monitor returns the number of bytes received during client/server communications. This value is updated for HTTP and HTTPS connections.

    Note: By default, this monitor has the Count statistic as difference box checked. It will only show the new statistic since the last polling period.


    Bytes Sent

    This monitor returns the number of bytes sent during client/server communications. This value is updated for HTTP and HTTPS connections.

    Note: By default, this monitor has the Count statistic as difference box checked. It will only show the new statistic since the last polling period.


    Optimized Queries

    This monitor returns the number of requests fully optimized.

    Note: By default, this monitor has the Count statistic as difference box checked. It will only show the new statistic since the last polling period.


    Reused Queries

    This monitor returns the number of reused query plans.

    Note: By default, this monitor has the Count statistic as difference box checked. It will only show the new statistic since the last polling period.


    Bypassed Queries

    This monitor returns the number of requests reused from the plan cache.

    Note: By default, this monitor has the Count statistic as difference box checked. It will only show the new statistic since the last polling period.


    Cache Hits

    This monitor returns the number of database page lookups satisfied by finding the page in the cache.

    Note: By default, this monitor has the Count statistic as difference box checked. It will only show the new statistic since the last polling period.


    File Reads

    This monitor returns the current number of file reads those were issued by the server, but haven't yet completed.

    Note: By default, this monitor has the Count statistic as difference box checked. It will only show the new statistic since the last polling period.


    File Writes

    This monitor returns the current number of file writes those were issued by the server, but haven't yet completed.

    Note: By default, this monitor has the Count statistic as difference box checked. It will only show the new statistic since the last polling period.


    Pages Read from Disk

    This monitor returns the number of pages that have been read from disk.

    Note: By default, this monitor has the Count statistic as difference box checked. It will only show the new statistic since the last polling period.


    Pages Written to Disk

    This monitor returns the number of modified pages that have been written to disk.

    Note: By default, this monitor has the Count statistic as difference box checked. It will only show the new statistic since the last polling period.


    Free Pages in System Dbspace

    This monitor returns the number of free pages in the system dbspace. The FreePages property is only supported on databases created with version 8.0.0 or later.


    Locks

    This monitor returns the number of locks held by the database.

     

    Portions of this document were originally created by and are excerpted from the following sources:

    SAP Corporation, Copyright © 2012 SAP Corporation.  All rights reserved. Available at

    http://dcx.sybase.com/1101/en/dbadmin_en11/server-properties-perfapp.html and http://dcx.sybase.com/1200/en/dbadmin/database-properties-perfapp.html#connpoolcachedcount-db-prop.