Well. Really I dont have clear if there are tables locked with the queries in Stackoverflow.
What I have done is: - We have the problem since Feb 6. - So at this moment we restored SQL Nop Backup from Feb 5 to another SQL Database. - We did point our store to this restored database.
And now we are worst: all site is really slowly. We are getting a lot of timeout errors. I'm really sure our store in Feb 5 was very ok and fast.
Hello Noprt. Yeap... We hire a freelance in UpWork. He found that some objects in our Nop SQL that was corrupted/damaged. He installed again all the objects in our SQL and all begins to work. I hope you can find your solution ; )