Deadlocks

[Guest_imported]

Hi there,

I was wondering if you have ever experienced a deadlock between your process
and a SQL Server process?

I have a stored procedure which consists of a lot of select statements and
two dynamically created insert statements . The stored procedure is called
during a job. However, as it is run, quite often I get the infamous deadlock
error message. however, looking at the results, nothing looks out of ordinary,
but the problem is the log messages that it leaves and the fact for some
reason, the sqlserver CPU shows as being at 50% even when there is nothing
running. The deadlock is between a SQL server's DBCC Process Number 6 and
my process. I have tried but I can't find what DBCC command is being executed.

Any ideas?

 

[Guest_imported]

Actually to further elaborate on my problem, this is the sequence of events I have..


1) I have a job that consists of two steps.
2) In the first step, I have a set of C++ calculations that interact with the database for about 20 minutes or so and then, are done.

3) Once these calcs are done, the second step begins. It goes through the data calculated by the C++ calcs and does some data gathering and inserting into a final results table.

I seem to have a problem in the second step when I see the SQL Server reporting deadlocks. During this period, only the stored procedure runs.

During its run, it does as following:

begin stored procedure A

call stored procedure X to get some value
call stored procedure X to get another value
call stored procedure X to get another value
call stored procedure X to get another value

Insert these values into a result table

end stored procedure A

It's during this stored procedure SP, when the process runs into a system DBCC process.

Any ideas?