Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by JeffGreenrc

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

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

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.

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

Was this reply helpful? Yes No
Suggested answer

nunomaia 25 Moderator on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
JeffGreenrc on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

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

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

Was this reply helpful? Yes No