Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frant101
Starting Member
12 Posts |
 Posted - 2009-06-17 : 04:37:11
|
| I'am currently trying to find the cause of the below error message that I get e-mailed from our database server everynight.DATE/TIME: 13/06/2009 03:08:50DESCRIPTION: Error: 1204, Severity: 19, State: 1The 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.COMMENT: (None)JOB RUN: (None)I have set up a trace to try and find what might be causing this issue but all i am getting is loads and loads of LockTimeOut Duration 0 events and no real information about the process that is causing the lock.What would be the best events to use to find out which process is causing the lock or is there a better way of finding out what process are involoved in this lock bearing in mind that it will need to be an automated task as this error happens once at 3am in the morning.Using sql server 2000 sp4Any help would be greatly appreciatedfrant101 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-06-17 : 10:31:01
|
| Do you have any jobs on the server that would be running during that time?Mike"oh, that monkey is going to pay" |
 |
|
|
frant101
Starting Member
12 Posts |
Posted - 2009-06-18 : 03:03:57
|
| I have checked all scheduled jobs and maintenance plans and i cant see anything that is kicked off around this time.ThanksFrant101 |
|
|
|
|
|
|
Overnight Locking Errors