Post the sql statemenst for the first two threads that enter the deadlock.
Read up: http://www.mssqlcity.com/Articles/Adm/SQL70Locks.htm http://support.microsoft.com/?kbid=832524 Axton Grams On 9/15/06, Piotr Polewczak <[EMAIL PROTECTED]> wrote:
Hi, i've got problem with hanging arserver, problem appears when one sql process (connection from arserver) starts to lock other processes. Command in blocking process is : sp_cursorclose;1 Resources locked by process are : ARSystem.dbo.servgrp_userlic, ARSystem.dbo.user_cache, ARSystem.dbo.T10 (User) after several minutes almost all arserver processes are locked by first process and arserver hangs, in logs there is info : Dispatch : Timeout during data retrieval due to busy server -- retry the operation (server) ARERR – 93 Problem appears in the high load of the system and when all licences are taken. Enviroment : 2 x ARS 6.3 patch 18 (server group) MSSQL2000 Windows 2003 Thanks for any help, Peter _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org