I want to set deadlock priority of a stored proc to low so that when ever any one calls it from entity or command object it should use same priority.

• rajemessage 14195

  Hall of Fame

  Points: 3315

  More actions

  April 27, 2015 at 1:41 am

  #317031

  Hi,

  I want to set deadlock priority of a stored proc to low so that when ever any one calls it from entity or command object it should use same priority.

  some body sugested to put

  set deadlockprioirty low

  go

  exec yourSP()

  but in this case i have to change my bussiness layer.

  is there any other way from database which do the task?

  yours sincerley.

• Adi Cohn-120898

  SSC-Dedicated

  Points: 33944

  More actions

  April 27, 2015 at 1:59 am

  #1793583

  Maybe I'm missing something, but you can set the deadlock priority in the procedure's code.

  Adi

  --------------------------------------------------------------
  To know how to ask questions and increase the chances of getting asnwers:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Grant Fritchey

  SSC Guru

  Points: 399278

  More actions

  April 27, 2015 at 3:13 am

  #1793595

  Just call it right within the procedure as stated. Here's the documentation.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning