Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Log into SQL server management studio with a sa-level user account.
  2. Open a new query.
  3. Run the following query to enable the READ_COMMITTED_SNAPSHOT option:


    /** Run this statement to change the isolation level of the database.
    When the READ_COMMITTED_SNAPSHOT database option is set ON, the mechanisms used to support the option are activated immediately. When setting the READ_COMMITTED_SNAPSHOT optiononly the connection executing the ALTER DATABASE command is allowed in the database. There must be no other open connection in the database until ALTER DATABASE is complete. The database does not have to be in single-user mode.
    **/

    ALTER DATABASE APTIFY SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
    ALTER DATABASE Aptify SET READ_COMMITTED_SNAPSHOT ON
    ALTER DATABASE APTIFY SET MULTI_USER;




  4. Run the following query to enable the ALLOW_SNAPSHOT_ISOLATION option:


    /** Statement below can be used to turn on the snapshot isolation, so that transactions can set the snapshot isolation level. Per our analysis, there is no Aptify code that currently does this, therefore this is not required.**/

    ALTER DATABASE Aptify SET ALLOW_SNAPSHOT_ISOLATION ON




  5. Run the following query to verify the values of these options:


    /** Query to determine snapshot states **/
    SELECT
    Name
    , snapshot_isolation_state
    , snapshot_isolation_state_desc
    , is_read_committed_snapshot_on
    FROM sys.databases
    WHERE name 'APTIFY';


    Image Added