cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

prasadvaze
by Valued Contributor
  • 4835 Views
  • 12 replies
  • 8 kudos

Azure Synapse versus databricks SQL endpoint performance comparison

Has anyone done this and share details? I have a sample sql which ran on large SQL endpoint in 8min and synapse 1000DWU setting in 1hr. On small SQL endpoint it took 34min. What's the equivalent SQL Endpoint compute for Synapse@1000DWU? I know th...

  • 4835 Views
  • 12 replies
  • 8 kudos
Latest Reply
sammyadam
New Contributor II
  • 8 kudos

DC region has an iota of contribution to the speed. An assumption also includes the cost is out of the equation.

  • 8 kudos
11 More Replies
tariqph
by New Contributor II
  • 1708 Views
  • 6 replies
  • 1 kudos

SQL endpoint vCPU on Azure

How do I change the vCPU type for SQL Endpoint on Azure Databricks? Currently it picks as default DSv4 CPUs which reaches its quota limit although I have unused quota in other vCPU types. I faced similar issue while using Delta live tables but I was ...

  • 1708 Views
  • 6 replies
  • 1 kudos
Latest Reply
Prabakar
Esteemed Contributor III
  • 1 kudos

Hi @Tarique Anwar​ , I don't think changing the vCPU type, for now, is possible. However, I can check with the product team on this.https://docs.microsoft.com/en-us/azure/databricks//sql/admin/sql-endpoints#required-azure-vcpu-quota

  • 1 kudos
5 More Replies
bas
by New Contributor III
  • 484 Views
  • 0 replies
  • 0 kudos

SQL endpoint cluster disks

When I read https://docs.microsoft.com/en-us/azure/databricks/sql/admin/sql-endpoints#cluster-size, it says : Each driver and worker has eight 128 GB Standard LRS managed disks attached. Attached disks are charged hourly.My question is, why do e...

  • 484 Views
  • 0 replies
  • 0 kudos
Labels