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

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

order - Notification for user in user account opencart -