none
Azure sql Locking Leads to Time Out Error RRS feed

  • Question

  • Our Transactional Data is in Azure Sql, 10% of the time we face Time Out Error due to Database Locking whenever we upload new data into Azure Sql database through sql query. We have already done lot of query optimization, we are thinking to implement some out of the box solution like

    1. Migrating Cold Data Automatically to Another Database (Don't Know How)
    2. Putting Uploaded Data First in Azure Queue / Azure Event Hub and keep updating database at steady rate
    3. Using NoSql Database for some of the tables (where load is high) like Elastic Search

    My question is, Will we be able to eliminate this problem forever by using above  methods in a cost effective manner ??

    Sunday, November 8, 2020 5:21 AM

All replies

  • Hello Paramshash,

    This forum is dedicated to supporting issues related to open specification. You can access open specifications at https://docs.microsoft.com/en-us/openspecs/. Your inquiry does not seem to be related to open specifications.

    For a better chance of getting an answer to your question, you may want to post your question to the following forum:

    https://docs.microsoft.com/en-us/answers/products/sql-server

    Best regards,
    Tom Jebo
    Sr Escalation Engineer
    Microsoft Open Specifications
    Sunday, November 8, 2020 4:12 PM
    Moderator