Visual Foxpro 9 Raid Configuration

I have had recent issues with Visual Foxpro 9 apps running on server 2008 and beyond that have a raid 5 configuration. We have found that running RAID 5 configuration causes indexes to become corrupted so our company doesn't recommend RAID 5 configuration. I was asked today by a large firm how many disk I/O arrays would need to be set to allow RAID 50 to be a functional option to run the application. I was stumped by his question. Does anyone know about VFP 9 and RAID configurations using a 40+ user server/client application.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Olaf DoschkeSoftware DeveloperCommented:
I never heard raid to be a cause for index corruptions. It's much more likely because of oplocks and that problem also started with Win 2008, so you may make a correlation that is not the causation.

Google for VFP oplock and turn off smb2 to be able to turn off oplocks and your indexes will get stable again.

Raid, especially hardware raid, will need to be choosen good, if you want to have a performance advantage from it. Raid is helping the typical database random access more in raid Level 10 than in 5 or 50, but if choosing the wrong level, you don't get corrupted indexes, you would only get less performance gain than you think, but still have the advantage of being more failover safe, than without any raid.

Bye, Olaf.
Yes, it seems to be a Windows configuration problem and SMB2/oplocks should help.
Also some RAID arrays are based on Linux and it really requires very good Windows driver which is tested heavily in all possible configurations.

I don't understand what means "40+ user server/client application"?

Obvious FoxPro app configuration is data shared by clients on a File server. Clients must run all queries and all data and indexes are transferred over the network. This configuration is sensitive to SMB2/oplocks settings.

Client/server means all queries are executed by the SQL (obviously) engine on the server and results are transferred to clients. Server engine accesses data locally which is fast and reliable.

We are using C/S configuration and relatively weak server did serve 100 simultaneously working users. The server engine is also FoxPro running as multithreaded COM DLL.

The new server W 2008 R2, 256 GB RAM, 2 CPU (24 threads), and 2 TB RAID 5 is sleeping almost all the time... 150 users generate 1% network load and 5% CPU load at most. All data are in cache so it is incredibly fast...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.