Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Resolve blocking with concurred writes and reads RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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.

    prashb

    Saturday, November 14, 2020 12:11 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    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