Question : The following has happened on more than one occasion. Updates or inserts to a certain table (I’m not […]
Tag: blocking
Blocking caused by Query Store. Unable to clear or disable
Question : I recently updated our 2016 SQL Server to SP2 and the most recent CU (KB4458621) released in August […]
SQL Server and NHibernate – blocking occurs between two unrelated queries (distributed transactions)
Question : there’s a problem that I’m seeking your help with… There are two simple queries: DELETE a row from […]
Blocking Extended events
Question : I have very basic table CREATE TABLE [dbo].[Table_1]( [Test] [int] NULL) INSERT INTO [dbo].[Table_1]([Test]) Select 1 sp_configure’block process […]
Lock priority for scripts run in maintenance windows
Question : We run maintenance windows weekly and monthly. Some of our maintenance windows are online and the last thing […]
Extended Events to find Blocking and Deadlocking
Question : Came across another great article from Jeremiah Peschka called Finding Blocked Processes and Deadlocks using SQL Server Extended […]
SQL Server Sch-S locks on unrelated tables
Question : I am a bit confused. I myself am MCSE and thought I would understand most parts of the […]
Is there any method of looking for Head Blocking history in SQL 2012?
Question : Is there any method of looking for Head Blocking history via DMVs. I have been able to find […]
Getting All SQL Corresponding to Locks
Question : I was recently involved in debugging a tricky SQL Server locking issue. We eventually figured out what was […]
What happens if two mySQL queries both try to lock the same row at the same time?
Question : So this isn’t exactly my strong suit, but here’s my basic understanding of the situation: If two threads […]