title: How long should SET READ_COMMITTED_SNAPSHOT ON take?
body: <p>How long should it take to run </p>
  
  <pre><code>ALTER DATABASE [MySite] SET READ_COMMITTED_SNAPSHOT ON
  </code></pre>
  
  <p>I just ran it and it's taken 10 minutes.</p>
  
  <p>How can I check if it is applied?</p>