In my case, with a very heavy load for the updates, this error occurred because the stored procedure used updates and did not use indexes on the search field. The table was not big, at a maximum of 3000 records, but updates were widespread. Creating an index solved the problem with MS SQL Server 2019