June 22, 2004 at 9:34 am
Hi!
I have a server (HP 6xPIII-700 Xeon). When I run cube processing, I do only load one processor. What setting should I change to use all available processors? (Using MS SQL2000 sp3 + MS Win2000 Adv Server sp4)
Thanks.
June 25, 2004 at 8:00 am
This was removed by the editor as SPAM
June 29, 2004 at 5:47 am
AS doesn't have the built in option to use or not use a particular processor like SQL has. But if you go into the AS server properties (in AS manager, rightclick the server name, select Properties, select Environment) you will find "Maximum number of threads" which allows you to select how many processor threads to enable. It should default to 2 threads per processor.
EDIT: also, you might expect to see your server spreading the processor power across all processors but it really depends on what the job is doing. a cube rebuild goes through many steps, so at any particular point in time it may be doing only one thing - therefore you will see it working on only one processor. it would actually slow things down if it were to switch back and forth from processor to processor during that single task.
October 13, 2004 at 10:29 pm
You might be interested in http://www.microsoft.com/downloads/details.aspx?FamilyId=A2EEF773-6DF7-4688-8211-E02CF13CBDB4&displaylang=en, the Parallel Processing utility.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply