Page History
...
You can identify a performance problem by doing one or more of the following:
- Determining which instance consumes the most resources
- Identifying the highest resource consumers in various entities
- Examining instance statistics
- Monitoring a session activity during the last minute
| Anchor | ||||
|---|---|---|---|---|
|
Precise for Sybase enables you to determine which are the most resource-consuming instances, indicating a potential performance problem.
To determine which instance consumes the most resources1. In
- In the All Sybase Instances table, observe the total In Sybase statistics and statement executions for an instance during the selected time frame.
...
- View its resource consumption over time to identify problematic time periods and get an idea of the general trend of resource consumption.
| Anchor | ||||
|---|---|---|---|---|
|
Precise for Sybase lets you determine which are the most resource-consuming application components (such as, Machines, Logins, Users, Databases, Programs, and Batches).
To identify the highest resource consumers in various entities1. Identify
- Identify the most resource-consuming instances.
...
- Select the Activators and Activities tabs in the Instance Details area to determine which are the most resource-consuming application components.
...
- Launch the Activity tab to continue the performance tuning process on the selected component.
| Anchor | ||||
|---|---|---|---|---|
|
You can examine instance statistics over time to confirm that Engine utilization and Load (Committed Transactions and Connections Opened) are within normal ranges. A continually high Engine utilization may indicate the need to improve the application or to add more engines to the machine to enhance performance.
To examine instance statistics1. Select
- Select the Statistics tab in the Instance Details to view Engine utilization during the selected time frame.
...
- Launch the Statistics tab to observe additional instance statistics that can help you locate performance problems in various other aspects of your system, such as I/O and Network.
| Anchor | ||||
|---|---|---|---|---|
|
Monitoring a session's activity during the last minute in Sybase, can help you locate anomalous activities such as Locking, Internal Waits, and so on.
To monitor a session's activity during the last minute1. Select
- Select the Current tab in the Instance Details area to view all the active sessions and an In Sybase breakdown into states, such as, Using CPU, I/O Wait, and Lock Wait.
...
- Launch the Current tab to view additional information on the current sessions.
Precise. Performance intelligence from click to storage. Learn more > >