Also I suggest turning off Opportunity Oplocks on the workstations where again you are accessing shared database files with the SMB/CIFS/SAMBA protocols.
[code
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MRxSmb\Parameters]
"OplocksDisabled"=dword:00000001
Where turning off Oplocks has decreased performance to an extreme undesirable effect on certain routines.
We have those routines run only on a single machine where Oplocks is allowed and tune the SME server's SAMBA settings
of veto oplocks to not allow certain files to be accessed in a Oplock state.
For Windows OS above XP, meaning Vista, Windows 7, and Windows 8.1
In my testing, if SMB version 1 is used to access the SME shared files. By making the above setting. It will turn off Oplocks for files on a SME server if the Samba is set to allow files only with the SMB1 protocol while preserving Oplocks to other connections where SMB2 is the protocol used.
Now Microsoft has started using the word Lease with SMB2 and up rather than Oplock.
Oplock is where a client makes use of file cache on the workstation with files opened on a network SMB share.
This is typically bad where networked type files are opened in a shared state where a write to an open shared file takes place.