Page History
This section includes the following topics:• About
- 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
About the Statistics tab
The Statistics tab displays statistical information on all Sybase instances. The tab can be used to monitor your system's historical statistical information.
...
The Statistics tab displays information on the following different entities in the Association area, as described in the following sections:• About
- 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
About the Tier entity
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.
The following views are available:• Overview
- Overview
...
- Instance Grouping
About viewing a summary of statistical information on top instance consumers
...
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
...
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.
Table 8-1 Instance 1 Instance Grouping table
Item Description
...
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.
Table 8-2 2 Viewing information on associated instances
Tab Description
...
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). |
About the Instance entity
...
The following views are available:• Overview
- 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
...
Avg Memory Ever Used by Worker Process Displays the average memory used by the worker process.
About viewing Network 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 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.
Table 8-3 I3 I/O vs Cmds Sent
Graph |
---|
...
Description |
---|
IO vs. Cmds |
...
Sent | Highlights The IO vs. Cmds Sent graph shows the number of commands processed by the RepAgent during the given period and the amount of time the RepAgent had to wait while writing to the inbound queue. Each bar represents a time period. The speed of the RepAgent is directly proportional to the speed of ASE processing the network that sends requests coupled with the speed of the Replication Server processing. What to do next |
...
|
...
|
Table 8-4 Truncation 4 Truncation Point MovementGraph Description
Graph | Description |
---|---|
Truncation Point |
...
Movement | Highlights The Truncation Point Movement graph shows the number of times the RepAgent has asked the RS for a new secondary truncation point and then moved the secondary truncation point in the log. If 'Moved' is more than one less than 'Gotten', the likely cause is that a large or open transaction exists from the Replication Server perspective (either it is indeed still open in ASE or the RepAgent has not forwarded the commit record yet). What to do next |
...
|
...
|
Table 8-5 Network
Graph Description
...
5 Network
Graph | Description |
---|---|
Network | Highlights The Network graph shows information related to the network activity. If the Number of Full Packets is a considerable percentage out of the total package sent (>= 90%), then you may need to consider increasing the send_buffer_size. What to do next |
...
|
Table 8-6 Log 6 Log Scan Summary
Graph |
---|
...
Description |
---|
Log Scan |
...
Summary | Highlights The Log Scan Summary graph is an indicator of how much work the RepAgent is doing and how much information is being sent to the Replication Server. Replicated log records are records converted into LTL and sent to the RS. Not replicated log records are all log records that were scanned but not sent. What to do next |
...
|
Table 8-7 Replicated 7 Replicated Commands BreakdownGraph Description
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.
Table 8-8 SQM 8 SQM Processing
Graph |
---|
...
Description |
---|
SQM |
...
Processing | Highlights The SQM Processing graph shows the space usage of SQM queue overtime versus the number of commands written to the queue. The SQM Commands Written indicates the amount of activity performed by the replication server. What to do next |
...
|
...
|
...
|
...
|
...
Table 8-9 DSI 9 DSI SQT ProcessingGraph Description
Graph | Description |
---|---|
DSI SQT |
...
Processing | Highlights The DSI SQT Processing graph shows space usage of the outbound queue cache. The Cache size lists the size of the SQT cache. Cached Used shows SQT thread memory usage over time. Each command structure (allocated by an SQT thread) is freed when its transaction context is removed. Consequently, if no transactions are active in SQT, then SQT cache usage is zero. If Cached Used is near the maximum cache size capacity and Trans Removed is constantly greater than zero, you may decide to increase the SQT cache size by increasing dsi_sqt_max_cache_size. Don’t increase the cache size if Trans Removed is occasionally greater than zero; this situation usually means that a transaction was removed from the cache because it was greater than the dsi_sqt_ max_cache_size. For occasional increases of Trans Removed, increasing the cache size will have the opposite effect because the latency in processing transactions ahead of them will likely result in their being removed. The SQM Read Cached indicates how many 16K blocks of cache were read by the SQM Reader thread. This number should be as high as possible. If it is constantly hitting zero, most likely there is a latency in executing the SQL at the replicate; resulting in the DSI SQT cache to reach its maximum. What to do next |
...
|
...
|
...
|
...
|
...
|
Table 8-10 DSIE 10 DSIE Transactions Processing
Graph Description
DSIE Transactions Processing Highlights
...