Large SQL data read and writes required for our Application - What Hard drives would help most?
Posted on 2009-12-20
We have very intensive application that requires large read and writes of data on Microsoft SQL Server 2000. Our application currently stalls without any use of memory or CPU and we think it is because of large read and writes of SQL data.
We are need to find a way to speed up DISK IO and it appears like switching from SCSI with speeds of 33.8 - 67 MB per sec to something very fast like Fusion IO Drive DUO that has read of 1,500 MB per sec and write speed of 1,400 MB per sec would make a real speed difference.
We are running on a Dell 2950 Server and are looking for solutions to dramatically speed up the application.
We are use ESXi on the Dell Server currently with SCSI drives, and still have no performance gain switching to Enterprise 2003 Server and Enterprise SQL 2000.
We desperatly need to speed up our customer experience while we take 9-12 months to re-write the application to not be so read/write intensive.
Any help greatly appreciated.