[dba-SQLServer] SQL Server not locking up

Nancy Lytle nancy.lytle at gmail.com
Fri Oct 2 07:23:28 CDT 2009


I keep forgetting most people have actual dedicated SQL machines.  My SQL machines are file servers, application servers, IIS servers, and SQL Servers, so there is a lot to spread around.

Just glad you got it working for your needs.

Nancy Lytle 
N_Lytle at terpalum.umd.edu











 EMAILING FOR THE GREATER GOOD
Join me


 
> Date: Fri, 2 Oct 2009 08:13:38 -0400
> From: jwcolby at colbyconsulting.com
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] SQL Server not locking up
> 
> 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
> > 
> > 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
 		 	   		  


More information about the dba-SQLServer mailing list