Sample Header Ad - 728x90

Table Lock Escalation - Performance Questions

0 votes
1 answer
362 views
I have few questions on table lock escalations, please confirm or disprove: 1. Index Scan operator in a query results in Table Lock Escalation ? always or not (small tables) ? 2. When Shared lock is escalated to a table level, it blocks small updates and deletes ? inserts as well ? 3. Is it possible to get counts of table lock_escalation event, grouped by login and then by table ? For example: >login1 - table1 - 11 login1 - table2 - 5 login2 - table1 - 29 etc... Extended Events seemed to allow only one level of grouping if I am not mistaken
Asked by Aleksey Vitsko (6195 rep)
Oct 23, 2021, 06:01 PM
Last activity: Oct 25, 2021, 04:31 PM