By: Borland Staff
Abstract: Describes Current memory,Delta memory,Max memory,Elapsed time,Buffers,Reads,Writes,Fetches
What do the statistical values returned from WISQL mean?
- 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.
Trial Download Week!
Click here to download a free 30-day trial of InterBase XE3 Server or ToGo editions. Or download a free non-expiring Developer Edition >
More InterBase Info
InterBase XE3 Product Info
Free Developer Edition download
InterBase on Google+
Follow @InterBase_ on Twitter
Server Response from: ETNASC04