In SSMS, when connecting to any of our Azure SQL Databases using service accounts and SQL server authentication, the connecting itself can take between 10 to 15 seconds to establish.

Once connected, right click on any table and click on "select top 1000 rows" this also takes between 10 and 15 seconds to respond and present the rows in SSMS.

None of this delay/lag occurs when using "Active Directory - Universal with MFA Supprt" authentication - however, this isn't using the same service accounts.

How can the SQL Server Auth lag be resolved/investigated?

  • What is the difference in term of query waits? Determine query waits using this sqlcoffee.com/Azure_0017.htm – Alberto Morillo Mar 22 '19 at 21:18
  • Do you see any changes on query plan generated when it takes more time vs when it executes with no lag? – Alberto Morillo Mar 22 '19 at 21:20
  • 1
    I saw the same. If you connect via SSMS using the default administrator account the speed is beautiful. The moment you create a user/login and use that credentials its sluggish just like you explained! – Rey Jul 15 '19 at 13:40
  • @Geezer were you ever able to resolve this? I'm having the same issue and it's super frustrating! – SqlRyan Sep 29 '19 at 0:52
  • @SqlRyan - dropping and recreating the SQL user associated with the service account resolved it for us – Geezer Sep 30 '19 at 8:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.