Overview
In some M-Files performance related issues, it might be useful to see the SQL Server Execution plan to find out the root cause of the issue. For example, if you know that some specific SQL query is causing the slowness in M-Files vault.
Solution
SQL Server Execution plan can be saved in the following way:
- Open Microsoft SQL Management Studio.
- Select the problematic database of the M-Files vault.
- Right-click the name of the database and select 'New Query'.
- Press 'CTRL+M' or select 'Include Actual Execution Plan' in toolbar. It will generate the execution plan after the query has been executed successfully.
- Run the problematic SQL query and you should see the 'Execution Plan' tab.
- Right-click somewhere in the Execution plan tab and select 'Save Execution Plan as..'
- Send the Execution plan to M-Files Support for further investigation by following these instructions: /article/How-to-Send-Files-via-CryptShare-Portal
