Disabling READ COMMITTED SNAPSHOT ISOLATION (RCSI)

• Marios Philippopoulos

  SSC Guru

  Points: 57190

  More actions

  April 6, 2010 at 9:13 am

  #231384

  I know that to enable RCSI on my database I need to terminate all connections.

  Does the same hold true for disabling RCSI?

  __________________________________________________________________________________
  SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
  Persisting SQL Server Index-Usage Statistics with MERGE[/url]
  Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  April 6, 2010 at 12:54 pm

  #1146724

  As far as I know, yes it does.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning