jwcolby
jwcolby at colbyconsulting.com
Fri Oct 2 07:13:38 CDT 2009
Nancy, The server (machine) is for SQL Server so it makes sense to give SS as much power as you reasonably can. John W. Colby www.ColbyConsulting.com Nancy Lytle wrote: > 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 >> > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >