Forum Discussion
Compare Fabric DW and Azure SQL performance
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
----------------------------------------------------------------------
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
----------------------------------------------------------------------