We have recurring problems with our Sage 50 2015 data. We suffered some corruption recently and it had to go to sage for repair. The data came back 3 weeks ago and since then we have had corruption a further 2 times which resulted in having to restore a good backup and re-entry of missing transactions.
Our network setup is as follows
HP DL380 g8 6 Core Xeon, 32GB RAM, 4x 600GB 10K SAS drives in RAID 6, VMWare 5.5 Essentials.
Virtual Server 1
Windows server 2012 R2 - DC - Fileshares -Widows 2012, 4 vCPU, 120GB Drive C, 300GB Drive D, 8GB RAM
Virtual server 2
Windows server 2012 R2 - Remote desktop server - 8vCPU, 120GB Drive C, 300GB Drive D, 8GB RAM
Data and sage data service sits on server 1, Using sage on this machine gives excellent performance as expected. Using Sage on the RDS is fine except when posting invoices and doing bank rec's. Today it took more than 15 minutes to update 20 invoices (approx 20 items per invoice) and while the ledgers were updating, all other users were locked out saying, "waiting to lock file". It now turns out that we have corruption again and will have to restore and re-enter.
I have checked AV exclusions, and performed network testing and I'm confident that it is not infrastructure causing the problem but I cannot seem to get this issue resolved. My data is fairly huge with approx 56000 invoices and 373000 transactions. We will archive and reduce these in an effort to ease the situation.
Is anyone aware of any other things I can try to get the bottom of this?