I had posted some questions on here about a month ago regarding problems with a clients SQL server. I have spent the last month doing alot of research on the subject and after isolating the mdf, ldf, and tempdb files the SQL server is still showing
IO waits that indicate that the IO system is not capable of maintaining the performance standards and average read write times well above 2ms ... Right now the mdf is on a two disk raid one and the ldf, tempdb are on separate (i know this is not a stable long
term configuration for stability)
Top waits are ...
I'm thinking about getting a 12-24 disk SATA or SAS raid array and card, the company is only going to grow and the IO pressure is not going to decrease. The server is a dell power-edge 710. I'm very interested if anyone can point me in the right
direction with this purchase. I'm trying to keep it under 7,000 but I would be able to break up the SQL files onto separate raids ... I was thinking about