Cannot kill process with EC wait type

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bartolo - 14 Mar 2008 10:11 GMT

Hi
I had tired to create index on large databse (>200GB, engine ss2k) but
I got errors, so I executed DBCC CHECKDB. DBCC told me that I have to
execute it with repair options. But I noticed in Activity Monitor that
I had still running creating index process with EC wait type. Then I
started to kill it but without success.
Is it possible to kill such process, without restarting sql server?

Best regards,
Bartek

Reply to this Message

John Bell - 16 Mar 2008 08:22 GMT

Hi Bartek

The process may be rolling back try KILL WITH STATUSONLY to see what it is
doing.

John

> Hi
> I had tired to create index on large databse (>200GB, engine ss2k) but
[quoted text clipped - 6 lines]
> Best regards,
> Bartek

Reply to this Message

Bartolo - 17 Mar 2008 12:51 GMT

Hi John

Thanks for reponse. I tried this one, it stuck to 100% for few days.
I got reply on another forums that I can't even kill this process with
server restart.
It is really confusing that there is no way to get rid off such
process.

Bartek

> Hi Bartek
>
[quoted text clipped - 13 lines]
> > Best regards,
> > Bartek

Reply to this Message

Bartolo - 18 Mar 2008 08:52 GMT

I succeeded.
It seems that restarting SQL Server is the only opition to get rid of
such process.

Cheers,
Bartek

> Hi John
>
[quoted text clipped - 23 lines]
> > > Best regards,
> > > Bartek

Reply to this Message