SQL SERVER connecting very slow from windows server 2016 to Microsoft Azure using management studio via VPN

IT Al Amri 1 Reputation point
2022-06-19T11:31:54.917+00:00

Hi,

VPN connectivity initiated between Windows server 2016 and Microsoft Azure.

On windows server 2016 I am using management studio 2014 & SQL Server 2014, I am able to connect using management studio to Microsoft azure but the connection is too slow.

At the beginning to connect it was taking more than 2.50 minutes, later I did changes in connection string (set to 180) while connecting now the time has reduced to 45 seconds.

When I am trying to connect Microsoft azure from windows 10 via management studio through a local pc on the same network, it is connecting less than 5 secs.

I have checked the following

  1. Firewall
  2. Ports (exceptions added in & out on both the servers)
  3. IPv4 (IPv6 unchecked on both servers)
  4. Connection string set to 180

please help to resolve this, thanks in advance.

SQL Server on Azure Virtual Machines
Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,457 questions
Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,371 questions
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,710 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,127 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Limitless Technology 39,351 Reputation points
    2022-06-21T08:16:01.197+00:00

    Hi there,

    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.

    I would suggest you to check the Microsoft Azure Service Dashboard for any known outages that occurred during the time during which the errors were reported by the application.

    Applications that connect to a cloud service such as Azure SQL Database should expect periodic reconfiguration events and implement retry logic to handle these errors instead of surfacing application errors to users.

    SQL server extremely slow https://learn.microsoft.com/en-us/answers/questions/462130/sql-server-extremely-slow.html

    Troubleshooting connectivity issues and other errors with Azure SQL Database and Azure SQL Managed Instance https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql

    ---------------------------------------------------------------------------------------------------------------------------------------------------------

    --If the reply is helpful, please Upvote and Accept it as an answer–

    0 comments