Timeline for Why does only one version of these procedures get blocked under moderate load?
Current License: CC BY-SA 4.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 11, 2021 at 21:37 | comment | added | sean | Thank you for taking the time to look at my problem. You are correct that this table sorely needed an index on SessionID and we have since added one. But this was after we fixed the blocking issue with the change proc. The lock information on that top row (session_id=172) is full of: resource_type="METADATA.INDEXSTATS" and METADATA.STATS. Including a bunch on the Primary and Secondary XML index. We have also removed the secondary XML index. The XML we store in that column is large. | |
| Aug 6, 2021 at 15:26 | history | answered | rois | CC BY-SA 4.0 |