SQL server extremely slow

Sybrand Botes, Mr 1 Reputation point
2021-07-04T16:04:12.457+00:00

Good day
SQL servers on my account are extremely slow, this seems to be regardless of the databases I deploy to them. I have tried EU and US servers. I am currently in South Africa. All my peers face the same issue connecting to the servers. While using SSMS, even loading a context menu when right clicking on a database is slow. The initial database I created was about 50 empty tables, I have also tried deploying Microsoft's Northwind database to no avail.
I have tried Azure's automatic optimisation, this made no difference.
Hope you can assist
Kind regards

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,769 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ErikEJ 341 Reputation points MVP
    2021-07-04T18:45:42.94+00:00

    Slow internet connection and/or high latency to the remote data center


  2. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2021-07-05T06:43:37.17+00:00

    Hi @Sybrand Botes, Mr ,

    As other mentioned, please check your network performance. It is related to the speed of responses across the network (latency) or to the capacity of the network (bandwidth) connecting your SSMS to the database. i.e. how much data it can transmit in a set time.

    0 comments No comments