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

sakuraime 2,271 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.
2,622 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 33,136 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.