DBCC
Database
1
Posts
1
Posters
10
Views
1
Watching
-
Hi there, I have an online job that is being executed on regular schedules. On some occassions, while going through various stored procedures, a DBCC process with a spid of 6 is created. Around the same, I see a message inidicating that a deadlock has been resulted between my currently running process and this DBCC process. This running DBCC process causes the CPU to be utilized massively and being a system process, can not be killed, unless I re-start the SQL Server. I was wondering how one could find out the reason this DBCC process starts off to begin with? HOw do I know which DBCC command it is? thanks X| :confused: