Share via

.sql.azuresynapse.net vs *.database.windows.net

sakuraime 2,321 Reputation points
2021-05-01T15:29:53.637+00:00

I have two Azure synapse dedicated pool , one in .sql.azuresynapse.net and another one is in *.database.windows.net

what are the difference ? performance or other difference ?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,696 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee
    2021-05-03T14:29:45.23+00:00

    Hi @sakuraime ,

    Thanks for your query.

    If the Synapse dedicated pool is created outside of Synapse Workspace [existing DW customers - formerly Azure SQL DW)] then it is - *.database.windows.net

    If it’s created from a Synapse Analytics Workspace then it is - .sql.azuresynapse.net

    Technically it's just a DNS cname record done for branding purposes: foo.sql.azuresynapse.net points to foo.database.windows.net. There should be no performance difference in actual client-server interaction.

    Hope this clarifies.

    ----------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.