>> There are between 100 and 150 user, with these tables open most of
the day.
Maybe the number of users coupled to the fact that the tables are always
open is causing the problem
Wouldn't it be better to open the table when the user has to read or
write to them and close them immediately after the data is pulled or saved?
Instead of putting the tables in the dataenvironment could you not open
them when needed? Of course this would imply modifying all the forms,
but then.....
150 users means 150 machines and some physical problem with the network
cards could cause index corruption.
Rafael Copquin
El 13/05/2015 a las 16:58, Tracy Pearson escribió:
The way the program is written:
Tables are opened in the FORM DataEnvironment, Edit is done, then Saved.
The initial change to the save can be several minutes as the user is talking
to a customer.
There are between 100 and 150 user, with these tables open most of the day.
The new environment:
SAN hosts VMs
Dedicated VM for data files, Server 2012.
Citrix running on Server 2008 R2.
Old environment:
Physical boxes
Dedicated Server 2003 (SMB 2 is disabled)
Citrix running on 2003 servers
Migration began after testing the VM data server with the 2003 servers.
Index corruption was reported within hours of some users being on the 2008
R2 servers.
Write Cache appears to be off in the Server 2012.
Is the Opportunistic Locking the probable culprit of the corruption noted
here?
Thank you,
Tracy
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
