Windows 2008 server and datafiles

[Derek Delpero]

Hi Juan,

What specifically do you mean by disk caches?

Thanks to everyone for all the feedback.

Derek


On Mon, Dec 6, 2010 at 5:23 AM, Juan Bofill <bofill at cantv.net> 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
>> http://www.webpublisherstudio.com
>> Omnis Studio Database Server Integration Toolkit
>>
>>
>>> From: Derek Delpero <derek.delpero at gmail.com>
>>> Reply-To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
>>> Date: Wed, 1 Dec 2010 15:52:21 -0600
>>> To: <omnisdev-en at lists.omnis-dev.com>
>>> 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 (http://support.microsoft.com/kb/296264), 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 http://lists.omnis-dev.com
>>
>>
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>