I have a 500G data warehouse on SQL2000. It is made up of 4 data files on separate arrays and the TL on a 5th array. The application running against it does 99% reads and some data inserts during the day. At night, large imports are also pulled into the database. We are starting to see higher CPU and disk queuing of late and I was trying to do anything I could to increase performance. We have already gone down the list of indexing tuning, adding HW, etc. I am now thinking about disabling torn page detection. The storage has redundant power, has a backup generator just incase and a battery backup for the write cache on the controller. If I do disable it and I do get a torn page, would a CheckDB find it? If not, how would I ever know?