Page History
...
See How information is collected on page 25.
About viewing current Statement or Batch text
...
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, Understanding In Sybase session states on page 25, 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.
...
Examining
...
Examining the resource consumption of an entire instance and database
...
- 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 connection
- 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.