READ_COMMITTED_SNAPSHOT

Hi Sql Server experts,
I'm going to set the option READ_COMMITTED_SNAPSHOT to ON.
I'd like to know what impact this will have to the database.
Thanks for your help.
Pingx
Did you try Google?
http://technet.microsoft.com/en-us/library/ms173763.aspx
http://msdn2.microsoft.com/en-us/library/tcbchxcb(VS.80).aspx
"Pingx" <Pingx@.discussions.microsoft.com> wrote in message
news:6C06B5CC-02B1-47AE-9ECE-5A6B7639AC3F@.microsoft.com...
> Hi Sql Server experts,
> I'm going to set the option READ_COMMITTED_SNAPSHOT to ON.
> I'd like to know what impact this will have to the database.
> Thanks for your help.
> Pingx
|||You best have some spiffy I/O backing up an appropriately sized/tuned
tempdb.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Pingx" <Pingx@.discussions.microsoft.com> wrote in message
news:6C06B5CC-02B1-47AE-9ECE-5A6B7639AC3F@.microsoft.com...
> Hi Sql Server experts,
> I'm going to set the option READ_COMMITTED_SNAPSHOT to ON.
> I'd like to know what impact this will have to the database.
> Thanks for your help.
> Pingx
|||Thanks. This is very helpful.
"TheSQLGuru" wrote:

> You best have some spiffy I/O backing up an appropriately sized/tuned
> tempdb.
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
> "Pingx" <Pingx@.discussions.microsoft.com> wrote in message
> news:6C06B5CC-02B1-47AE-9ECE-5A6B7639AC3F@.microsoft.com...
>
>