Post reply

Job failure, can''t obtain a lock resource....

  • October 27, 2005 at 12:53 pm

    #110637

    this is the error in the sql server log for the reason my job failed.  I have changed the times of the job, to be at a time when there would be no/few users and yet I still get this more often than not.  Any ideas as to why or how to fix it????  Thanks in advance!!!!

    ERROR:

    The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memory configuration..

    Thank you!!,

    Angelindiego

  • October 28, 2005 at 12:17 pm

    #601047

    I'm no expert in SQL2K5 (yet) but check out the results of:

    sp_configure 'locks'

    maybe it needs to be 'tweaked' ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • October 28, 2005 at 12:57 pm

    #601058

    Thanks Rudy!!  I found that yesterday on the MS site...so the tweak is available, but it requires a reboot and I don't want to have to do that.  What bothers me is that this job has been running for a long time and now this error has reared its ugly head...hmmm....who knows!!

    Thank you!!,

    Angelindiego

  • October 28, 2005 at 1:15 pm

    #601069

    It's not that bad ... locks and couple of memory thiongs in sp)_configure are still the only ones that require reboots. The reason locks reared it's ugly head is because you're probobly using the server more and data volume is growing, requiring more locks. If you are using the 'default', there may be a bit of a 'bug' at work because the default settings give a minimum of 5000 and a maximum 2147483648 locks. SQL Server is supposed to 'auto-adjust' this setting. The only reason that I can think of is beacuse you may be running low on memory for the SQL Server (this too is supposed to be another 'dynamic' thing.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • October 28, 2005 at 1:19 pm

    #601073

    thank you again!!  Now...if you could answer some of the other questions I have posted...you would make my life easier!!!! 

    Thank you!!,

    Angelindiego

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

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