I am currently running MS SQL 2000 on an IBM x205 xSeries Eserver model 848033X. There’s only a single Intel Pentium 4 2.40GHz processor with 2GB (just added today) and 533Mhz FSB. There are 3 x 74GB SCSI disks. The first has the OS on a 12GB partition and the other two disks are in RAID-1 config.
Many of the datafiles that go into this MSSQL2000 database are nothing more than scanned images – small TIFs…but they are many….thousands upon thousands. When the RAID-1 set ran out of room, I started putting these files onto the remaining portion of the first disk which is the OS disk.
Naturally the files grew to up to 30GBs now on the OS disk. Upgrading up to 2GB RAM seemed to help a bit, however, as other people try to access the PC, the CPU would often spike up to almost 100% then down. Is there anyway to alleviate this problem? Is it simply because I have too many of these database files sitting on the first OS disk instead of the RAID-1 array? What can I do to tweak the system with what I’ve got?