I have a VFP database application that was affected by the introduction of opportunistic locking on Windows server. Some of my cients have fixed this by disabling oplocks, while others have moved the application to either the server as a published application or by adding an application server like ThinStuff. Disabling oplocks seems to be the easiest change, but my understanding of it is that it might affect the response time on other types of software that requests locks from the server.

The affect of oplocks on my application is very serious, since it opens multiple tables, while the clients who have disabled oplocks have not reported noticing any problems in other software and saw an obvious improvement in performance for the database. That client had a "basic" Windows Server 2012. The current client that I need to help has Windows Storage Server 2012 R2.

My question: Since the difference seems to be the kind of lock that is automatically given, how much of an affect does this really have on other software, and what kind of software would that typically be? My clients are small businesses that are more likely to have Office and CAD software than anything else. Thanks!