LCK_M_IX Wait Type
LCK_M_IX Severity
This is one of the more serious wait types and it may indicate locking and blocking. The IX refers to INTENT EXCLUSIVE.
Description
This is an Intent Exclusive Lock, occurs when a task is waiting to acquire an exclusive lock.
Suggestion
Look for large transactions, tune queries to run faster.
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!