This document was posted to the comp. This is reproduced below in its entirety, in order to ensure that the link does not vanish. The link to the original posting can be found here. This document is not reproduced with permission, but we are currently seeking the author in order to correctly attribute the contents of this page. The article is virtually as it was posted, minor spelling corrections and markup to make it consistent with our site have been applied.
In this article I would like to explain the basic idea of oplocks, which problems they implicate for network applications and, last but not least, various strategies how to increase performance and reliability of your network application. Opportunistic locks oplocks are a characteristic of the LAN Manager networking protocol implemented in the Bit Windows family of operating system environments. Bascially, oplocks are guarantees made by a server for a shared logical volume to its clients.
So much about the theory, in practice the LAN Manager introduces with oplocks an additional protocol on top of the well known standard file-system level locking protocol. This is done for performance reasons. Only with oplocks the server and its clients are allowed to cache data read ahead or defer writes to a file write behind. In other words, oplocks are introduced to synchronize the data in an environment of multiple workstations, each of which having their own local cache, sharing a file via a file-server.
Windows To reduce the chances of this problem on computers that are running Windows , you must install Windows Service Pack 3 SP3 or a later Windows service pack on the Windows file server where the Access database file is located, and then on each Windows client computer that connects to the Windows file server. For more information about how you can obtain and then install the latest Windows service pack, click the following article number to view the article in the Microsoft Knowledge Base:.
Windows XP To avoid the problem on computers that are running Windows XP, install the security update that is mentioned in the following Microsoft Knowledge Base article on each Windows XP client computer that connects to the file server where the Access database is located.
Important Disabling opportunistic locking may adversely affect the performance of other applications. If you have questions about this, contact Microsoft Windows technical support. For more information about disabling opportunistic locking on Windows NT 4.
For more information about disabling opportunistic locking on Windows , click the following article number to view the article in the Microsoft Knowledge Base:. To disable opportunistic locking on a Novell file server, Microsoft recommends that you contact Novell technical support. For information about how to contact Novell, click the appropriate article number in the following list to view the article in the Microsoft Knowledge Base:.
Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.
Office Office Exchange Server. Not an IT pro? Windows Server TechCenter. Uninstall A Desktop formerly named Autodesk This software has been retired. Prevent the computer from going to sleep.
Delete all temporary files see How to delete temporary files in Windows. Reboot the network server. Click Disable offline files and then click OK. Turn off Allow files in the folder to have contents indexed in addition to file properties. Click OK. Confirm that full read-write-modify permissions are on the folder location being saved to.
Check latency or lag time between AutoCAD and the server Workstations may not be getting cues from the server about file locks at the right time or contrariwise. Test saving and resaving to the local drive and then to a share on another workstation to pinpoint the problem network location.
For information about how to contact Novell, click the appropriate article number in the following list to view the article in the Microsoft Knowledge Base:. Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information. Was this reply helpful? Yes No.
Sorry this didn't help. Thanks for your feedback. Justin Shafer. In school, we were told to keep opportunistic locking turned off for databases that are being shared over a network where multiple users are reading and writing data simultaneously. I am using some software called dentrix, and long story short, it runs a LOT faster with oplocks enabled. One program takes 60 seconds with it disabled, and 1 second with oplocks enabled.
0コメント