Re: sa spid - need to kill - server hanging
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Fri, 25 Aug 2006 09:46:33 -0700
Sounds like adding a column using Enterprise Manager instead of Query
Analyzer...
When you stop the server service, the 'rogue' process will be aborted.
However, when you start the server back up, it may take quite some time for
the last incomplete transaction (the rogue process) to be rolled back and
the server back online. Perhaps that is why it 'seems' that the same rogue
process is back.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Glenn" <gmcintosh@xxxxxxxxxx> wrote in message
news:1156483439.794409.68990@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi
I attempted to add a column to a table containing around 10 million
rows (will do it differently next time :-) and ever since the server
has been hanging and only occassionally can you connect to it and do
anything with it. It all seems to be hinging on a process that is
running as sa user I wasn't logge in as sa though), which I can't kill.
Restarting the SQLServer service and even rebooting the box has no
effect - the process is still there and continues to hog around a gig
of ram and counting and performing endless disk io.
I can't intervene in anyway, it seems. I tried to drop the table that
it all started from, but I cancelled this operation after about 30
minutes. The server has been in this state for around 3 hours now and
not sure how to resolve. The database is dispensible - I can simply
restore from back up so would be happy to drop it but this seems
impossible.
Any suggestions how to stop this rogue process.
Using SQLServer 2000, latest SP.
Glenn
.
- Follow-Ups:
- Re: sa spid - need to kill - server hanging
- From: Glenn
- Re: sa spid - need to kill - server hanging
- References:
- sa spid - need to kill - server hanging
- From: Glenn
- sa spid - need to kill - server hanging
- Prev by Date: Re: Public and Guest
- Next by Date: Re: SQL2005 grant user access to certain tables
- Previous by thread: sa spid - need to kill - server hanging
- Next by thread: Re: sa spid - need to kill - server hanging
- Index(es):
Relevant Pages
|
