Post reply

concurency or locks

  • September 30, 2009 at 5:14 am

    #210211

    Hi experts,

    need some valuble suggessins to fix this issue

    Process : We have one procedure which will process the .csv file with thousands of data and update/insert into the transaction table.

    The procedure is scheduled for every 5 min.

    Issue : Wile the job starts, and inserts/updates to transaction table, we will not be able to read the data from the transaction table.

    So we would like to know, if it’s not supporting the concurrency or tables are being locked?

    thanks in advance

  • September 30, 2009 at 6:37 am

    #1059908

    When you have bulk updates and inserts, the table gets exclusive lock during that time. If you want your Selects to work, there are two ways to do it.

    1. Using Snapshot Isolation (Row Level Version) You can search here itself to read more about it. There are lots of articles regarding it here.

    2. Dirty Read. Using the Hints of NOLOCK. (Not recommended)

    -Roy

  • September 30, 2009 at 7:28 am

    #1059940

    thank you very much for your reply

    can i get the some of the useful links for the above issue.

    any other experts valuable suggestions pls .

    thanks in advance

  • September 30, 2009 at 7:45 am

    #1059950

    Check this link[/url] for Row level version

    But test it out in a test environment before doing anything to your production.

    -Roy

  • September 30, 2009 at 10:02 pm

    #1060264

    thanks for the reply

    but we are using sql server 2000. not 2005

    thanks in advance.

  • October 1, 2009 at 1:19 am

    #1060299

    Why every 5 mins?

    "Keep Trying"

  • October 8, 2009 at 4:28 am

    #1063333

    any updated suggestions pls

  • October 8, 2009 at 6:58 am

    #1063405

    If you are just reading from that table, Set up replication and read from the replicated server

    -Roy

Viewing 8 posts - 1 through 7 (of 7 total)

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