We are running a 4 Processor SMP server - a IBM F50 (4x166MHz IBM RS6000 processors) with 1GB ram, SSA Drives, etc.
I am however amazed by the poor performance of the system in general and seriously suspect a setup problem somewhere. I am looking for any suggestions of what to do to improve our performance.
The database is fairly large (20 GB). Running iostat/monitor/etc indicates the following stats when a client application performs a number of single-row selects on multiple connections in parallel:
Average transactions/second : ~100
SYS 0.5% USR 2.5% WAIT 89% IDLE 8%
Total throughput from all disks 900 k/s
REAL : Free 0.5 Mb Files 600MB Used 423.5MB
VIRTUAL: Free 0MB Used 1024MB
I know this is very broad but any pointers will be usefull. I am more of a hardware expert than a database or AIX one and thus the problem is pretty complicated to me as I do not know the inner workings of Sybase.