I have few questions on table lock escalations, please confirm or disprove:
Index Scan operator in a query results in Table Lock Escalation ? always or not (small tables) ?
When Shared lock is escalated to a table level, it blocks small updates and deletes ? inserts as well ?
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