question

SybrandBotesMr-6649 avatar image
0 Votes"
SybrandBotesMr-6649 asked Cathyji-msft answered

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

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErikEJ avatar image
0 Votes"
ErikEJ answered ErlandSommarskog commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

And of course, if you are South Africa, but EU and US data centres are at quite some distance, and the speed of light will start to be noticeable if you have something that is chatty. (SSMS is not extremely chatty, but most operations needs a couple of queries forth and back.)

Which service level to you have on your databases?

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @SybrandBotesMr-6649,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.