Insert fails

• karthikeyan-146504

  Ten Centuries

  Points: 1055

  More actions

  March 9, 2009 at 3:22 am

  #95270

  @@LOCK_TIMEOUT is -1 in my production box.

  If I increase the value for @@LOCK_TIMEOUT to 1800

  We will have any performance degrade or

  We will be enganged with more insert fails..

  Please share your experience.....

  Thanks,

  ---

  Kindest Regards,

  karthik
  

• Ashok.S

  SSC Eights!

  Points: 869

  More actions

  March 9, 2009 at 3:38 am

  #955845

  Hi,

  Read the arguments section of this link,

  http://msdn.microsoft.com/en-us/library/ms189470.aspx

  Regards,

  AshoK S

• karthikeyan-146504

  Ten Centuries

  Points: 1055

  More actions

  March 9, 2009 at 3:42 am

  #955848

  Thanks Ashok

  ---

  Kindest Regards,

  karthik
  

• Ashok.S

  SSC Eights!

  Points: 869

  More actions

  March 9, 2009 at 3:44 am

  #955849

  Also look this link,

  http://www.sql-server-performance.com/tips/blocking_p1.aspx

  Regards,

  Ashok S