I have changed existing procedure in which I have added new table as join . Query already has 5 joins from physical table and one temp table . I adding join to this new table and existing temporary table (#) .
Whenever the new table has some records procedure get hung . If I truncate data from new table it works fine .
If I execute sp_lock I see 12 records 10 for non cursor lock on physical table and 2 on temporary table .