{"id":209,"date":"2012-05-16T07:52:32","date_gmt":"2012-05-16T07:52:32","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/05\/16\/deadlock_priority\/"},"modified":"2012-05-16T07:52:32","modified_gmt":"2012-05-16T07:52:32","slug":"deadlock_priority","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/05\/16\/deadlock_priority\/","title":{"rendered":"DEADLOCK_PRIORITY"},"content":{"rendered":"<p><em><strong>DEADLOCK_PRIORITY<\/strong> is used to specify the priority of a session when deadlocked by other session.<br \/>\nThe session that has lower DEADLOCK_PRIORITY will be chosen as a victim for deadlock.<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2012\/05\/ninasophia-dY6NRHMd9Ys-hd.jpg\" alt=\"Dead Lock\" title=\"Dead Lock\" width=\"300\" height=\"200\" class=\"aligncenter size-medium wp-image-2473\"><\/p>\n<p><strong>Syntax:<\/strong><br \/>\n[sql]<br \/>\nSET DEADLOCK_PRIORITY value<br \/>\n[\/sql]<\/p>\n<p><em>Value Can Be:<\/em><br \/>\nLOW<br \/>\nNORMAL<br \/>\nHIGH<br \/>\nNumeric value from -10 to 10<\/p>\n<p><strong>Example:<\/strong><br \/>\nTo set HIGH DEADLOCK_PRIORITY to a connection:<br \/>\n[sql]<br \/>\nSET DEADLOCK_PRIORITY HIGH<br \/>\n[\/sql]<br \/>\nOR<br \/>\n[sql]<br \/>\nSET DEADLOCK_PRIORITY 5<br \/>\n[\/sql]<br \/>\nOR<br \/>\n[sql]<br \/>\nDECLARE @A VARCHAR(10)<br \/>\nSET @A = &#8216;HIGH&#8217;<br \/>\nSET DEADLOCK_PRIORITY @A<br \/>\n[\/sql]<br \/>\nOR<br \/>\n[sql]<br \/>\nDECLARE @A INT<br \/>\nSET @A = 5<br \/>\nSET DEADLOCK_PRIORITY @A<br \/>\n[\/sql]<\/p>\n<p><strong>Note: <\/strong><br \/>\nNumeric equivalent values of DEADLOCK_PRIORITY.<br \/>\nHIGH = 5<br \/>\nNORMAL = 0<br \/>\nLOW = -5<\/p>\n<p>Applicable to SQL Server 2000,SQL Server 2005,SQL Server 2008,SQL Server 2008 r2,SQL Server 2012<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DEADLOCK_PRIORITY is used to specify the priority of a session when deadlocked by other session. The session that has lower DEADLOCK_PRIORITY will be chosen as a victim for deadlock. Syntax: [sql] SET DEADLOCK_PRIORITY value [\/sql] Value Can Be: LOW NORMAL HIGH Numeric value from -10 to 10 Example: To set HIGH DEADLOCK_PRIORITY to a connection:&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1946],"tags":[1968,1969,1970,1971,1972,1973,1974,1975],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/209"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=209"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/209\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}