[dba-SQLServer] HELP, server completely unresponsive

Hi John,

I havn't followed this thread closely but...
Is it possible the tempdb is running out of space?
Or maybe the log or the db itself?

If you can eventually see the server from another server try looking for
any blocking processes, might give you a clue.

Cheers

Michael M


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, 29 September 2009 11:23 AM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] HELP, server completely unresponsive

When browsing for network servers from another machine, I normally see
about a half dozen servers 
which includes Azul (the SQL Server that is currently locked up).  ATM I
can see all of the other 
servers but not AZUL so it is not answering up, at least not in time to
be counted.

It is still "processing" the query I started this AM.  11:23:15 and
counting.  All of this to set a 
field in 20 million records based on values in about 5 other fields, all
of these other fields in an 
index.  The target field is not indexed (yet).  It should never take
this long.  This operation 
normally takes about an hour.  But I know of no way to regain control of
the server short of 
rebooting, and if I do that I will likely corrupt the database being
written to.

John W. Colby
www.ColbyConsulting.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com