How to resolve dead lock issue using Prfiler

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

How to resolve dead lock issue using Prfiler

Author

Topic

venkath
Posting Yak Master

202 Posts

Posted - 2006-10-20 : 06:02:20

Hi all

Last night i have put trace on a server that is running WinRunner scripts on the builds,Next morning, the sql trace has SPIDs that are dead locked..

Now how can i proceed in resolving the deadlocks issue.

Thanks

venkath
Posting Yak Master

202 Posts

Posted - 2006-10-20 : 07:57:49

Hi folks

i am giving u some more info on this..
when the dead lock occured on the server, i found some info in the log file..
10:36:23 [ERROR ] com.inet.tds.ao: Msg 1205, Level 13, State 61, Procedure sp_cursoropen, Line 1, Sqlstate 40000
[OCSSQL1]Transaction (Process ID 165) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.SQL:SELECT E.EID,
E.TE,
E.NAME,
E.ERE,
E.EUM,
E.IEQ,
E.END,
E.DE,
E.CE,
E.AS,
E.PAGE,
convert(varchar(20), E.CDE, 113) AS CREATE_DATE
FROM
E
WHERE (E.TE IN ('+CUPN') )
ORDER BY E.EID ASC
10:36:23 [ERROR ] (100010, CLT-Transfer-Group) Error while checking for pending events: com.inet.tds.ao: Msg 1205, Level 13, State 61, Procedure sp_cursoropen, Line 1, Sqlstate 4000

Any help on this is grealty apprecialted..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources