LCK_M_X Wait Type
LCK_M_X Severity
May indicate locking and blocking, possibly related to IO bottlenecks.
Description
This is an Exclusive Lock, that commonly occurs when lock escalation is occurring.
Suggestion
Look for large transactions, tune queries to run faster. Check for lock escalation.