Hello all,
I have a windows 2003 server running sql server 2000 on a raid 5 array. It is used in a real time production environment. It seems that the disk writes are being cached, presumably by the raid controller. The problem is, all of the disk writes occur at that same time periodically. During this time, there is a large disk queue, which affects production since we are unable to perform more disk writes. I have changed the write caching mode on the raid controller to "write-through", but this has not helped. Any ideas would be appreciated.
I have a windows 2003 server running sql server 2000 on a raid 5 array. It is used in a real time production environment. It seems that the disk writes are being cached, presumably by the raid controller. The problem is, all of the disk writes occur at that same time periodically. During this time, there is a large disk queue, which affects production since we are unable to perform more disk writes. I have changed the write caching mode on the raid controller to "write-through", but this has not helped. Any ideas would be appreciated.
