SSMS connection is slow with IP Address but fast with server name
I’m in a case where my connection to the database server is very slow. Currently, I’m using SSMS to connect to it by IPAddress and Port.
The connection string looks like this: IP_address, portInstance name.
This takes about 10-12 seconds to connect, any actions such as expanding tables, querying, or just simply clicking would take the same amount of time.
If I follow these 2 methods, it connects super fast as if I were connecting to the local database.