I am having a weird issue in SQL Server 2014. I cannot update or delete certain rows from a table.
I can insert rows fine, and select them, but when I try to update or delete a row, I get a timeout error. It is also strange, that some of the rows can be updated, while others cannot. The table is small, only a few thousand rows, and it's hard to see a pattern with which rows can and cannot be updated, but it seems the more recently inserted rows cannot be deleted/updated.
There are no triggers on the table, there are no locks on the database, and the table has a primary key.
What could be causing this?
sys.dm_os_waiting_taskswhilst it is hung to see the wait type.