Running SQL Server 2008 Ent Edition on Server 2003 SP2, Dell Poweredge 2600 Server, 2.4 GHz Xeon Single Processor 1.0 GB Ram, SCSI HDD RAID 0 with static IP.
Currently SQL Server handles about 5000 I/O operations per seconds, have notice that CPU remains at 100% while processing queries, what...