Question : Setup I have a simple table: CREATE TABLE [dbo].[StringData]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [DCStringID] [bigint] NOT NULL, […]
Tag: blocking
SOS_SCHEDULER_YIELD – Prevent a Proc from giving up the Processor Time
Question : I’ve got a process which about once a month at times unrelated (or as far as we can […]
How to find the query that is still holding a lock?
Question : Querying the sys.dm_tran_locks DMV shows us which sessions (SPIDs) are holding locks on resources like table, page and […]
Unable to understand correlation between MaxWorkers created and CPU utilization
Question : I am having a strange issue which i am unable to understand: On my server with 64 Logical […]
Why does MYSQL use blocking locks instead of optimistic attempts that fail immediately?
Question : Why isn’t optimistic concurrency control more commonly supported at the database layer? It is a valid alternative and […]
The effect of a Primary Key on a blocking situation
Question : I’m studying about “Transaction and concurrency”,”Deadlock” and related stuff for some time. I have a question regarding this […]
InnoDB engine seems lock the table automatically in Mysql5.7
Question : I have a table named Students like: mysql> select * from students; +—-+——-+———+ | id | name | […]
Hold exclusive lock on a whole DB
Question : As I explained in Set a filegroup to readonly, I wanna set some tables readonly, to have better […]
Need to intentionally create blocking processes for testing
Question : My team and I have an issue where we need to be able to identify processes that are […]
In Sql Server, is there a way to check if a selected group of rows are locked or not?
Question : We are attempting to update/delete a large number of records in a multi-billion row table. Since this is […]