August 16, 2010 at 4:07 am
Got this error when a job (which was running successfully earlier) runs and fails:
The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.
Any ideas why?
August 16, 2010 at 4:12 am
if you have any tool for performance analysis then you can browse history to see what type of lock was there and other related problems. Else might find something in errorlog.
If nothing suits you then run profile for next schedule and make sure you put proper filter in yout profiler and let it run during job schedule.
Solution I can think of is, reschedule the job later or before to that perticular time. there is some other activity going on during that time.
You can see if there is any other job scheduled during that time or not.
----------
Ashish
August 16, 2010 at 6:01 am
Can you give some mor information?
What does the job do? Whats changed? What user does the job run as? What have you tried so far?
😛
Adam Zacks-------------------------------------------Be Nice, Or Leave
August 16, 2010 at 6:12 am
balasach82 (8/16/2010)
Got this error when a job (which was running successfully earlier) runs and fails:The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.
Any ideas why?
for high level view , i can say whenever server engine busy with some heavy operation like backup , index rebuild , statistics update or any other aplication specific heavy task , sql cant able to provide enough resources( memory ) to some jobs/tasks . So better investivate in details or try with another job schedule.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply