Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Relevance Search takin...
Customer experience | Sales, Customer Insights,...
Suggested answer

Relevance Search taking lots of Database Space

(3) ShareShare
ReportReport
Posted on by Inkey Solutions 2,051

Hi Team,

 

Our database storage has increased significantly due to Relevance Search. It has jumped from 641 MB to 4172 MB in one day. Is there any way we can bring this down?

 

Any kind of help will be greatly appreciated.

 

Thank You

  • Suggested answer
    Daivat Vartak (v-9davar) Profile Picture
    Daivat Vartak (v-9d... 7,801 Super User 2025 Season 1 on at
    Relevance Search taking lots of Database Space
    Hello Inkey Solutions,
     

    You've hit a common and often surprising consequence of enabling Relevance Search in Dynamics 365: a significant increase in database storage consumption. This is because Relevance Search creates and maintains a separate index of your data for faster searching.

    Here's a breakdown of why this happens and how to manage it:

    Why Relevance Search Increases Database Storage:

    • Indexing: Relevance Search creates an external index of your data, separate from the primary database tables. This index is optimized for fast text-based searches.
    • Data Duplication: The index essentially duplicates a significant portion of your data, leading to increased storage requirements.
    • Index Size: The size of the index depends on the amount of data you're indexing and the number of entities and fields included.

      •  

    Strategies to Reduce Relevance Search Storage:

    1. Limit Indexed Entities:

       

      • Identify Critical Entities: Carefully evaluate which entities are truly essential for Relevance Search.
      • Remove Unnecessary Entities: Exclude entities that are rarely searched or contain large amounts of non-text data.
      • Go to: Settings > Customizations > Customize the System > Relevance Search > Select Entities.

    2. Limit Indexed Fields:

      • Focus on Searchable Fields: Index only the fields that users commonly search.
      • Exclude Large Text Fields: Avoid indexing very large text fields (e.g., notes, descriptions) unless absolutely necessary.
      • Go to: Settings > Customizations > Customize the System > Relevance Search > Select Entities > Select Entity > Select Fields.

    3. Optimize Data:

      • Data Cleanup: Remove or archive unnecessary data, such as old records or attachments.
      • Data Deduplication: Eliminate duplicate records.
      • Data Compression (If Applicable): Some large text fields might benefit from compression, though this is less common in Dynamics 365.

    4. Rebuild the Index:

      • After making changes to the indexed entities or fields, rebuild the Relevance Search index.
      • This will ensure that the index reflects the current configuration and data.
      • Go to: Settings > Customizations > Customize the System > Relevance Search > Rebuild Index.

    5. Monitor Storage Usage:

       

      • Regularly monitor your database storage usage to track the impact of Relevance Search.
      • Use the Dynamics 365 Administration Center to view storage metrics.

    6. Consider Alternative Search Methods (If Applicable):

      • If Relevance Search is causing excessive storage consumption and your search requirements are not very demanding, consider using the traditional Quick Find search.
      • Quick Find search does not create a separate index and therefore has a lower storage footprint.

    7. Microsoft Support:

      • If you've tried these steps and are still experiencing excessive storage consumption, contact Microsoft Support.
      • They can provide further guidance and assistance.

        •  

      8.  

    Important Considerations:

    • Performance Impact: Reducing the number of indexed entities or fields might affect search performance.
    • User Requirements: Balance storage optimization with user search requirements.
    • Testing: Thoroughly test any changes to the Relevance Search configuration to ensure that search functionality remains adequate.

      •  

    Steps to Take:

    1. Identify the largest entities indexed for Relevance Search.
    2. Remove unneeded entities and fields from the relevance search configuration.
    3. Rebuild the Relevance Search index.
    4. Monitor the storage usage.

      5.  

    By following these steps, you should be able to bring down the database storage consumption caused by Relevance Search. Remember to prioritize user search needs while optimizing storage.

     
    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more. If you have further questions, please feel free to contact me.
     
    My response was crafted with AI assistance and tailored to provide detailed and actionable guidance for your Microsoft Dynamics 365 query.
     
    Regards,
    Daivat Vartak
  • Nels Benson Profile Picture
    Nels Benson 29 on at
    Relevance Search taking lots of Database Space
    Did you ever find an answer to this? 
  • Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Relevance Search taking lots of Database Space
    Hi,
     
    According to the official documentation.
    You can reduce the table size by removing Find Columns, View Columns, and Filter conditions for one or more tables.
    You can turn off Dataverse search to remove all indexed data. It may take up to 24 hours after reducing the number of indexed columns or turning off Dataverse search.
     
    Alternatively, the following threads have similar issues, and you can refer to the replies therein.
    Solved: What is the RelevanceSearch in the power apps data... - Power Platform Community (microsoft.com)
    CRM Dynamics 365 - Sudden increase of Database capacity because of relevance search

    Best Regards,
    Dengliang Li
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans