SSMS slow connecting to Azure SQL

Ahmad Hazari Haris 0 Reputation points
2024-07-10T07:24:25.81+00:00

I am running MS SQL 2019 on Azure and using SSMS from my laptop. It was slow running SSMS from my laptop. Did i missed something to have a good speed running SSMS connecting to Azure SQL.? Appreciate that assistance.

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,343 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 106.8K Reputation points
    2024-07-10T12:52:34.06+00:00

    Is it always slow, or is the first connection slow and the rest are quick? If your database is serverless, you need to account for that it takes time to load the database on to a server.

    This is a bit of pain with serverless databases. But only a bit, when you take in account how much money you save with serverless.

    0 comments No comments