>>As for buffering on the server, never...ever... use write caching on the server unless the disk controller is specially designed to work with databases. This advice is not just for Fox data. I've been reading SQL Server Books Online lately and that warning is all over in there.
>
>In your experience, what are the drive controller manufacturers whose products have been "specially designed to work with databases"?
I can't say I know of one above another. Just what the docs are saying.
>
>It's a bad idea to extrapolate SQL Server to all back-end or file-server databases. All applications, not just databases, are supposed to delegate file I/O to the OS; most have no other choice. However, SQL Server enjoys a (too?) close relationship to NT/W2K and uses a lot of tricks to improve performance. It's not surprising the SQL Server docs are littered with warnings.
Issues are different with databases apps as opposed to non-database apps. Word, for example, pulls the entire document into memory. Database apps inheritly have problems with write caching because of what they do.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer