InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 07:52:36 GMT20http://www.sqlservercentral.com/Forums/Topic685924-149-1.aspxSince moving two Databases and several SSIS Packages I'm having issues with the AS400 iSeries and I'm getting Communication errors.Several task fail. It seems that the task complete much faster and as if the AS400 can't keep up with it.Should I limit the number of processors?If I limit the number of parallel loads, SSIS Tasks, I have been able to avoid the error.I have 1 64 bit Windows Server 2008 R2 running SQL Server 2008 R2.I looked it up on BOL but I have never had to mess with changing the number of processors.Any ideas would be greatly appreciated. Mon, 21 May 2012 13:39:12 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic685924-149-1.aspxthank you for this helpTue, 31 Mar 2009 01:18:24 GMTegpotushttp://www.sqlservercentral.com/Forums/Topic685924-149-1.aspxBTW - when they say SQL Server can only use 4 CPU's - they are talking about slots. A single quad core processor is one CPU's as far as licensing and utilization. So, SQL Server Standard can use up to 16 CPU's if you use 4 quad-core processors.Mon, 30 Mar 2009 14:20:20 GMTJeffrey Williams 3188http://www.sqlservercentral.com/Forums/Topic685924-149-1.aspxFirst disable the automatic affinity in the check box below.Mon, 30 Mar 2009 09:27:50 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic685924-149-1.aspxThose parameters cannot be update using SSMS, do you know why ?Mon, 30 Mar 2009 08:32:41 GMTegpotushttp://www.sqlservercentral.com/Forums/Topic685924-149-1.aspxJust open up the Server Properties in SSMS. On the Processors page you can see how many processors you have available and set them to a particular affinity. I'd suggest reading up in the BOL prior to setting it, just so you get it right.Mon, 30 Mar 2009 06:54:20 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic685924-149-1.aspxI have one server with 8 CPU (CPU0, CPU1... CPU7) , I am using 2005 Standard Sql version so I am limited to 4 CPU. I have 2 instances running on my server, how can I tell one instance, using affinity mask, to only use CPU4 to CPU7?Mon, 30 Mar 2009 04:21:20 GMTegpotushttp://www.sqlservercentral.com/Forums/Topic685924-149-1.aspxYou can use Affinity mask. From my experience, SQL Server performed better when i left SQL Server to automatically set the affinity...Mon, 30 Mar 2009 04:13:51 GMTDavid Sorauerhttp://www.sqlservercentral.com/Forums/Topic685924-149-1.aspxHi,Is it possible to tell SQL server to use only 4 processors out of 8 ?I would like to dedicate 1 SQL server instance to processor 0 to 3 and a Second SQL server instance to processor 4 to 7, is it possible?Can I use affinity mask Option ?regardsMon, 30 Mar 2009 03:18:26 GMTegpotus