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
Last activity: Oct 25, 2021, 04:31 PM