Page History
...
You can identify a performance problem by doing one or more of the following :
- See Examining the resource consumption of an entire instance and database.
- See Observing session activity on page 47.
- See Examining a single connection on page 47.
...
actions.
...
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.
...
- 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.