[dba-SQLServer] SQL Server not locking up

Thanks John.  I know that solution has worked for me, and it is one that is often over looked.  If it ever acts up again you could drop it one more, down to 2.  But hopefully you have hit the sweet spot already.

Nancy Lytle 
N_Lytle at terpalum.umd.edu









 EMAILING FOR THE GREATER GOOD
Join me
 
> Date: Thu, 1 Oct 2009 21:03:22 -0400
> From: jwcolby at colbyconsulting.com
> To: dba-sqlserver at databaseadvisors.com; dba-vb at databaseadvisors.com; accessd at databaseadvisors.com
> Subject: [dba-SQLServer] SQL Server not locking up
> 
> I am hesitantly declaring victory in the SQL Server war. I am going to award Nancy Lytle the award 
> for the correct solution, with the proviso that she has to give it back if it turns out that the 
> wily server misbehaves again. Since setting Max Degree of Parallelism to 3 I have not been locked 
> out again. Understand that about this same time I also changed processor I/O affinity to only use 
> the same three CPUs that I set CPU affinity for.
> 
> And I have had so many problems with this, where it went away and then came back that I am very 
> hesitant to declare victory but I did want to report back that the "locking up" issue hasn't 
> recurred lately.
> 
> Thanks go to everyone who volunteered suggestions.
> 
> -- 
> 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
>