Forum Discussion

MichelleTW729's avatar
MichelleTW729
Helper I
1 year ago
Solved

Compare Fabric DW and Azure SQL performance

I have a project User need DW and Power BI , we try promote Fabric service , but also need compare ADF+AzureSQL which will better ? any compare table about Fabric capacity (F8 ) would near Azure SQL ...
microsoft fabric
  • AndyDDC's avatar
    AndyDDC
    1 year ago

    Hi MichelleTW729 in terms of directly mapping compute power between Fabric Warehouse and Azure SQL Database, we first look at the number of cores that will be used in the Fabric capacity.  For each 1 CU, this gives us 0.5 vCores for the Warehouse service.  So an F8 allows us to have 4 vCores.  In Azure SQL DB, 100 DTU (I believe) maps to 1 vCore, 200 DTU = 2 vCores etc.

     

    Bear in mind that if you have any other Fabric items running on the capacity, they will also consume compute.  E.G. if you have a Warehouse plus Data Pipelines which all run on the F8 capacity, they will share the compute.

     

    You will need to do your own testing in your environment to chek performance is adequate for your project.

     

    ----------------------------------------------------------------------

    If my reply has been useful please consider providing kudos

    and marking as the solution for other community users to find

    ----------------------------------------------------------------------

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi MichelleTW729 ,

 

Thanks for the reply from AndyDDC .On the comparison of Fabric DW (F8) and Azure SQL P1 or S3/S4, he makes a good point.

 

A brief summary of how Fabric Data Warehouse compares to ADF+AzureSQL is as follows:

 

Fabric Data Warehouse: Better performance and scalability for large-scale analytics projects that require Data Warehouse and Power BI integration.

 

Azure SQL with ADF: Ideal for projects that require more data integration flexibility and handle smaller workloads.

 

Feature

Fabric Data Warehouse

Azure SQL P1/S3/S4

Data Storage

Delta lake format in OneLake

Relational storage

Query Performance

High performance, scalable

Robust

Integration with Power BI

Seamless integration

Flexible, needs more configuration

Suitable Workloads

Large-scale data warehousing

Small and medium-sized data processing

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!