Thanks a lot Jeffrey

I'm looking at the .Net code and for each user process request there's one SqlClient.SqlTransaction running 5 SPs, each inserting in a respective table.

There's a try ... catch block and rollbacks the SqlTransaction whatever exception occurrs and it is published on Event Logs, etc.

For this particular case I only see data on one table, there's no data in other 4, and there's no exception detected on log files.

Funny thing is there's another set of process requests completed (close to the one incomplete) generated as usually by the same user.