In a SQL Server 2014 database we do a 1 row update by setting 1 bit field to 1 where Id =
<value>. This means a seek over the PK.
It takes over 50 seconds for that update.
Inserts fly in the database, selects perform fast, only updates are slow.
Last Thursday evening the service of SQL Service was restarted (so no stop, wait a bit and start).
We have 9 databases run in this server only 1 database has this issue.
What is the problem with the updates since that restart?
Any recognize this behaviour?
What I have tried:
- Reindex all indexes
- run same query from SSMS with same result
- Rebuilding all indexes
- Restart the service broker but we still have suspending jobs