Page History
...
The Activity tab displays information on various entities and their associated entities. The information displayed when you launch the Activity tab depends upon where you are launching from.
For example, when you launch the Activity tab from the Dashboard tab, one of the following occurs, depending upon what you selected in the All Sybase Instances table:
If you selected the Focus in Activity tab is on
an instance row the selected instance
the All row the Tier level
When you access the Activity tab from other tabs, the entity, time frame, views, and associations that were in place the last time you visited the tab, are displayed (similar to clicking the Back button in the Precise toolbar).
...
- Keeping the entity in the Main area, but selecting a different set of entities to view in the Association area, by selecting an entity from the Association controls list.
- Switching to a different entity by drilling to another entity from the Association area.
- Switching to a different view in the Main area, thereby displaying additional information on the selected entity.
About the Main area in the Activity 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, you can focus on an In Sybase over time graph for an Instance entity, to observe its resource consumption over time or you can focus on the Scalability view to investigate the scalability of the instance over time.
See About drilling down in context on page 18.See , About the Main area on page 17.See , and About the Association area on page 17.
Navigating in the Activity tab
The name of the entity you selected is displayed in the Tab heading, which serves as a point of orientation. The highest level entity that you can view information for in the Activity tab is the Tier.
...
See About drilling down in context on page 18. See , About the Main area on page 18. See , and About the Association area on page 18.
About the Association area in the Activity 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 Databases, Statements and Logins 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. For example, the following tabs show additional information for the Statement entity:
...
See About drilling down in context on page 18. See , About the Main area on page 18. See , About the Association area on page 18. See , How most tabs are structured on page 15. See , Tasks common to most tabs on page 20. See , and About the Dashboard tab on page 33.
...
- All Instances
- Instance and Collector entities
- Statement/Batch/Collapsed Statement/Collapsed Batch Entities
- Session and Blocker Session Entities
...
| Info |
|---|
The entities listed above have been grouped together logically since they can be described similarly. They appear separately when viewed in the GUI. |
About the All Instances entity
The Tier entity displays the resource consumption of all the instances in the application. The following views are available:
- Overview
- In Sybase
- Instance grouping
About viewing a summary of the performance and resource consumption of all instances
The Overview displays a summary of the performance and resource consumption of all instances in the application, as follows:Instances Displays
- Instances. Displays the number of Instances defined in the Tier.
- In Sybase breakdown (Table)
...
- . Displays the resource consumption breakdown of all the instances during the selected time frame.
The table includes the following information:
- State
- - . In Sybase state.
- In Sybase
- displays - . Displays a graphical representation of the Time column.
- Time
- amount - . Amount of time the selected Tier was in this state.
%
- percentage . Percentage of time the selected entity was in this state.
...
Info The table only displays the states the selected entity was in. For example, if the selected entity was not waiting for an I/O Wait during the selected time frame, the table will not display I/O Wait parameters.
About viewing In Sybase data for all instances
Displays the overtime graph of the total In Sybase counter for all instances in the Sybase Tier.
About viewing Instance grouping for all instances
Displays instance grouping information for the selected Sybase Tier. It is possible to categorize instances into groups and observe their tuning counters, such as their In Sybase breakdown, according to the groups you defined. This option is useful if there are many instances in the same application. For an explanation on how to define instance groups, see the Precise Administration Guide.
About Instance and Collector entities
The Instance entity and the common Collector entities display the resource consumption of the entire instance (or the entity selected). When focusing on an instance, or collector entity, such as a program, you can examine how it is performing during the selected time frame.
The table below describes which Collector entities can be examined in the Activity tab.
Table 6-1 Collector 1 Collector entities that can be examined in the Activity tab
| Collector |
|---|
...
| Entity | Description |
|---|---|
| Database | Displays information on an activity in reference to a specific database. |
| Program |
...
| Displays information on an activity generated from a specific program. Displays 'N/A' if the program_name column in sysprocesses is null. |
| Login |
...
| Displays information on an activity generated by a specific login. Displays 'N/A' if the suid column in sysprocesses holds a number for which the user name is null. |
| User |
...
| Displays information on an activity generated by a specific user in the database in use. |
| Machine |
...
| Displays information on an activity generated from a specific workstation. If the hostname column in sysprocesses is null, displays the IP Address of the workstation for instances of version 12.5 or later, or 'N/A' for instances of earlier versions. |
See Precise for Sybase agents on page 13.
...
- Overview
- In Sybase
- Locking
- Overall Activity
- Scalability
About getting an overview Instance and Collector data
The Overview displays information on the performance and resource consumption of the collector entities. It is divided in the following areas.Load Displays
- Load. Displays information on the following session-related items:
- Sessions
- . Number of sessions that occurred during the specified time period of the selected collector entity. For example, if you are viewing the Login entity, this value represents the number of sessions that are connected to the selected Login.
- Duration (Avg)
- . Average duration for a single session, in the selected collector entity during the selected time frame, calculated by dividing the Duration by the number of Sessions.
- Duration (Summed)
- . Total amount of time that elapsed for all of the selected collector entity's sessions during the selected time frame.
- Statement Executions
- . Number of statements executed during the selected time frame that were generated by the selected collector entity's sessions.
- Statement Duration (Avg)
- . Average duration for a single statement execution, in the selected collector entity during the selected time frame. This value is calculated by dividing the Duration (Summed) parameter by the number of statement executions.
...
- Statistics. Displays the following session-related statistics:
- CPU Time
- . Cumulative CPU time for the collector entity or instance during the selected time frame.
- Physical I/O Operations
- . Total number of physical I/O operations performed by all sessions connected to the database during the selected time frame.
- In Sybase
...
- Breakdown. Displays collector entity resource consumption (table format) and shows instance breakdown during the selected time frame. The table displays the following information:
- State
- . Displays the In Sybase state.
- In Sybase
- . Displays a graphical representation of the Time column.
- Time
- . Amount of time the selected collector entity was in this state.
- %
- . Percentage of time the selected collector entity was in this state
See About session states on page 25.
About viewing Instance and Collector In Sybase data
The In Sybase view displays the resource consumption of the selected collector entity during the selected time frame. This graph enables you to analyze performance trends for the collector entity, over time.
See “Understanding In Sybase session states” on page 25. See “Focusing on information in overtime graphs” on page 22.
About viewing Instance and Collector locking data
The Locking view displays the blocking tree and the lock wait duration broken down into lock levels (such as, Table, Page, and Key) for the selected entity, over the selected time period. The following information is displayed:Locks Displays
- Locks. Displays which sessions were involved in a blocking situation (either locking or blocking). It is important to understand which sessions are involved in each blocking chain, as there may be several sessions involved at the same time. It is then important to determine which session is blocking others, which object is being blocked, and what type of lock has been applied.
A yellow lock indicates that the session is currently blocking another session but is not itself blocked.
A red lock indicates the session is currently blocked by another session. Note that a session may also block other sessions while being blocked by a different session. - Lock wait
...
- graph. The Lock Wait graph shows a breakdown of the Lock Waits and when they occurred over the selected time period.
See Focusing on information in overtime graphs on page 22.
About viewing Instance and Collector overall activity
The Overall Activity view displays the duration of the activity performed by the selected collector entity during the selected time frame, broken down into the following components:
- Waitfor Command - the . The amount of time applications were waiting for a Waitfor command.
- Parallel Sync Wait - the . The amount of time applications were waiting on a synchronization message from another process in the family.
- Request Wait - the . The amount of time applications were in a Request Wait state, defined as the state wherein the server is waiting for a client request.
- Other Wait - the . The amount of time applications were in Other states.
- In Sybase - represents . Represents total amount of time spent in Sybase.
See Focusing on information in overtime graphs on page 22.
About viewing Instance and Collector scalability
The Scalability view displays an over time graph that allows you to examine the scalability of the selected collector entity, as follows:
- In Sybase (Avg) vs. Sessions.
...
- Compares the average In Sybase time of the selected collector entity with the number of sessions during the selected time frame. For example, if the selected collector entity is Login, the graph will show the number of sessions connected with the selected login versus the average In Sybase time of each session over time. Use this graph to analyze if the average session In Sybase time increases when the number of sessions increase.
See Focusing on information in overtime graphs on page 22.
Instance and Collector entities Association area
Additional information on performance and In Sybase activity for the instance and collector entities is displayed in the Association area tabs.
Clicking a tab shows additional information on the entities displayed in the Association area table. The rows of the table remain the same; the columns change to display additional details on the entities listed in the table. The information displayed in each tab is described below.
About viewing performance data for Instance and Collector entities
The table below describes the additional information displayed in the Performance tab in the Association area.
Table 6-2 Precise 2 Precise information displayed in the Performance tab
Column Description
Entity Name (such as Instance, Database) Displays the name of the entity.
...