web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

I/O cost with BYOD/Export to data lake/Custom services/Odata

(0) ShareShare
ReportReport
Posted on by

Hi All,

I would like to know is there any Input/Output cost associated with Production D365F&O environmenti, if we ready data from this enviornment using either of these methods:

  • BYOD
  • Export to data lake
  • Odata
  • Custom servcies
  • DMF

Thank you

  • Suggested answer
    Mohit Rampal Profile Picture
    12,573 Moderator on at

    Hi Jeff, We were investigating same for BYOD in production due to slow performance on many batch jobs. For BYOD (Azure SQL Database) IO is associated with tiers. The expensive tier you choose, more IOPS capacity you will get.

    check this out

    learn.microsoft.com/.../service-tiers-sql-database-vcore

    learn.microsoft.com/.../service-tiers-dtu

    In this screenshot, GP is General Purpose, BC is Business Critical and HS is HyperScale (Compute Tiers of Azure SQL Database)

    Note that BC & GP can be switched anytime but if Hyperscale is selected, you can switch back within 45 days, after 45 days it can't change.

    5340.MicrosoftTeams_2D00_image-_2800_5_2900_.png

    OData will need more IO as its row by row, DMF comparatively less due to set based operations.

    check this article

    community.dynamics.com/.../choosing-between-odata-and-data-management-in-microsoft-dynamics-365-finance-and-operations

  • Suggested answer
    nunomaia Profile Picture
    27 Moderator on at

    The cost isn't in D365 side.

    In BYOD you have the cost of Azure SQL Server. In Data Lake you make Blob Storage cost, etc.

    D365 licensing allows the use of these services.

  • JeffGreenrc Profile Picture
    on at

    Hi,

    Thank you for your responses.

    I agree, ofcourse the either approach i.e. BYOD (Azure SQL Server) or data lake (azure storage) is going to cost us. However, I want to know are there any other cost needs to be included as part of I/O operations. With these we will be doing READ and Output.

    Thanks

  • Suggested answer
    Mohit Rampal Profile Picture
    12,573 Moderator on at

    Hi, As per my understanding there won't be other cost involved.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#2
CU10121822-0 Profile Picture

CU10121822-0 366

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 360 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans