July 22, 2009 at 11:18 am
I have a SQL 2000 server running on a DL380 G4 with 2 dual Xeon 3.6GHz processors. In SQL properties it by default uses all 4 CPUs. Since this box is also running an intranet site so I unchecked CPU 0 leaving CPU 1 - 3 for SQL to use. I observed and see that the second CPU is heavily used compared to the first CPU. In Compaq Insight Manager it shows the average ultilization of the first CPU is 7% while the second CPU is 38% in the last hour. In SQL configuration is there a better way to devide the load between 2 processors? Also in SQL properties, it shows CPU 0 - 3. Is CPU 0 and CPU 1 the first physical CPU or CPU 0 and CPU 2 the first physical CPU?
Please see the attached.
Thanks
July 22, 2009 at 11:52 am
Have you set the processor affinity for intranet site? See http://www.iishacks.com/index.php/2007/05/18/setting-processor-affinity-permanently/
Once you have determined which cpu to use for the intranet site,then you can un-assign this CPU from SQL Server.
in SQL properties, it shows CPU 0 - 3. Is CPU 0 and CPU 1 the first physical CPU or CPU 0 and CPU 2 the first physical CPU?
CPU0 and CPU1 are the two cores on the first CPU and CPU2/CPU3 are on the second CPU.
SQL = Scarcely Qualifies as a Language
July 22, 2009 at 12:07 pm
Interesting info. I will make the change and observe. Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply