Post reply

isolation level

  • July 29, 2008 at 3:35 pm

    #191655

    How do i set transaction isolation for just 1 database to snapshot.

    does it has any dis advantages

  • July 29, 2008 at 3:43 pm

    #850176

    is this all we have to do

    ALTER DATABASE

    SET ALLOW_SNAPSHOT_ISOLATION ON

  • July 29, 2008 at 4:16 pm

    #850188

    How do i check isolation level of a database?

  • July 30, 2008 at 1:07 am

    #850274

    Following query shows whether SNAPSHOT is enabled or not:

    select [name], is_read_committed_snapshot_on, snapshot_isolation_state, snapshot_isolation_state_desc

    from sys.databases

    where [name] = 'AdventureWorks'

  • July 30, 2008 at 1:20 am

    #850281

    Downside is that snapshot isolation puts extra load on your TempDB

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply