Windows 2008 server and datafiles

[Juan Bofill]

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