September 30, 2003 at 9:44 am
My error logs are filled with this error, every morning at the same time. Any idea what this means? Is this a locking issue? Any ideas on how to tune the server to avoid this?
TIA, Aurora01
Aurora
October 3, 2003 at 4:51 am
Usually means you have a process where a deadlock is occurring and one has been vicitimized. The problem is finding which one. However if it is an everynight thing then setup prfiler to watch server activity to help narrow this down. Look at vicitims and sql statment start items should do the trick. Once you have an idea of where it is happening you should be able to figure out what it is.
But since you say every morning at the same time I am going to suggest it is a job or outside timed event that i the culprit.
Edited by - antares686 on 10/03/2003 04:51:56 AM
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply