-
deadlocked on thread | communication buffer
Sql version
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
I have dts running 24 X 7 every 5 minutes
I noticed DTS failed few times a day with error
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Transaction (Process ID 74) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0
The is no entry about in Server server log files.
will trace identify deadlock and why deadlock info not entred into log file ?
-
Start trace in the SQL Server to identify tables or indexes involved in deadlock. Trace will also tell you what was other process doing at that time
dbcc traceon (-1,3605)
dbcc traceon (-1,1204)
-
thank a lot , it work just fine.I captured deadlock
if l traces continue to run will affect performance ?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|