Changes between Version 5 and Version 6 of Documentatie/Beheerder/Installeren/Installatiehandleiding/SQLServer


Ignore:
Timestamp:
May 21, 2012 9:48:58 AM (14 years ago)
Author:
henk
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Documentatie/Beheerder/Installeren/Installatiehandleiding/SQLServer

    v5 v6  
    4848Volg de instructies van Microsoft om de database server in te richten, en zet op laptops die buiten de deur worden gebruikt, de ODBC-connectie naar OpenAC op zo'n manier op dat de beveiligde verbinding wordt gebruikt. 
    4949 
     50== Snapshot Isolation == 
     51 
     52SQL Server has a default transaction isolation mode that locks entire tables, and causes even mildly concurrent applications to have long held locks and frequent deadlocks. Enabling snapshot isolation for the database as a whole is recommended for modern levels of concurrency support. This is accomplished via the following ALTER DATABASE commands executed at the SQL prompt: 
     53 
     54{{{ 
     55ALTER DATABASE MyDatabase SET ALLOW_SNAPSHOT_ISOLATION ON 
     56 
     57ALTER DATABASE MyDatabase SET READ_COMMITTED_SNAPSHOT ON 
     58}}} 
     59 
     60