Latency storage in Azure SQL managed instance

• Lou

  SSCrazy

  Points: 2929

  More actions

  September 9, 2023 at 12:53 am

  #4282786

  Hi Colleagues,

  In the old-fashioned On-Premise SQL Server installations, more than ten constant ms for accessing the data file was a sign of alerting.

  However, using the same measure in Azure SQL-managed instances is strange. It is because you see hundreds in the overall latency.

  Any recommendation that we can use to help us troubleshoot performance issues?

  Thank you for your ideas,

   

   

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  September 10, 2023 at 1:10 am

  #4283386

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• CreateIndexNonclustered

  SSChasing Mays

  Points: 648

  More actions

  September 11, 2023 at 5:35 pm

  #4284349

  latency that high is bad no matter where you are running it. You may be exceeding the limits of the MI service.

  This lists the resource limits Resource limits - Azure SQL Managed Instance | Microsoft Learn

  I would be curious to know what your MI specs are and the type of workload. Am planning on implementing it myself.

  Have you looked at any of the slowest queries yet for indexing or tuning?