When any business or application begins, the amount of the data is limited, and the complexity of the business logic is simple; as time goes by, the data and complexity both increase for the business. The same queries running very fast in the beginning often start running slow occasionally. The data that used to be available freely now starts to get locked, and queries sprinting are now turning into long running queries.
In this blog, let us discuss the locking scenario and long-running queries and their potential solution.
Locking, Blocking, and Deadlocking
First, let us talk about three different but