Page History
...
The selected entity is always reflected in the Tab heading, which serves as a point of orientation. The highest-level entity you can view information for in the Current tab is Instance. You can view another instance by selecting it from the Instance list.
About the Main area in the Current tab
The Main area shows comprehensive information on the selected entity, such as the In Sybase data for the last minute, and the number of active sessions.
About the Association area in the Current tab
The Association area provides corresponding information on the entities associated with the selected entity (displayed in the Main area). For example, you can associate to the Active Sessions related to the selected instance. The selection you make is reflected in the Association area only; the Main area remains unchanged. For some entities, tabs above the Association area enable you to view additional information. For example, the tabs displayed for a database are: General, In Sybase and Statistics. Clicking a tab displays different table columns with the same type of child entities.
...
See About Precise for Sybase tabs on page 15 . See and About the Dashboard tab on page 33.
...
The following entities can be examined in the Current tab:• Instance
- Instance entities
...
- Database entities
...
- Session entities
...
- Statement and Batch entities
About the Instance entity
The Instance entity displays information on the resource consumption of the entire instance and allows you to focus on how it is performing, during the last minute.
About getting an overview of current Instance entities
The Overview displays information on the activity of the instance, such as number of sessions and the resource consumption breakdown of the instance.
The table below describes the information displayed in the Instance overview.
Table 5-1 Instance 1 Instance overview
| View |
|---|
...
| Area | Description |
|---|---|
| Sessions | Displays the following session-related information: |
...
|
...
|
...
|
...
| Statistics | Displays information on the following statistical parameters: |
...
|
...
|
...
|
...
|
...
|
| In Sybase (Last |
...
| Minute) |
...
Displays the resource consumption breakdown of the instance during the last minute (that is, 60 samples of the Collector agent). In addition to the resource distribution, the view displays the number of sessions in each state during the last sample. It is important to remember that since this view only displays last minute's activities, you will always be viewing the activities that occurred during the last minute and not the activities that occurred since the last refresh action. The following information is displayed: |
...
|
...
|
...
|
...
|
...
|
...
|
...
|
See About session states on page 25.
About the Database entity
The Database entity displays information on the activity and resource consumption of the database, including the number of sessions connected to the database during the last sample taken, various session-related statistics and the database resource consumption breakdown for the last minute.
About getting an overview of current database activities
The Overview displays information on the activity and resource consumption of the database, including the number of sessions connected to the database during the last sample taken, various session-related statistics and the database resource consumption breakdown for the last minute.
The table below describes the information displayed in the Database overview.
Table 5-2 Database 2 Database entity overview
| View |
|---|
...
| Area | Description |
|---|---|
| Session | Displays the following session-related information: |
...
|
...
|
...
|
| Statistics |
...
Displays information on the following statistical parameters: |
...
|
...
|
...
|
...
|
...
|
| In Sybase (Last |
...
| Minute) |
...
Displays the resource consumption breakdown of the database during the last minute (that is, 60 samples of the Collector agent). In addition to the resource distribution, the view displays the number of sessions in each state during the last sample. It is important to remember that since this view only displays the last minute's activities, you will always be viewing the activities that occurred during the last minute and not the activities that occurred since the last refresh action. The following information is displayed: |
...
|
...
|
...
|
...
|
...
|
...
|
...
|
See About session states on page 25.
About the Session entity
The Session entity displays information on a single connection with Sybase. Precise for Sybase identifies a session by the following attributes:• System
- System Process ID (SPID)
...
- . A unique integer assigned to each user connection when the connection is made.
...
- Host Process (PID)
When one of these attributes changes, a new session is recorded and displayed.
About getting an overview of a session entity
The Overview displays information on the session identifier's connection details, session-related statistics and a breakdown of session resource consumption, during the last minute.
The table below describes the information displayed in the Session overview.
Table 5-3 Session 3 Session overview
| View |
|---|
...
| Area | Description |
|---|---|
| Session |
...
| Tab | Displays information on the following session identifiers: |
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
| Connection |
...
| Tab | A connection includes session identifiers, such as database, login, machine and user, as reported by the sysprocesses.The following information is displayed: |
...
|
...
|
...
|
...
|
...
|
...
|
| In Sybase ( |
...
| Last Minute) | Displays the resource consumption breakdown of the session during the last minute (that is, 60 samples of the Collector agent). It is important to remember that since this view only displays the last minute's activities, you will always be viewing the activities that occurred during the last minute and not the activities that occurred since the last refresh action. The following information is displayed: |
...
|
...
|
...
|
...
|
| Locks |
...
| Tab | Displays information on the current session locks that exists in the instance. Contains the following information on each session: |
...
|
...
|
...
|
...
|
...
|
| Statistics |
...
| Tab | Displays information on the following statistical parameters: |
...
|
...
|
...
|
...
|
...
|
...
|
See About session states on page 25.
About viewing the current statement's text
The Text view displays the text of the current statement. If the session is not active and executing a statement, a message notifying you that the session is not active and that no text is available, is displayed.
About Statement and Batch entities
The Statement and Batch entities display information on a SQL statement that was executed by the selected session during the last time slice.
About getting an overview of current Statement and Batch entities
Displays general information on the statement or batch, including overall statement properties, the breakdown of the statement In Sybase during the last time slice, and some statistics regarding the resource consumption of the statement.
...
The table below describes the information displayed in the Statement or Batch overview.
Table 5-4 Statement 4 Statement or Batch overview
Parameter Description
Statement/Batch ID Internal statement hash value (SHV) calculated by the Collector agent.
...
Parallel Sessions (Min) Minimum number of threads used to execute the statement or batch in parallel. This counter is calculated from the fid column in sysprocesses. This enables you to verify that Sybase is using the best execution plan for the current statement.
Parallel Sessions (Max) Maximum number of threads used to execute the statement or batch in parallel. This counter is calculated from the fid column in sysprocesses. This enables you to verify that Sybase is using the best execution plan for the current statement.
...