READ_COMMITTED

READ_COMMITTED_SNAPSHOT

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pingx - 18 Mar 2008 23:31 GMT

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

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 19 Mar 2008 00:08 GMT

Did you try Google?

http://technet.microsoft.com/en-us/library/ms173763.aspx

http://msdn2.microsoft.com/en-us/library/tcbchxcb(VS.80).aspx

> Hi Sql Server experts,
>
[quoted text clipped - 4 lines]
>
> Pingx

Reply to this Message

TheSQLGuru - 19 Mar 2008 23:44 GMT

You best have some spiffy I/O backing up an appropriately sized/tuned
tempdb.

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

> Hi Sql Server experts,
>
[quoted text clipped - 4 lines]
>
> Pingx

Reply to this Message

Pingx - 20 Mar 2008 00:33 GMT

Thanks. This is very helpful.

> You best have some spiffy I/O backing up an appropriately sized/tuned
> tempdb.
[quoted text clipped - 7 lines]
> >
> > Pingx

Reply to this Message