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:
- Run RegEdt32.exe
- Open HKLM\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
- 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 - Restart the Windows Server