Page History
...
Info |
---|
The Current tab displays information on the last minute of activity. For example, if you have worked at your screen for ten minutes and then refresh the information displayed on your screen, you will be able to view new information that occurred during the last minute of activity. |
See About the Dashboard tab on page 33.
Anchor | ||||
---|---|---|---|---|
|
...
In the Association area, click the row of the session that you want to view detailed information for. The Tab heading indicates the newly selected entity; the Main area displays detailed information on the session you drilled down to, and the Association area shows information on the statements associated with this session.
See About Precise for Sybase tabs on page 15 and and About the Dashboard tab on page 33.
Anchor | ||||
---|---|---|---|---|
|
...
The table below describes the information displayed in the Instance overview.
Table 5- 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 table below describes the information displayed in the Database overview.
Table 5- 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 table below describes the information displayed in the Session overview.
Table 5- 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 table below describes the information displayed in the Statement or Batch overview.
Table 5- 4 Statement or Batch overview
Parameter |
---|
...
Description |
---|
Statement/Batch |
...
ID | Internal statement hash value (SHV) calculated by the Collector agent. |
...
Database | Identifies the database on which the statement or batch is run. This information is used by Precise for Sybase to display the statement's execution plan. |
User |
...
Displays the parsing user who runs the statement or batch. This information is used by Precise for Sybase to display the statement's execution plan. |
Executions |
...
Number of times the Collector agent identifies that the statement or batch was executed. |
Duration |
...
Total time required to execute the selected statement or batch during the last time slice. |
Duration (Avg) |
...
Average duration of each statement execution during the last time slice. | |
CPU |
...
Time | Cumulative CPU time for the statement during the last time slice. |
Table 5-4 Statement or Batch overview
Parameter Description
Physical I/O |
...
Operations | Total number of physical I/O requests during the execution of the statement or batch during the last time slice. |
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. | |
In Sybase (Last minute) |
...
Displays the resource consumption breakdown of the statement or batch 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 How information is collected on page 25.
About viewing current Statement or Batch text
Displays text of the selected statement or batch.
About the Statement and Batch Association area
It is possible to view statement or batches in the Association area while drilling down from a single session. The table includes only statements or batches that were executed during the last time frame. A time frame is a 15-minute interval. If a statement or batch was executed in an earlier time frame, this statement or batch no longer appears in the Current tab. Instead, you can view information on this statement or batch in the Activity tab.
The table below describes the information displayed in the Association area, when viewing a statement or batch entity.
Table 5-5 Statement Statement/Batch Association table
Association |
---|
...
Tab | Function |
---|---|
General | Shows general information on the displayed statements or batches. |
In |
...
Sybase | Shows information on performance and statistics of the displayed statements or batches. |
Statistics |
...
Shows statistics of the displayed statements or batches. |
See See About session states on page 25.See , Understanding In Sybase session states on page 25.See , and Understanding Non-In Sybase session states on page 27.
Anchor | ||||
---|---|---|---|---|
|
You can identify a performance problem by doing one or more of the following :actions.• See
Examining the resource consumption of an entire instance and database
...
The Current tab provides an almost real-time
• See Observing session activity on page 47.
• See Examining a single connection on page 47.
Examining the resource consumption of an entire instance and database
The Current tab provides an almost real-time picture of the performance and behavior of your Sybase instance. It displays information on the last minute of activity.
To examine the resource consumption of an entire instance and database1. Examine
- Examine the activities of the entire instance level to determine what is happening in your system.
...
- Examine the current activity at an instance level of display to see how the system is currently behaving and determine if there is an overall problem that affects all sessions or if there is a problem with specific sessions.
...
- Start your investigation in the Overview view of an Instance or Database entity. This will show you a breakdown of resource consumption for the last minute.
Observing session activity
In the Association area you can see which sessions are currently connected to the Instance, or view which sessions are currently using a specific database or holding a specific object.
To observe session activity1. Observe
- Observe the current state of the session and determine if it is active or waiting for a resource.
...
- Identify the session by different identifiers such as its login, the machine it is running on, or the programs it is running. The current active SQL code is displayed for active sessions.
...
- If you have hundreds of sessions running, and you want to focus your investigation on the sessions that were active in Sybase during the last minute, select Active Sessions from the Association Controls in the Association area.
Examining a single connection
You may need to explore a single running SPID, to obtain more information for it. To examine a single connection1. Drill down
- Drill down to the specific SPID in question. Continue examining its resource breakdown, its recent statements, or the batches in which the session was executed, during the last few minutes.
...
- Check if the session is blocked and by whom.
Precise. Performance intelligence from click to storage. Learn more > >
...