Thank you, yes the session is blocked by other sessions doing the same query with different parameters

The query is:

(@p0 datetime,@p1 datetime,@p2 bigint,@p3 datetime,@p4 datetime,@p5 bigint,@p6...

Thanks, what I found is the session is blocked by other sessions using the same query.

I checked with the application admin, and found that in the application server that scheduled...

Any suggestions about the solution according to the chart I attached?

Thanks!

We are using Solarwind DPA to do the monitoring. See attached for the query.

If blocking is not the issue, what could it be?

How can I find the root of this...

That query is an update query that has passed parameters which are going to be set.

The where clause is based on primarykey, by using the passed ID.

I don't see anything...

How to reset clustered index or keys ?

This update query is using a where clause that use Primary key.

Does a rebuild of the primary key index reset the...

The web service was not running at that time. We rebooted the servers a day ago in the morning, the job only at night.

Thanks,

Both servers were rebooted on Saturday morning.

But the job rans on Sunday night when both servers have already rebooted.

Thanks, that makes sense now.

Thanks,

But I see the example in the graphic in the link is two transactions.

https://technet.microsoft.com/en-us/library/ms191242(v=sql.105).aspx

I found this article.

But I don't know how to make the order of table the same, for if there are multiple developers, it is hard for them to know the...

Thanks, try to understand the two Scenarios, the first one must be in different order, the second one is same order, one in the first case, you pull a knife...

By reading this article, as I understand, it seems telling us for new applications the new way is preferred, only for existing or legacy database that we...

Thank you, that is very good information, I will read those to see if I come up with more questions.

Thanks,

Can you elaborate a little about entity framework can use parameterized queries as well as stored procedures, instead of direct query?

Thanks