December 23, 2009 at 8:17 am
how to find out all my processors are using equally or parallels’, The server I am using has 1 core and running SQL 2005 standard with 4 processors,
there is any way we can change the setting
December 23, 2009 at 8:26 am
You can check Performance Monitor/System monitor to see if all 4 CPUs are being used. There is are also a few settings for parallelism.
If you have the affinity mask set to anything other than 0, you might not be using all CPUs. I wouldn't change this to something other than zero without a good reason. http://msdn.microsoft.com/en-us/library/ms187104(SQL.90).aspx
There is a max degree of parallelism (MAXDOP) that you can set as well. It limits the number of CPUs used for a query http://msdn.microsoft.com/en-us/library/ms181007%28SQL.90%29.aspx
December 23, 2009 at 8:50 am
it means if i have 4 processerors is using all in paraller's.
if I want to you only 2 what can i do
December 23, 2009 at 9:12 am
What does this mean? "if I want to you only 2 what can i do"
Do you mean only use two processors for SQL Server? You can use the affinity mask to limit to 2 CPUs, but you still must license 4 if you are using CPU licensing.
December 23, 2009 at 9:34 am
so that means if I have 4 processors then all of them use paraller, if I change to 2 processors the they will be used as paraller or not.
December 23, 2009 at 9:40 am
By default, all of your processors will be used. You can use less if you configure the affinity mask.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply