Serializable vs. Repeatable Read

Comments

• bbrown Member Posts: 3,268

  2011-01-02

  The default transaction isolation level used by NAV is Read Uncommitted. Serializable is only used during update transactions. SQL default behavior is Read Committed and tends to be more common but allows less concurrency. The downside of Read Uncommitted is dirty reads in exchange for better concurrency.

  There are no bugs - only undocumented features.

  0
• Tobe Member Posts: 4

  2011-01-02

  Yes, but you can change the default for update transactions from serializable to repeatable read.
  It's described in this KB article (I should have mentoined it in my first post):
  
  Blocking problems caused by Microsoft Dynamics NAV 5.0 SP1 using Microsoft SQL Server SERIALIZABLE isolation level
  https://mbs2.microsoft.com/knowledgebase/KbDisplay.aspx?scid=kb;en-us;979135

  0
• bbrown Member Posts: 3,268

  2011-01-02

  You may find this post fo some interest:
  
  http://www.mibuso.com/forum/viewtopic.p ... it=4194304

  There are no bugs - only undocumented features.

  0
• johanna Member Posts: 369

  2011-08-04

  Tobe wrote:

  Yes, but you can change the default for update transactions from serializable to repeatable read.
  It's described in this KB article (I should have mentoined it in my first post):
  
  Blocking problems caused by Microsoft Dynamics NAV 5.0 SP1 using Microsoft SQL Server SERIALIZABLE isolation level
  https://mbs2.microsoft.com/knowledgebase/KbDisplay.aspx?scid=kb;en-us;979135

  
  Hi Tobe,
  
  Is there any hotfix for blocking problems in Microsoft Dynamics NAV 4.0 SP3 like the article above? Thanks..

  Best regards,
  
  Johanna

  0
• Tobe Member Posts: 4

  2011-08-04

  johanna wrote:

  Tobe wrote:

  Yes, but you can change the default for update transactions from serializable to repeatable read.
  It's described in this KB article (I should have mentoined it in my first post):
  
  Blocking problems caused by Microsoft Dynamics NAV 5.0 SP1 using Microsoft SQL Server SERIALIZABLE isolation level
  https://mbs2.microsoft.com/knowledgebase/KbDisplay.aspx?scid=kb;en-us;979135

  
  Hi Tobe,
  
  Is there any hotfix for blocking problems in Microsoft Dynamics NAV 4.0 SP3 like the article above? Thanks..

  
  I'm not aware of one.
  Anyway, the hotfix is not for general blocking problems, but only for those special cases, where i.e. blocking all sales lines for one sales order, also blocks last line of previous sales order and first line of next order.
  
  In most situations blocking problems occur from other reasons.
  
  Tobe

  0