• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 961
  • Last Modified:

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.

2 Solutions
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...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now