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.

 

Related Links


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!