SQL Server Performance

CPU spikes

Discussion in 'Performance Tuning for Hardware Configurations' started by nicolo, Mar 1, 2005.

  1. nicolo New Member

    I have a MS SQL2000 database running on a Pentium 4 machine with 2GB of RAM right now. The first SCSI disk contains a partition with the operating system while the other two SCSI disks are in a RAID 1 set.
    For the most part, the actual data files are tiny images, tifs, stored and accessed by roughly 50 end users. When the RAID 1 set filled up, the images were getting stored on the rest of the first disk where the OS sat.
    Not surprisingly the CPU usage started to spike up as well. I've defragmented the drives as well but there is only a slight improvement. For the most part, it's rather slow.
    Is there a way to tune this DB with what I have right now? Is the db fragmented? What can I do to bring this CPU level down and speed up this db?
  2. mmarovic Active Member

Share This Page