Opportunistic Locking

I often get Database or Index Corruption hosted in Windows Server PCs. Is it related to Opportunistic Locking?? How to solve it??

To solve this, you should do the following:

  1. Run RegEdt32.exe
  2. Open HKLM\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
  3. Click Edit - Add Value menu
    - Value Name: EnableOplocks
      Data Type: REG_DWORD
      Data: 0
    - Value Name: CachedOpenLimit
      Data Type: REG_DWORD
      Data: 0
    - Value Name: AutoDisconnect
      Data Type: REG_DWORD
      Data: FFFFFFFF
  4. Restart the Windows Server
For further information, please read the related Microsoft Knowledge Base articles.