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 Migrating Cold Data Automatically to Another Database (Don't Know How) Putting Uploaded Data First in Azure Queue / Azure Event Hub and keep updating database at steady rate 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 ??

Azure sql Locking Leads to Time Out Error

shashank Trivedi 1

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

Migrating Cold Data Automatically to Another Database (Don't Know How)
Putting Uploaded Data First in Azure Queue / Azure Event Hub and keep updating database at steady rate
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 ??

Navtej Singh Saini 4,226 Reputation points Microsoft Employee

2020-11-12T01:54:15.167+00:00

@shashank Trivedi

Please help us with any error messages that you are getting. Also explain your architecture a bit and explaining how you run SQL queries and if you use an application to do so.

We will try to help you to best of our abilities.

Thanks
Navtej S

Share via

Azure sql Locking Leads to Time Out Error

Your answer