Microsoft Dynamics 365 | Integration, Dataverse...

How to check what i causing DataverseSearch table to grow

(1) Share

Report

Posted on by SW-11070625-0

As per above - is it possible to see what indexinf causes this exactly?
Maybe there some powershell script or external tool to check?

Categories:

Power Platform integration

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

ManoVerse

704 Super User 2026 Season 1 on at

Like (1)

Report

Copy link

Link copied!

2025 change (enhanced semantic indexing / Copilot-related indexing) increased DataverseSearch storage for organizations. Today you cannot see per‑table or per‑column index consumption directly, but you can narrow down the cause using these built‑in tools:

1. “Manage Search Index” :

Go to Default Solutions ->Overview -> Dataverse Search -> Manage Search Index.

This screen shows which tables and how many indexed columns are contributing most to index size. This is currently the only UI that reveals index impact per entity.

2. Check Quick Find views
Dataverse Search indexes are created from Quick Find view columns, not from “search‑enabled fields.”
Large tables + many Quick Find columns = big index growth.

you can optimize the usage based on your weightage finding for data type you are using for your table in search columns. if you want you can run this below query in postmen with authentication and convert JSON result in to csv , it will give you fetchxml for all quick find views where you can see filter and search column used which increase the index size.

https://yourorg/api/data/v9.2/savedqueries?$select=name,returnedtypecode,querytype,fetchxml,layoutxml,statecode&$filter=querytype eq 4 and statecode eq 0

below table you can refer for calculating weightage for your table and you can optimize your quick finds accordingly.

Field Type	Weight
Boolean	1
Whole Number / Decimal / DateTime	1
Choice	2
Multi‑Select Choice	3
Lookup	3
Email / Phone / URL	3
Single Line of Text	2
Multiline Text	5

high weight means heavy size indexing.

3. Use Search Statistics API
Use the searchstatistics API to see overall index size and document count (not per table, but confirms growth pattern).
Docs: /api/search/v2.0/statistics Also on porta you can see your chart how its growing

Refer : Dataverse Search statistics and status (Microsoft Dataverse) - Power Apps | Microsoft Learn

Regards,
Manoj
✅If this answer helped you, please consider marking it as Verified, it really helps others in community

Was this reply helpful? Yes No

Suggested answer

Tom_Gioielli 3,076 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If you are wondering about recent growth in table DB size, Microsoft changed up the Dataverse Search table last fall to also include Copilot and AI details, which caused the size of the table to balloon recently. I think they added more capacity to environments to make up for this change, but it's still not clear this is what is happening.

Was this reply helpful? Yes No