Application timing out

• 1dba2b

  Ten Centuries

  Points: 1324

  More actions

  April 13, 2004 at 8:44 am

  #101959

  Hi,

  I have a vendor application running on a SQL2K Enterprise server that periodically times

   out when trying to delete batches of accounting data. The users logon to the app using

  Standard userids, not windows authentication. The query timeout on the server is set at

  1800 seconds. The timeouts are occurring  almost immediately, not even close to the designated

  timeout period set for the server. Nothing shows up in the Event Logs or the SQl Logs when

   the application tiemsout. While doing a trace of the users application running attempting to

  reproducethe error, I noticed that the application (which is poorly designed IMHO), is constantly

  loggin on and logging off. Since the trace has not produced any indications of the error, I wonder

  if the sqlserver has a problem where it is maybe leaking memory or something like that? When

  I bounce the SQL services, the user can successfully run their delete processes. 

  This machine is running SQL2K Enterprise , Service Pack 2, 2GRam on a Dual Processor 1GHZ DELL.

  Any Ideas where to look? Oh, the service pack can't be upgraded to 3a becausethe vendors application will break.

  THANKS!

• Alamir

  SSCertifiable

  Points: 6085

  More actions

  April 14, 2004 at 8:45 am

  #502744

  what is the programming language you use in your Application ?

  try to use (NOLOCK) in table hint when you select data from table

  I hope this help u

  
  Alamir Mohamed
  Alamir_mohamed@yahoo.com