[dba-VB] Half the databases in recovery

Hi John:

I know little or nothing about multi-threading or Parallelism but what I
understand is that the 'old' system of multi-threading is not to be confused
with Parallelism. Multi-threading if setup incorrectly could cause the
situation as you described.

The one person that I know that could help would be a guest lecturer, named
Tiberiu 'Tibi' Covaci, who gave a couple of seminars on Hyper-threading and
Parallelism, up at the local university. He also said if we had any issues
on implementing the process just email him at:

http://tibi@multi-core.net

His web site is: http://blog.multi-core.net/

Hope this helps.
Jim 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, June 09, 2010 7:09 PM
To: VBA; Sqlserver-Dba
Subject: [dba-VB] Half the databases in recovery

Holy smoke batman.  This time, the server locks up, I end up rebooting
(after hours of waiting "to 
see") and about 15 different databases are "in recovery".  Man that will
cause your heart to stop.

After only a few minutes I refreshed the databases and only one was still in
recovery - the temp 
database that was being worked with when the lockup occurred.

I have never seen databases in recovery that weren't actively involved in
operations when the lockup 
occurred.

Strange!

-- 
John W. Colby
www.ColbyConsulting.com
_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com