sudhakara (7/28/2016)
Thank you.Intent exclusive lock is placed on higher level (page, object) if exclusive lock (X) is placed on lower level of object (rid,key,page). But In my case i do not see any exclusive lock on the object that's why i am trying to find out what could be the reason for this.
Intent doesn't mean it will have happened yet. It may in fact never be placed.
What you need to do is examine the actual query statement stack on the spid of concern to see what calls are making this happen. There could be something you could do about those to make this stop happening.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service