Windows 2008 server and datafiles

Derek Delpero derek.delpero at
Wed Dec 8 19:24:03 EST 2010

Hi Juan,

What specifically do you mean by disk caches?

Thanks to everyone for all the feedback.


On Mon, Dec 6, 2010 at 5:23 AM, Juan Bofill <bofill at> wrote:
> How about disk caches? Can you turn them Off or On as in 2003 Server?
> Juan Bofill
> On 03-12-10, at 01:04, Kim Sumner wrote:
>> Hi Derek
>> We had a similar problem at a site where the data file corrupted every few
>> weeks. Invariably the database needed to be recovered and the errors always
>> referred to problems with block allocation. My hunch is that the server
>> environment (in this case a VM installation of W2003 Server) is somehow
>> interfering with O7 trying to resize the segments.
>> I've recently tested my theory by manually growing the data file well in
>> excess of their likely usage. I've twice checked the production ODF since
>> this was done and so far no problems. I intend to repeat integrity tests
>> after 3 months deployment to see whether this strategy has made any
>> difference.
>> (Note: We have an identical O7 site that's not virtualised and it has
>> _never_ experienced any corruption problems. Hence my suspicions. Both sites
>> have been in production using our software for over 10 years and corruption
>> only emerged when one site moved to W2003 Server).
>> Kim Sumner
>> Corporate Windows Pty Ltd, AUSTRALIA
>> WebPublisher Studio - Share your data with the World
>> Omnis Studio Database Server Integration Toolkit
>>> From: Derek Delpero <derek.delpero at>
>>> Reply-To: OmnisDev List - English <omnisdev-en at>
>>> Date: Wed, 1 Dec 2010 15:52:21 -0600
>>> To: <omnisdev-en at>
>>> Subject: Windows 2008 server and datafiles
>>> Hi,
>>> We have some sites that recently upgrade their servers to Windows
>>> 2008. The app is Omnis7 with a multi-user data file. They've been
>>> running pretty solid for years, and since the upgrade they've been
>>> having a lot of data corruption issues with indexes and duplicated
>>> rsns.
>>> We looked at disabling opportunistic locking but according to this
>>> Microsoft kb article (, it's
>>> not possible to disable opportunistic locking in Windows 2008.
>>> Does anyone know if disabling SMB2 is the only option? Any
>>> disadvantages of disabling SMB2?
>>> Thanks,
>>> Derek
>>> _____________________________________________________________
>>> Manage your list subscriptions at
>> _____________________________________________________________
>> Manage your list subscriptions at
> _____________________________________________________________
> Manage your list subscriptions at

More information about the omnisdev-en mailing list