SQLdatabse table in Azure service taking over 8 minutes for simple query

Siddharth Jain 1 Reputation point
2022-05-02T09:25:30.533+00:00

SQLdatabse table in Azure service taking lot of time in execution of simple select query, tried to create indexes for the columns added in where clause but still response time of query is going over 8 minutes

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Luis Rodriguez 6,201 Reputation points Microsoft Employee
    2022-05-02T09:44:50.367+00:00

    Hello @Siddharth Jain

    Welcome to Microsoft Q&A Platform,

    If not done yet I would suggest following the documentation below on how to improve the DB performance and troubleshoot this kind of scenarios:
    https://learn.microsoft.com/es-es/azure/azure-sql/database/performance-guidance?view=azuresql
    https://learn.microsoft.com/es-es/azure/azure-sql/identify-query-performance-issues?view=azuresql

    If you hit issues please let us know or you can raise a suppor ticket if you have a support plan.

    I hope this helps!

    ----------

    Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments