Deadlock Problem

• Kashif

  SSCommitted

  Points: 1881

  More actions

  November 20, 2002 at 2:18 am

  #159200

  I don't know why is it so. We are using a stored procedure that implements a complex business logic. it uses selects, inserts, updates and calls other SPs. When 2 or more users run this SP deadlock occurs but if Profiler is running deadlock does not occur. Whats the problem? why deadlock is not occuring when using Profiler? We r using SQL Server 7 SP3. Database size is 3G.

  Thanks in advance.

• Simon Sabin

  SSCrazy Eights

  Points: 8142

  More actions

  November 20, 2002 at 4:11 am

  #441813

  POssibly because of the time it takes to send the information to the profiler, are you running it local to the server or remotely

  Simon Sabin

  Co-author of SQL Server 2000 XML Distilled

  http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

  
  Simon Sabin
  SQL Server MVP
  
  http://sqlblogcasts.com/blogs/simons