SQL Server Cursor Locking Issue -
my application opens cursor perform updates/deletes on indexed view. while cursor opened, there multiple page locks though query populating cursor doing select top 100
.
the query specifies (updlock,readpast)
query hints multiple processes work queue. expect see 100 locks cursor, seeing upwards 67,000 locks cursor.
also, expect these locks on row level, on page level, maybe lock escalation?
any ideas?
cursor population sql:
select top 100 col1, col2, col3 indexedview (updlock, readpast) order col3
indexed view:
select col1, col2, col3 table col4 null
thanks
Comments
Post a Comment