Question on READ_COMMITTED_SNAPSHOT

Hi,
We have migrated our HR system to SQL Server 2005 lately by a consultant.
From the documentation, it mentions that he has set READ_COMMITTED_SNAPSHOT
ON.
We would like to know
1) What is the advantage for setting it ON ? From the web, it mentions that
it will reduce the lock and will enhance performance.
2) Is there any way to find out whether the database has set
READ_COMMITTED_SNAPSHOT ON ? I have tried sp_helpdb but it doesn't show up.
Thanks
PeterPeter
http://msdn2.microsoft.com/en-us/library/tcbchxcb(vs.80).aspx
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:uYpanLC1HHA.5380@.TK2MSFTNGP04.phx.gbl...
> Hi,
> We have migrated our HR system to SQL Server 2005 lately by a consultant.
> From the documentation, it mentions that he has set
> READ_COMMITTED_SNAPSHOT ON.
> We would like to know
> 1) What is the advantage for setting it ON ? From the web, it mentions
> that it will reduce the lock and will enhance performance.
> 2) Is there any way to find out whether the database has set
> READ_COMMITTED_SNAPSHOT ON ? I have tried sp_helpdb but it doesn't show
> up.
> Thanks
> Peter
>
>|||Dear Uri,
Thank you for your advice and I get a better understanding.
However, is there any easy way to find out whether database has set
READ_COMMITTED_SNAPSHOT on ?
Peter
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O6x9$hD1HHA.4880@.TK2MSFTNGP03.phx.gbl...
> Peter
> http://msdn2.microsoft.com/en-us/library/tcbchxcb(vs.80).aspx
>
> "Peter" <Peter@.discussions.microsoft.com> wrote in message
> news:uYpanLC1HHA.5380@.TK2MSFTNGP04.phx.gbl...
>|||Peter
select name,
is_read_committed_snapshot_on,
snapshot_isolation_state
from sys.databases
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:OwXI7vO1HHA.3916@.TK2MSFTNGP02.phx.gbl...
> Dear Uri,
> Thank you for your advice and I get a better understanding.
> However, is there any easy way to find out whether database has set
> READ_COMMITTED_SNAPSHOT on ?
> Peter
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:O6x9$hD1HHA.4880@.TK2MSFTNGP03.phx.gbl...
>

Question on READ_COMMITTED_SNAPSHOT

Hi,
We have migrated our HR system to SQL Server 2005 lately by a consultant.
From the documentation, it mentions that he has set READ_COMMITTED_SNAPSHOT
ON.
We would like to know
1) What is the advantage for setting it ON ? From the web, it mentions that
it will reduce the lock and will enhance performance.
2) Is there any way to find out whether the database has set
READ_COMMITTED_SNAPSHOT ON ? I have tried sp_helpdb but it doesn't show up.
Thanks
PeterPeter
http://msdn2.microsoft.com/en-us/library/tcbchxcb(vs.80).aspx
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:uYpanLC1HHA.5380@.TK2MSFTNGP04.phx.gbl...
> Hi,
> We have migrated our HR system to SQL Server 2005 lately by a consultant.
> From the documentation, it mentions that he has set
> READ_COMMITTED_SNAPSHOT ON.
> We would like to know
> 1) What is the advantage for setting it ON ? From the web, it mentions
> that it will reduce the lock and will enhance performance.
> 2) Is there any way to find out whether the database has set
> READ_COMMITTED_SNAPSHOT ON ? I have tried sp_helpdb but it doesn't show
> up.
> Thanks
> Peter
>
>|||Dear Uri,
Thank you for your advice and I get a better understanding.
However, is there any easy way to find out whether database has set
READ_COMMITTED_SNAPSHOT on ?
Peter
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O6x9$hD1HHA.4880@.TK2MSFTNGP03.phx.gbl...
> Peter
> http://msdn2.microsoft.com/en-us/library/tcbchxcb(vs.80).aspx
>
> "Peter" <Peter@.discussions.microsoft.com> wrote in message
> news:uYpanLC1HHA.5380@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> We have migrated our HR system to SQL Server 2005 lately by a consultant.
>> From the documentation, it mentions that he has set
>> READ_COMMITTED_SNAPSHOT ON.
>> We would like to know
>> 1) What is the advantage for setting it ON ? From the web, it mentions
>> that it will reduce the lock and will enhance performance.
>> 2) Is there any way to find out whether the database has set
>> READ_COMMITTED_SNAPSHOT ON ? I have tried sp_helpdb but it doesn't show
>> up.
>> Thanks
>> Peter
>>
>>
>|||Peter
select name,
is_read_committed_snapshot_on,
snapshot_isolation_state
from sys.databases
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:OwXI7vO1HHA.3916@.TK2MSFTNGP02.phx.gbl...
> Dear Uri,
> Thank you for your advice and I get a better understanding.
> However, is there any easy way to find out whether database has set
> READ_COMMITTED_SNAPSHOT on ?
> Peter
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:O6x9$hD1HHA.4880@.TK2MSFTNGP03.phx.gbl...
>> Peter
>> http://msdn2.microsoft.com/en-us/library/tcbchxcb(vs.80).aspx
>>
>> "Peter" <Peter@.discussions.microsoft.com> wrote in message
>> news:uYpanLC1HHA.5380@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> We have migrated our HR system to SQL Server 2005 lately by a
>> consultant.
>> From the documentation, it mentions that he has set
>> READ_COMMITTED_SNAPSHOT ON.
>> We would like to know
>> 1) What is the advantage for setting it ON ? From the web, it mentions
>> that it will reduce the lock and will enhance performance.
>> 2) Is there any way to find out whether the database has set
>> READ_COMMITTED_SNAPSHOT ON ? I have tried sp_helpdb but it doesn't show
>> up.
>> Thanks
>> Peter
>>
>>
>>
>