Overview
Tuning advisors, including the Database Engine Tuning Advisor (DTA), should not be used with M-Files databases. M-Files maintains its own databases during the thorough optimization and no manual maintenance, backups excluded, are needed.
Implementing recommendations, such as adding indices or statistics or management plans, suggested by some tuning advisors, may cause (severe) adverse results.
They may in fact degrade performance by creating additional indices. When new M-Files versions become available, any unexpected index may cause upgrade failure and render the system unavailable as the upgrades from time to time may modify the database layout.
Solution
In case of performance problems please contact M-Files technical support instead of attempting to solve these via such tools or other means which will make changes to the database.
If you have already used the Database Tuning Advisor (DTA) or similar tools to modify the database, you may need to undo all the changes this tool has made to the database, including removing any additional indices and statistics.
Please contact M-Files Support if additional information is needed.
Reference Documents
Database Engine Tuning Advisor:
https://learn.microsoft.com/en-us/sql/relational-databases/performance/database-engine-tuning-advisor?view=sql-server-ver16
Performance Improvements using Database Engine Tuning Advisor (DTA) recommendations:
