API query filter time out issue

Basu Mathapati 0 Reputation points
2024-01-23T01:04:22.7466667+00:00

we recently moved our MSSQL to azure cloud db, due to large data, the API query with filter to the database is getting time out. I'm wondering even millions of records, this shudn't be a problem , while internal db was working ok ? Thanks for your help Regards

Azure SQL Database
Azure Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
619 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 12,386 Reputation points Microsoft Employee
    2024-01-23T05:19:17.5033333+00:00

    Hi Basu Mathapati,

    Welcome to Microsoft Q&A forum.

    As I understand, you are getting query timeout issue in Azure SQL Database.

    We recommend you to go through the detailed documentation on handling of Query Timeout cases as below:

    https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-query-timeouts

    Other helpful post: https://learn.microsoft.com/en-us/answers/questions/654406/query-timeout-on-a-single-query

    Let us know if this helped. If not, we will look into it further.

    Thanks

    1 person found this answer helpful.
    0 comments No comments