Thank you replies.. tested and data was commited in SERIALIZABLE isolation level .

There is one SP and written code like SELECT/INSERT/UPDATE all operation at one single stored procedure, it was INSERT/UPDATE command blocked each other and none of them getting completed.

Blocked by - 67 (SPID), also HeaderBlocker - 76 (SPID).. and wait type - LCK_M_IX (intent shared lock each others).

So i planned to test first to implement SERIALIZABLE isolation level at SPs level for resolving this LCK_M_IX wait type, but not hope and same blocking problem happend again. also

why INSERT/UPDATE get blocked and identified some Non-clustered index key was appered in table which is performing INSERT/UPDATE statement. also index key was created at same INSERT cloumn only.

After removing those index blocking issues was resolved, (but not removed SERIALIZABLE isolation level at SPs level. But application took long time more than 15 sec for insert records).

Finally removed SERIALIZABLE isolation level at side after that acceptable seconds take for insert/update.

Thanks

ananda