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!
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!
Contact Info
Stedman Solutions, LLC.PO Box 3175
Ferndale WA 98248
Phone: (360)610-7833
Download this page in PDF format