Slow internet connection and/or high latency to the remote data center
SQL server extremely slow
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
2 answers
Sort by: Most helpful
-
-
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.