Page History
This section includes the following topics:
- 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 Statistics tab displays statistical information on all Sybase instances. The tab can be used to monitor your system's historical statistical information.
...
Use the Statistics tab to periodically monitor the health of your system - for example, view the statistics on CPU Utilization or Hit Ratios. Alternatively, you can use the Statistics tab to fully analyze a performance problem reported by the Collector agent.
Info |
---|
...
Statistics tab data is based on the results of the statistics counters that are gathered by ASE. These counters are cleared when using sp_sysmon to view statistics counters. If sp_sysmon is run, statistics data gathered by Precise for Sybase will not be complete. This problem can be avoided by not running sp_sysmon or by using the noclear option of sp_sysmon (available in Sybase version 12.5.3 and higher). |
Anchor | ||||
---|---|---|---|---|
|
The Statistics tab displays information on a selected entity and its associated entities. When you open the Statistics tab from the Dashboard tab or the Activity tab, the tab is launched, in-context, and depending upon your selection in the All Sybase Instances table (All or Instance), the information is displayed on the Tier or Instance level. Navigating between these tabs and the Statistics tab will change the chosen time frame. If you open the Statistics tab from another tab, the historical settings (meaning those settings which were selected when you left the tab, such as the last entity you drilled down to) are taken into account and the information displayed the last time you viewed this tab is displayed (similar to clicking the History control and returning to a previous tab).
...
Table 8-10 DSIE Transactions Processing
Graph |
---|
...
Description |
---|
DSIE Transactions |
...
Processing | Highlights The DSIE Transactions Processing graph shows how long it took to process a transaction by a DSI/E thread breakdown to various phases. |
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
What to do next |
...
|
...
|
...
|
Table 8-11 DSIE 11 DSIE Commands Applied
Graph Description
DSIE Commands Applied Highlights
...
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 |
...
|
...
|
About the Engine entity
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
- Overview
...
- Network
...
- Disk I/O
About getting an overview of CPU yields and engine utilization
...
The Device entity displays predefined graphs that report on device activity and performance. The following views are available:• Overview
- Overview
...
- Semaphores
About getting an overview on a Device activity
...
The Data Cache entity displays predefined graphs that report on the activity of the Data Cache. The following views are available:• Overview
- Overview
...
- Cache details
About getting an overview on Data Cache activity
...
The following view is displayed:
• Overview
...
- Overview
About getting an overview of Wait Events
...
The following views are available:• Replication
- Replication Inbound
...
- Replication Outbound
See About the Instance entity on page 85.
...
The following views are available:• Replication
- Replication Inbound
...
- Replication Outbound
See About the Instance entity on page 85.
...
You can identify a performance problem by doing one or more of the following:• See
- Examining the kernel utilization of Sybase over time
...
...
- Examining I/O statistics
...
...
- Examining network activity
...
...
- Examining memory bottlenecks
...
...
- Examining a specific counter over time
...
Examining the kernel utilization of Sybase over time
...
The table below describes what the utilization status of an engine indicates.
Table 8-12 Utilization 12 Utilization status
Engine |
---|
...
Busy | CPU Yields | Status |
---|---|---|
Low | Low | Engine |
...
is CPU starved |
...
Low | High | Engine is inactive |
...
High | Low | Engine is busy |
...
High | High | Engine is busy |
To improve kernel utilization, it is recommended to check the Disk I/O and Network view. This is done to determine if the number of checks for I/O or Network that the engine performs, is ideal or are overhead.
...
To examine I/O statistics1. Open
- Open the Overview view of the specific instance entity.
...
- Examine the I/O Wait value in the In Sybase graph to detect bottlenecks within the device subsystem.
...
- Check for I/O Pacing and I/O Device Contention values in the Task Context Switches - Reasons graph.
...
- If increased I/O Wait is the result of an activity in the instance, open the Activity tab to continue your analysis of the application's performance.
I/O Pacing reports how many times an I/O-intensive task switched off an engine, due to exceeding an I/O batch limit. This limit can be configured.
...
To determine which devices are having possible performance problems, drill down to the Device entity located in the Association area. In the Association area table you can see the Page Requests and the Sum of Semaphores for the different devices. Drilling down to one of the devices will enable you to see these counters over time.
In the Page Requests graph you can see the amount of I/O reads and writes.
...
You can examine network traffic over a specified time period to detect bottlenecks. Network performance can be improved by one or more of the following:• Enhancing
- Enhancing the application
...
- Reducing the amount of data returned
...
- Configuring the network packet size parameter with a reasonable number that avoids many packets from being sent or received (causing overhead)
...
- Reconfiguring the network configuration
To examine network activity do one of the following1. Examine
- Examine the In Sybase graph and check the Network I/O Wait value.
...
- Check the Task Context Switches - Reasons graph to see if Network Packet Sent is a major cause of task switching.
...
- If so, check the applications on the problematic instance to see if it's possible to reduce the amount of data returned.
OR1. Switch
- Switch to the Network view.
...
- Check the ratio between the Packets graph and the Bytes graph to see if the network packet size is used to its maximum capacity.
...
- Consider configuring its size.
Examining memory bottlenecks
...
To examine memory bottlenecks1. Examine
- Examine the Memory view that reports the number of pages allocated and deallocated in each time slice.
...
- If you spot a high value in one of the time slices, open the Activity tab to continue your analysis of the application's performance.
...
- Switch to the Memory view to see information about the success and failure of Memory Requests for Worker Processed in the Memory Requests graph.
...
- If some of the requests have failed you may need to increase the value of the Memory per Worker Process parameter.
...
- Switch to Data Cache view to see information on how effective cache design is. A high Hit Ratio from the Hit Ratio graph and small amount of Page Request Misses from the Utilization graph may indicate effective cache design.
...
- If you see a low Hit Ratio and a lot of Page Request Misses, investigate statistics for each of the Data Caches by selecting the Data Cache entity in the Association area.
Examining a specific counter over time
...
To examine a specific counter1. Select
- Select the associated required performance group from the Associations list.
...
- Select the required counter.
...
Precise. Performance intelligence from click to storage. Learn more > >
...