What do the statistical values returned from WISQL mean?

By: Borland Staff

Abstract: Describes Current memory,Delta memory,Max memory,Elapsed time,Buffers,Reads,Writes,Fetches

Problem:
What do the statistical values returned from WISQL mean?

Solution:
- Current memory: Current amount of memory allocated on the server.
- Delta memory: Change of amount of memory on the server since the previous query.
- Max memory: The maximum amount of memory on the server that has been allocated 
since it has been brought up running.
- Elapsed time: Time it took to process the query.
- Buffers: Number of database pages held in memory.
- Reads: Physical page reads from the hard disk.
- Writes: Physical page writes from the hard disk.
- Fetches: The number of times the pages in the cache have been referenced

> What are the implications of each of these statistics and do
> smaller or larger values mean that things are better?

The Current memory, Delta memory, and Max memory values need to be coordinated 
with the amount of physical and virtual memory on the server system to minimize the 
server from becoming I/O bound by the OS.

For the number of Buffer generally the more the better, until diminishing returns are 
reached.  The buffers value can be coordinated with the Fetches.  The greater the number 
of Fetches means the less the server is going to the disk.

Doing a GBAK backup and restore will likely reduce the number of Reads and Writes 
to the minimum need numbers.  A GBAK backup does not backup back versions of a 
record, and a GBAK restore places data for a table contiguously in a .gdb file (that is until 
further INSERTs, UPDATEs and DELETEs cause data fragmentation.


Server Response from: ETNASC02