Deadlock Priority SQL Server

Specifies the relative importance that the current session continue processing if it is deadlocked with another session.

--Deadlock Priority of high make sure your session is not deadlocked by any other session

SET DEADLOCK_PRIORITY HIGH

--Other options with deadlock priority is medium and low

Recent Posts

--Query to find missing index from query store, from last 30days usage SELECT TOP 20 qsq.query_id, SUM(qrs.count_executions) *...

--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...

--SQL Server Database log full due to replication, you can run the following command to mark all ---the replication transaction is done,...