sudhakara (7/28/2016)
Select statement is being executed through the session which holds the IX lock on the table. Not sure why the select statement holding this IX.
The current SELECT statement currently being executed could be part of a 20-query transaction. That is why I mentioned the entire query stack should be examined. My guess is that something else was done before the SELECT you see that took the IX.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service