Schedule demo
Home

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

ParameterDescription
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

ParameterDescription
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

ParameterDescription
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

ParameterDescription
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 ServerWhether the added SQL Anywhere server is a network server or not.

Loved by customers all over the world

"Standout Tool With Extensive Monitoring Capabilities"

★★★★★

It allows us to track crucial metrics such as response times, resource utilization, error rates, and transaction performance. The real-time monitoring alerts promptly notify us of any issues or anomalies, enabling us to take immediate action.

Reviewer Role: Research and Development

carlos-rivero
"I like Applications Manager because it helps us to detect issues present in our servers and SQL databases."
Carlos Rivero

Tech Support Manager, Lexmark

Trusted by over 6000+ businesses globally