troubleshooting Question

Large SQL data read and writes required for our Application - What Hard drives would help most?

Avatar of tmorita
tmorita asked on
Microsoft SQL ServerStorageMicrosoft Applications
6 Comments5 Solutions398 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
David
President
Join our community to see this answer!
Unlock 5 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 5 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros