Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

BYOD and entity size

(0) ShareShare
ReportReport
Posted on by 245

Is there guidelines on the amount of data that can be exported to BYOD before we need to consider Azure data lake?  We have some very large tables/entites (think Docuref, vendtrans, etc.) that have millions of rows, or multiple GB in size, we prefer to access all the data via TSQL so exporting to BYOD seems simplest/most logical for us.  However one of our D365 developers said initialization or re-initialization can be unreliable or costly in terms of time/hours and is not easy to troubleshoot if something goes wrong.  For example, if there is an issue with change tracking for, say, Docuref table or entity, and we had to reinitialize, it may take many hours.

As we are not in production yet, I cannot test/verify this, so I'm looking for guidance.

  • nunomaia Profile Picture
    nunomaia 9 Super User 2024 Season 1 on at
    RE: BYOD and entity size

    Is not on table size or entity number of fields, but on critical tables.

    I already got feedback from MS that "General Ledger Entries", "InventTrans", don't have support for incremental changes. It works, but we detected some SQL locking on those tables associated with change tracking

  • pnwguy Profile Picture
    pnwguy 245 on at
    RE: BYOD and entity size

    thank you nunomaia - is performance issue unsupported for large tables only, or does that include large entities as well?

  • Verified answer
    nunomaia Profile Picture
    nunomaia 9 Super User 2024 Season 1 on at
    RE: BYOD and entity size

    I don't think there are any official guidelines on that topic. You should consider that many large tables ( ex: InventTrans ), if you enable change tracking and you open a performance ticket in Microsoft, you will get an answer that changing tracking in that table is not supported by Microsoft. Whenever possible use a datalake, for data extractions. For small databases, BYOD is simpler to manage and avoids many of the overhead that datalake has.       

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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans