Post reply

Midnight bug?! Table lock fields: cant update!!!

  • June 30, 2004 at 2:25 am

    #108537

    Hi, folks!

    I run on this problem for some days.

    I have the following table, wich is updated every 60 secs (ASP page calls the SP to update it).

    The problem is:

    begging at 24h, the script times-out in every attempt to run, and the table wont get updated!!!

    BTW: The SP that updates it is quite simple: UPDATE table SET field1 = 'xpto' WHERE field2 = 'xyz';

    My work around meanwhile is to open "Enterprise Manager", "Show All Recs...", update any DateTime value a little (... 8:56:18 --> ... 8:57:20, for example): what i dont understand is why this simple update takes 5 min. to complete!!!???

     

    I mean, i change the value manually, but have to wait at least 3 min before i get the control back to Enterprise Manager...

    Next, the updates start to run smooth (manually or from code)!

    I dont think this is normal, do you??

    ANY IDEAS????

    Thanxs!!!

     


    LabDev

    labdev@iol.pt

  • July 1, 2004 at 12:43 am

    #512808

    Ah ha. What else happens on your box / sql server at that time? Are you running backups? Do you have anything else scheduled to run in SQL Server, SQL SErver Agent, or windows at that time?

     

    Julian Kuiters
    juliankuiters.id.au

  • July 1, 2004 at 5:56 am

    #512862

    Hey,

    Have you considered doing your update with (rowlock)?  Also, you could set your isolation levels low and do your selects with (nolock) to avoid running into a deadlock (which is what it sounds like)

    Also, what time do your backups run?

    Mark

    Mark Cohen

  • July 1, 2004 at 8:29 am

    #512930

    Well, i'll consider your tips!

    thanxs a lot...

    i'll post results soon i have it


    LabDev

    labdev@iol.pt

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

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