Hi everyone, my SQL server is a very powerful machine: Windows 2003 Enterprise 4 CPU Xeon 2500, with Hyperthreading enabled 16Gb RAM, /3GB and /PAE enabled 2 SCSI Disk for OS, 15000rpm with RAID 1+0 5 SCSI Disk for Database Files, 15000rpm with RAID 5 1 controller HP SmartArray 6400 I've put all the files on the second Drive. I notice that the %idle time of this unit is always 0%. Then to improve the performance I've tried to put the transaction log on the first drive but I don't really notice a change. Now, when the %idle time of the first array is 0 the second one is 100% and viceversa. I think that the problem could be the controller, that is too busy... Do you think that an additional controller, with 2 SCSI unit can help? Or we can just add 2 disk to the actual controller where we will put the transaction log file? Here's our counters: Object: Memory Page Faults/sec108.009 Page Reads/sec0.000 Page Writes/sec0.000 Transition Faults/sec48.004 Transition Pages RePurposed/sec0.000 Object: LogicalDisk C:E: % Idle Time96.6605.920 Avg. Disk Queue Length0.0334.751 Object: PhysicalDisk 0 C:1 E: % Idle Time96.6705.920 Avg. Disk Bytes/Read0.0009294.769 Avg. Disk Bytes/Transfer54613.33314301.753 Avg. Disk Bytes/Write54613.33347681.641 Object: SQLServer:Access Methods Index Searches/sec12556.999 Do you think that this machine is running poorly? Roughly we have something like 5 million row per day.