Page History
...
- About the Statistics tab
- How the Statistics tab is structured
- About the entities you can examine in the Statistics tab
- How the Statistics tab can help you identify performance problems
Anchor | ||||
---|---|---|---|---|
|
...
The entities displayed in the Association area are related to the selected entity displayed in the Main area.
About the Main area in the Statistics tab
The Main area shows comprehensive information on the selected entity. You can choose from several views to examine the entity from different angles. For example, the Instance entity reports on Disk I/O, Memory and Lock Management.
About the Association area in the Statistics tab
The Association area displays relevant information on the entities associated with the selected entity (displayed in the Tab heading in the Main area) in a table format. For example, it is possible to associate to all Engines or Devices that are related to a specific Instance, by selecting an entity from the Association controls list. Notice that some entities, show additional information on the associated entities in different tabs. The tabs are located above the Association area table. Clicking on a tab displays different table columns showing different information for the associated entities.
...
In the Association area, click the row of the device you want to view detailed information for. The Tab heading indicates the newly selected entity; the Main area displays statistical information on the device entity you drilled down to, and the Association area shows information on the associated performance counters.
Anchor | ||||
---|---|---|---|---|
|
The Statistics tab displays information on the following different entities in the Association area, as described in the following sections:
- About the Tier entity
- About the Instance entity
- About the Engine entity
- About the Device entity
- About the Data Cache entity
- About the Performance Counter or Counter Instance entity
- About the Wait Events entity
- About the Replication Server entity
- About the Replicate(d) Databases entity
Anchor | ||||
---|---|---|---|---|
|
Choose All Instances from the Instances List to display information on the Tier entity. The Tier entity provides a view of all Sybase instances in the application.
...
- Overview
- Instance Grouping
About viewing a summary of statistical information on top instance consumers
The Overview provides statistical information on the top six instance consumers of various resources and enables you to compare them.
The Tier entity shows the top six consumers as follows:
- Top 6 instances (% Engine Utilization)
...
- . Displays the top six instances for which the engine utilization was highest within a certain time frame.
- Top 6 instances (Committed Transactions)
...
- . Displays the top six instances with the highest number of committed transactions within a certain time frame.
- Top 6 instances (Connection Opened – Sum)
...
- . Displays the top six instances with the most connections opened within a certain time frame.
About viewing performance counters according to instance groups
The Instance Grouping view displays performance counters broken down into instance groups (the instance groups are defined by the user).
For an explanation on how to define instance groups, see the Precise Installation Guide. The table below describes the information displayed in the Instance Grouping table.
...
Item | Description |
---|---|
Group | Displays the name of the group. |
Instances | Displays the number of instances linked to the group. |
Engine Utilization | Displays the average Engine Utilization for the instances in the specified group. |
Committed Transactions | Displays the SUM number of Committed Transactions for the instances in the specified group. |
Connections Opened (Sum) | Displays the sum of opened connections for the instances in the specified group. |
About viewing instances associated with an Tier in the Association area
Displays information on the Instances associated with the selected Tier in the Association area. The table below describes the information displayed in the tabs in the Association area.
...
Tab | Description |
---|---|
Overview | Displays counters reporting on CPU Usage, Memory Usage and amount of Locked Data. |
Network | Displays counters reporting on the number of times an engine polls incoming and outgoing packets and bytes. |
Disk I/O | Displays various counters reporting on the amount of disk I/O. |
Transactions | Displays counters reporting on the number of rows changed in the instance, grouped by type (insert, update, and delete). |
Anchor | ||||
---|---|---|---|---|
|
The instance entity displays statistical information for the entire instance. Precise for Sybase collects hundreds of counters that are relevant to the entire instance. The Instance entity displays predefined graphs that display several counters in each. Each graph contains counters that have some relation to each other and can indicate where performance problems lie.
...
- Overview
- Disk I/O
- Data cache
- Memory
- Network
- Lock management
- Transaction log
- Transaction profile
- HouseKeeper management
- Wait events
- Replication Inbound
- Replication Outbound
About getting an overview of an instance based on statistical data
The Overview displays predefined overtime graphs, which can indicate where performance problems lie. The predefined graphs contain counters reported by Sybase and collected by the Precise for Sybase Collector agent.
The following information is displayed:
- In
...
- Sybase. Displays resource consumption counters collected by the Precise for Sybase Collector agent, such as Using CPU, I/O Wait, and Lock Wait.
- CPU
...
- Yields. Displays information on how often the engines yielded to the Operating System.
- Engine
...
- Utilization. Displays the percentage of time that the Adaptive Server Kernel is busy executing tasks.
- Connections
...
- Opened. Displays the number of opened connections (max and sum).
- Task Context Switches -
...
- Reasons. Displays the number of times each Adaptive Server engine switched context from one user task to another. Possible reasons are: a Network Packet sent and received, modify conflicts, last log page, writes group, committed sleeps, and so on.
About viewing Disk I/O activity
The Disk I/O view displays statistics that report on disk I/O activity, such as Percentage of Checks Returning I/O, number of Pages read and written, and so on.
The following information is displayed:
- Checks Returning I/O
...
- Percentage. Displays the percentage of checks that returned an I/O out of the total number of performed checks.
- Page
...
- Requests. Displays the number of pages read synchronous or asynchronous and the number of pages written.
- Avg Disk I/O
...
- Returned. Displays the average number of engine checks that returned an I/O.
- Disk I/O
...
- Delays. Displays the disk I/O delays due to the following reasons: the engine limit, the OS limit or the ASE limit.
About viewing Data Cache activity
The Data Cache view displays statistics that report on data cache activity, such as Hit Ratio, Utilization, and so on.
The following information is displayed:
- Hit
...
- Ratio. Displays the ratio between the number of times a page was found in the cache and the number of times caches were searched for a specific page.
...
- Utilization. Displays the number of times a requested page was found and not found in all caches (hits) and needed to be read from disk.
- Wash
...
- Behavior. Displays the number of buffers that were clean when they passed the wash marker, the number of times that the I/O was already active on a buffer when it entered the wash area, and the number of times that a buffer entered the wash area dirty and was not already in I/O.
- Dirty Pages
...
- Requests. Displays the average number of pages requested at isolation level 0 for a cache.
About viewing Memory activity
The Memory view displays statistics that report on memory activity, such as number of Memory Requests, Memory Pages, Worker Processes, and so on.
The following information is displayed:
- Memory
...
- Requests. Displays the number of successful/failed requests for memory allocation for the worker processes.
- Worker Process. Requests Displays the number of granted and denied worker process requests.
- Memory
...
- Pages. Displays the number of times that a new page was allocated/released in the memory.
- Avg Memory Ever Used by Worker
...
- Process. Displays the average memory used by the worker process.
About viewing Network activity
The Network view displays statistics that report on network activity, such as number of Packets, Bytes, Checks, and so on.
The following information is displayed:Packets Displays
- Packets. Displays the total number of packets received and sent.
...
- Checks. Displays the number of times ASE performed blocking and non-blocking network checks.
...
- Bytes. Displays the number of bytes received from the network and sent to the network
- I/O
...
- Delays. Displays the total number of times the network I/O was delayed.
About viewing Lock Management activity
The Lock Management view displays statistics that report on lock management activity, such as Lock Contention, Lock Waits, and so on.
The following information is displayed:
- Lock Contention
...
- Percentage. Displays the number of times that there were different lock contentions as a percentage of the total number of lock requests.
- Lock
...
- Waits. Displays the number of times that there was a lock contention, divided by types.
About viewing Transaction Log activity
The Transaction Log view displays statistics that report on transaction log activity, such as Log Writes, Log Allocations, and so on.
The following information is displayed:
- ULC Flushes to
...
- Log. Displays the number of times that the ULC was flushed to the transaction log, because of the following reasons: the ULC was full, a transaction ended, the database was changed, or a system transaction occurred within the user transaction.
- Log
...
- Writes. Displays the number of times the ASE server writes transaction log pages to disk.
- Log
...
- Allocations. Displays the number of times additional pages were allocated to the transaction log.
- Avg Writes per Log
...
- Page. Displays the average number of times each log page was written to disk.
About viewing a Transaction Profile
The Transaction Profile view displays statistics that report on the number of Inserts, Updates, and Deletes. The following information is displayed:Inserts Displays
- Inserts. Displays the number of rows inserted into heap tables, clustered tables or data-only -lock tables.
...
- Deletes. Displays the number of rows deleted on the deferred mode, directly or from DOL tables.
...
- Updates. Displays the number of rows updated in the deferred mode, directly in-place, directly not in-place, directly expensive or deferred mode in DOL tables.
- DOL
...
- Updates. Displays the number of rows replaced in the DOL tables, rows shrunken while updated in the DOL tables, rows expanded while updated in the DOL tables, rows expanded and forwarded while updated in the DOL tables or rows that were forwarded already and now fit in original page and returned to the original page in the DOL tables.
About viewing Housekeeper activity
The Housekeeper Management view displays statistics that report on housekeeper activity, such as Buffer Cache Wash, Garbage Collection, and so on. The following information is displayed:
- Buffer Cache
...
- Washes. Displays the number of times that the housekeeper activity performs buffer cache washes and find it clean or dirty.
- Garbage
...
- Collections. Displays the number of times the housekeeper garbage collection activity checks for space that can be reclaimed.
- Pages Processed in the Garbage
...
- Collection. Displays the number of pages reclaimed by the housekeeper garbage collection activity.
- Statistics
...
- Updates. Displays the number of times the housekeeper chore activities checked to see if statistics needed to be written.
About viewing Wait events
The Wait Event view displays statistics on the top ten wait events for the selected instance.
About viewing Replication Inbound view graphs
The Replication Inbound view is a combination of a few predefined graphs related to the inbound processing phase (replication agent); the view helps you identify what may be causing the latency in the replication system. The information displayed in the Instance level is a summation of all the replicated databases of the instance.
...
Graph | Description |
---|---|
Replicated Commands Breakdown | Highlights The Replicated Commands Breakdown lists the number and type of commands that were replicated and which most affect the replication.
What to do next
|
About viewing Replication Outbound view graphs
The Replication Outbound view graphs view is a combination of a few predefined graphs related to the outbound processing phase. This enables you to understand what specific component(s) may be causing the latency in the replication system. The information displayed in the instance level is a summation of all the outbound processing performed for the specified instance by all the Replication servers attached to it.
...
Graph | Description |
---|---|
DSIE Commands Applied | Highlights The DSIE Commands Applied graph shows how many commands were successfully applied to the target database by DSI/E overtime (relevant for version 15 and higher). It can be used to measure the amount of work imposed by the replication server. You can also compare that number to the SQM Commands Written and check if there is a lag in processing commands inside the replication server. What to do next
|
Anchor | ||||
---|---|---|---|---|
|
The Engine entity displays predefined graphs that shows several counters in one. This enables you to immediately view relevant counters, grouped according to topic.
The following views are available:
- Overview
- Network
- Disk I/O
About getting an overview of CPU yields and engine utilization
The Overview displays predefined overtime graphs, which represent CPU Yields and Engine Utilization. The following information is displayed:
- CPU
...
- Yields. Displays information about how often the engine yielded to the operating system.
- Engine
...
- Utilization. Displays the percentage of time that the Adaptive Server Engine is busy executing tasks.
About viewing Network activity
The Network view displays predefined overtime graphs, which represent the number of Bytes sent and received, and Packet transportation.
The following information is displayed:Packets Displays
- Packets. Displays the total number of packets received and sent by the engine.
...
- Bytes. Displays the total number of bytes received and sent by the engine.
About getting an overview of Disk I/O
The Disk I/O view displays predefined overtime graphs, which represent Checks Returning I/O and Average Returned Disk I/O.
The following information is displayed:
- Checks Returning I/
...
- O. Displays the percentage of I/O checks that found an I/O request completed.
- Avg Disk I/Os
...
- Returned. Displays the average number of engine checks that returned an I/O.
Anchor | ||||
---|---|---|---|---|
|
The Device entity displays predefined graphs that report on device activity and performance. The following views are available:
...
See About the Instance entity on page 85.
Anchor | ||||
---|---|---|---|---|
|
To determine whether Sybase is performing optimally there is a need to analyze performance measurements over time. The Statistics tab provides performance counters grouped into several predefined graphs that let you locate performance problems in your system (For example CPU, Paging, I/O, and Network Statistics). In addition, In Sybase states let you correlate between the performance counters and In Sybase states, to determine how an activity in the Sybase instance affects the system.
...