SQL Anywhere Monitoring User Guide

To ensure peak health and performance, SQL Anywhere monitoring tools that are perceptive and sensitive to errors are employed by businesses. Applications Manager's SQL Anywhere monitor is one such tool which can help you monitor and maintain your databases and IT environments with minimal manual intervention.

Adding a SQL Anywhere monitor

Follow the steps given below to create a new SQL Anywhere monitor:

  1. Click on New Monitor link. Select SQL Anywhere under Database Servers category.
  2. Specify the Display Name of the SQL Anywhere Server.
  3. Enter the Hostname of the server on which SQL Anywhere is running.  
  4. Specify the Port at which SQL Anywhere is running. The Default Port is 2638.
  5. If you choose the Use Below Credentials option, then enter the credentials - UserName and Password of the SQL Anywhere Instance.
    • UserName - Name of the User who has read permission.  
    • Password - Password of the above user.
  6. If you choose the Select from credential list option, then select the respective credential from preconfigured credential list.
  7. Specify the Polling Interval in minutes.
  8. Choose the Monitor Group with which you want to associate the SQL Anywhere to, from the combo box (optional). You can choose multiple groups to associate your monitor.
  9. Click Add Monitor(s). This discovers the SQL Anywhere from the network and starts monitoring it.

Monitored Parameters

Go to the Monitors Category View by clicking the Monitors tab. Click on SQL Anywhere under the Database Servers table. Displayed is the SQL Anywhere bulk configuration view distributed into three tabs:

  • Availability tab, gives the Availability history for the past 24 hours or 30 days.
  • Performance tab gives the Health Status and events for the past 24 hours or 30 days.
  • List view enables you to perform bulk admin configurations.

On clicking a monitor from the list, you'll be taken to the SQL Anywhere monitor dashboard. It has 4 tabs-

Overview

Parameter Description
CONNECTION STATISTICS  
Total Connection Count  Total number of connections made to the SQL Anywhere server.
HTTP Connections  Number of HTTP connections made to the SQL Anywhere server.
HTTPS Connections  Number of HTTPS connections made to the SQL Anywhere server.
SESSION ACTIVITY  
Active HTTP Requests  Number of active HTTP requests.
Active HTTPS Requests  Number of active HTTPS requests.
Unscheduled Requests  Number of unscheduled requests.
Active Sessions  Total number of active sessions.
CACHE USAGE  
Current Cache Size  Size of the cache memory currently used in KB.
Max Cache Size  The maximum allowed cache size in KB.
Peak Cache Size  The largest value the cache has reached in the current session in KB.
CACHE STATISTICS  
Cache Dirty  Number of cache pages that are dirty i.e. that needs to be written.
Cache Pinned  Number of pinned cache pages.
Cache Replacements  Number of pages in the cache that have been replaced.
Main Heap Pages  Number of pages used for global server data structures.

Databases

Parameter Description
Databases  
Name  Name of the database.
Total Size(MB)  Total size of the database in MB.
Used(MB)  Size of the used database memory in MB.
Free(MB)  Size of the free database memory in MB.
Used(%)  Size of the used database memory in %.
Disk Reads/Min  Number of disk reads in a minute.
Disk Writes/Min  Number of disk writes in a minute.
Connection Count  Number of connections made to the database.
Locks Count  Number of locks held on the database.
Database Details  Click one of the database names in the Databases table to view database details.
Dbspace and File Details  
Dbspace Name  Name of the dbspace.
File Name  Name of the file inside the dbspace.
Total Disk Size(MB)  Total size of the disk for dbspace in MB.
Disk Free(MB)  Free disk space for dbspace in MB.
Disk Free(%)  Free disk space for dbspace in %.
Total File Size(MB)  Total size of the file in MB.
File Used(MB)  Total size of the file used in MB.
File Free(MB)  Total size of the file which is free in MB.
File Used(%)  Size of the used file in %.
DB Mirroring Details  
Name  Name of the database.
Mirror Mode  Mode of mirroring.
Mirror State  Status of the mirrored database—whether it is synchronized or not.
Partner State  Status of the partner server—whether it is connected or not.
Arbiter State  Status of the arbiter server—whether it is connected or not.

Connections

Parameter Description
DB Connections  
DB Name  Name of the database.
Connection ID  Unique ID number of the connection. 
Connection Name  Name of the connection.
Connection Host  Name of the host.
User  Name of the user.
Communication Link     Type of communication link.
Last Request Type     Type of request that was previously processed.
Blocked On    Connection ID of the user who blocked the database.


Configurations

Parameter Description
CONFIGURATION PROPERTIES  
Sybase Version  Version of the SQL Anywhere server used.
Server Name  Name of the SQL Anywhere server used.
Server Language  Language used in the SQL Anywhere server.
Start up time  Time at which the server started running.
License Seats  Number of license seats or processors.
License Type  Type of license.
Licensed Company  Name of the licensed company.
Licensed User  Name of the licensed user.
Network Server  Whether the added SQL Anywhere server is a network server or not.