0

We have several virtual machines on Azure. One running an SQL Server, the others are Windows Virtual Desktop hosts. We have an application on the WVD hosts that connects to the SQL server but it takes forever to connect and start.

When running the application on the SQL machine using 127.0.0.1 to connect, everything works fine. Whenever I use the private IP of the machine, everything slows down immensely (even when running on the SQL server machine)

Alle machines are in the same VNET and region. Everything is also connected to Azure Active Directory Domain Services in the same VNET.

What might becausing the 'slowness'? Where should I start looking?

Thanks in advance!

I've added an image of the network topology. Could it have anything to do with the AADDS Load balancers? (I'm not at home when it comes to load balancing, etc)

Network Topology

Shinhidora
  • 13
  • 4
  • Given that there's a huge performance difference between localhost [127.0.0.1] and the machine's private IP address I'd be going in to SQL Configuration Manager and checking the enablement and configuration of the Server Protocols for anything odd. It sounds like it's using different protocols for localhost and private IP. – AlwaysLearning Jun 30 '20 at 22:03
  • @shinhidora, I'm having a similar issue, when using the private endpoint, the sql queries take 10x slower (literally), did you figure this out? – Chesky May 31 '21 at 19:09

0 Answers0