Jayanth_Kurup (8/2/2015)
seems to be an isolation level issue , do you have optimistic concurrency enabled?
Latches aren't related to or affected by isolation levels. The latch in question is used with parallel access to tables and indexes, it's not a lock, it's not going to go away with snapshot isolation level.
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