Originally posted by EdHubbard
I presume you are on SQL 7 or above. If on SQL 6.5, that had very poor performance!
Yes we are using SQL 7 and performance is poor. SQL eats up around 800MB or so of physical memory during peak loads.
Originally posted by N. sriram
RAID5 also is instrumental in making the server slower.
I am not sure that the RAID 5 is the cause of the server slowing down (assuming that you have a good RAID card installed that does not eat CPU cycles.Even in the worst case a RAID card would not consume more than 10% of CPU time even under extensive read/writes)
I setup a performance counter in winNT and under peak loads the reads/writes total did not exceed a few hundred Kbytes/sec. (far below the capability of the Disk subsystem, even an old one such as the one we have)
I have a feeling that memory is the bottleneck. Today i will set up another perfomance counter to see how much swapping takes place under load for a few days.
could you ( EdHubbard and sriram and anyone else who reads this post
) also please post some numbers about Disk I/O's and memory usage in your systems under a typical load? Just so that the bottleneck is easier to isolate