Resolve blocking with concurred writes and reads RRS feed

  • Question

  • I have two separate stored procedures using same table i.e in SQL Server 2016. 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.


    Saturday, November 14, 2020 12:11 AM

All replies

  • Hi PXBB,
    Based on your description, you question is mostly related to Sql Server. I suggest you ask the question on the Microsoft Q&A forum and you can get more professional answer.
    Thank you for your understanding.
    Best Regards,
    Daniel Zhang

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, November 16, 2020 5:41 AM