Overview
In case you have issues with 'Optimize Database (Thorough)', there are specific logs that can be enabled to provide more information about the issue. Please send those logs to M-Files Support for further investigation.
Solution
You can enable logs with these server-side registry settings:
[HKEY_LOCAL_MACHINE\SOFTWARE\Motive\M-Files\<ersion>\Server\MFServer\Logging]
"Enabled"=dword:00000001
"EnableVerboseLogging"=dword:00000001
"LogDir"="%TEMP%\MFilesLogs"
"FlushIntervalInSeconds"=dword:0000000a
"LogCategories"=dword:00000100
All the values are Hexadecimal. By default the location of log files is %TEMP%\MFilesLogs. (In test environment: C:\Windows\Temp\MFilesLogs.)
Enabled and EnableVerboseLogging are set to 0 by default, change the values 1 to enable logging. No need to restart M-Files Server services.
If the Thorough Optimization is slow, use the following value for LogCategories: 0x1188 and set EnableVerboseLogging to 0x2. This will include more information about other background tasks that are running and maybe interfering or causing slowdown.
