I'm talking about thousands of simultaneous connections and requests. A simple loop with 5 or even a 100 simulated requests won't raise the same kinds of issues with this...

Wouldn't you have to arrange an asynchronous test to truly duplicate what is going on in production?

Little late in the game for that. I could test it out I suppose but doubt it fixes the problem especially if traffic continues to increase. That table...

The table really is just:

PrimaryKeyID uniqueidentifier

Description varchar(200)

CreateDateTime datetime

PageViewCount bigint

It is essentially a lookup table that has next to nothing for live queries run against it (they are held in a...

I guess I was looking for some insight into the likelihood of the waits that must occur while each subsequent update request (and lock on the record) on the exact...

The table and the procedure really are this simple. the primary key is a clustered index on a single column.

Keep in mind, these are thousands of simultaneous updates to...