Shared LOCK on KEY in read committeв snapshot

 

hi!,

i have kinda misunderstanding. have enabled read committed snapshot in db.

 

select is_read_committed_snapshot_on sys.databases;

1

 

but, still have s lock wait requests:

 

 

readcommitted

92

key

s

lock

wait

transaction

 

this lock wait annoying.

the same operation in oracle db on other site does not require shared lock here.

 

how rid of shared locks in sql server???

are setting transaction isolation level read committed well?

 

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

 

 

 

SQL Server  >  SQL Server Database Engine