Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chander_2580
Yak Posting Veteran
76 Posts |
 Posted - 2007-11-25 : 17:20:46
|
| Hi gurus Please help me in getting out of critical situation.. actually DBCC runing in the backgroung blocking two other important processes, including one job which is very important... i m working at client side and hence cant afford any single error... due to blocking the time taken by job start exceeding from normal to abnormal.. please tell me how to unblock the processes caused by DBCC.Thanks & RegardsChander |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-25 : 19:41:56
|
| Kill the dbcc. |
 |
|
|
chander_2580
Yak Posting Veteran
76 Posts |
Posted - 2007-11-25 : 20:41:30
|
That is a system process cant kill this .... quote:
Originally posted by rmiao
Kill the dbcc.
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-25 : 21:09:26
|
| What does DBCC INPUTBUFFER(spidGoesHere) show for this blocking spid?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2007-11-25 : 22:01:13
|
| chander,what are those two important processes running at that time, what does the job do?its me monty |
|
|
|
|
|
|
DBCC Blocking