question

prashb avatar image
prashb asked

Resolve blocking with concurred writes and reads

I have two separate stored procedures using same table. One is writing to the table and the other reading from the same table. The second SP waits or gets blocked as the first SP is writing data to the table. Is there anyway I can read the latest data without using (NOLOCK) or waiting is the only option ?.We are using sentry one to track the blocking.

deadlockblocking
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.