We have a customer who run a third party database application related to their business of property rentalls.
On the advice of the developer of the software they run a twice daily data integrity check due to frequent data damage. At least twice a week the checker reports that the data is damaged and must be restored from backup resulting in the loss of half a days work.
Following a list of prerequisites set out by the developer we have extensively reconfigured the system with memory upgrades, power management settings, replacement of unsupported NIC chipsets and even recabling of the office.
The application has a diagnostics utility which lists these prerequisites one being write Caching being enabled.
They have a Dell PE840 with a Perc5/i raid controller in a raid 5 config and Dell PCs (optiplex and Dimension) all running xpsp2.
Dell tech support have confirmed that write caching cannot be completely disabled on the server with this Raid config but that on the PCs write caching is a software setting only.
We have disabled write caching in windows under the policy tab on the properties of each disk yet the Diags utility still reports that write caching is enabled.
Because of this the developer is refusing to look any further.
Is there anywhere else we can look or is this just the way it is (as we believe) with modern systems??
The server runs server 2003 SBS and all that goes with it without any problem.
We would love the cutomer to ditch this system and use a more robust application.