Post reply

Multiple select threads at same time.

  • March 30, 2014 at 2:06 am

    #396500

    Hi all,

    I am facing an issue in selecting a record from db.2 threads are getting executed with same query.The query is to get the row having maximum modified time in the table. 2 threads are trying to access the same row at the same time and one thread fetches the row and update the table. Now the maximum modified time is also changed by this thread. But the second thread which was trying to access the record could not fetch the same and returned with no records retrieved. Could any one tell me the reason for the same. Ideally even if it is concurrent execution, select query wont fail.

  • March 31, 2014 at 1:27 am

    #1701487

    What is MAXDOP setting on the server?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • March 31, 2014 at 11:27 am

    #1701719

    What's your Isolation level ?

    --

    SQLBuddy

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply