The Activity Summary window gives a quick access to the activity of a Sybase instance.
Active Number of sessions which are currently active. Idle Number of sessions which are currently inactive. Blocked Number of sessions blocked by another session System Number of system sessions.
Busy percentage of time that the CPU has spent doing Adaptive Server work I/O Busy percentage of time that Adaptive Server has spent doing input and output operations Idle percentage of time that Adaptive Server has been idle
Received Number of KBytes received on the network per second Sent Number of KBytes sent on the network per second
Total Total size of the cache in MegaBytes Data data cache size in MegaBytes Procedure procedure cache size in MegaBytes Metadata (database) Metadata cache for database in Megabytes Metadata (Objects) Metadata cache for objects in Megabytes Metadata (Indexes) Metadata cache for indexes in Megabytes
Physical reads Number of buffers read into the cache from disk per second Physical writes Number of buffers written from the cache to disk per second Logical reads Number of buffers retrieved from the cache per second Procedure disk reads Number of stored procedures loaded into cache per second Procedure disk writes Number of times a procedure was normalized and the tree written back to sysprocedures per second
Hit Ratio (%)
Data cache Percentage of time a required data block is found in the data cache. Procedure cache The procedure cache hit ratio indicates the percentage of execution plan pages read from the procedure cache vs. disk.
Used Number of locks in use Waiting Number of locks waiting for their request to be granted
Wait distribution for the following wait categories:
- waiting to be scheduled
- waiting for a disk read to complete
- waiting for a disk write to complete
- waiting to take a lock
- waiting for memory or a buffer
- waiting for input from the network
- waiting to output to the network
- winting for internal system event
Copyright © AgileLoad. All rights reserved.