Thank you will look at the links for sure. Thanks again!

year was just an example, I would say as long as I can go back if that is possible. Not more than a  year for sure.

no third party softwares, the solution was I had to be patient. The screen froze however after 2 mins it back with the results.

Yes, the blocking happens once in a while not on a regular basis.

so should I change update lock to nolock? what is a good alternative here?

The procedure bascically selects a value where condition is NULL and updates in to the tbale with(updlock) with where condition.

Thanks again 🙂

I did face blocking on the same SSIS package at one time and when I try to capture the query when it was running all I see was...

Thank you for your advice, it is helpful!!

Is there anyway we can figure out how the table is used like inserts or updates. I think there is a standard report...

Tried a different version and still does not work.

Yes, you are correct! it is PK, INT, not null.

Thank you!! for sharing the updated query, I will test it out for sure.

For your question about the functions. it is a MAX function..e.g. max(column3)

Sincerely!

Thanks for your input, Yes the query is running in a second now, however the table is expected to grow over the time, from 8 hows to more rows. So,...

Looks like application side. However let me suggest and discuss with app team and see where we go from here. Not much information at this point however queries running from...

Interesting! so, if I wait for the connection timeout to happen again which is why I am kind of looking into this, and If I run the select * from...

OK, however I see below does give the connections information which happened a little before, are this not accurate?

select * from sys.dm_exec_connections