Post reply

LCK_M_IX waittype is found in SQL SERVER

  • February 4, 2017 at 3:53 pm

    #318392

    Hi Experts,

    What is the reason for the LCK_M_IX wait type.. Actually what this waittype refers too..What is the solution for this , Kindly reply ASAP. Very urgent

    Thanks in advance

    NM

  • February 5, 2017 at 2:02 pm

    #1926771

    It's a wait to acquire an Intent-Exclusive lock. Short duration waits are not a problem, and are expected. If you've got longer-duration waits, then you probably have some inefficient queries that need tuning. Try and identify what query the session that is holding the incompatible lock is running and see if you can tune that query.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 8, 2017 at 12:41 am

    #1927251

    Thanks for the reply

  • February 9, 2017 at 8:43 am

    #1927556

    I got the above waittype using solarwinds tool....How to find the waits using SSMS? We are continuously facing performance issue in an production server??What all the possible reasons???

    RAM: 64 GB
    Enterprise edition, SQL SERVER 2008R2
    8 Processors

    Thanks in advance..

  • February 9, 2017 at 9:22 am

    #1927569

    Narine M - Thursday, February 9, 2017 8:43 AM

    I got the above waittype using solarwinds tool....How to find the waits using SSMS? We are continuously facing performance issue in an production server??What all the possible reasons???

    RAM: 64 GB
    Enterprise edition, SQL SERVER 2008R2
    8 Processors

    Thanks in advance..

    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server-part-1/

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • February 9, 2017 at 10:35 am

    #1927597

    Narine M - Thursday, February 9, 2017 8:43 AM

    We are continuously facing performance issue in an production server??What all the possible reasons???

    The answer to that is a book, not a forum post.
    If it's critical and you don't have the skills, consider getting a consultant in to help. Lots of us here do that kind of work

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply