DSXchange

Hi

This is a general question. How will you configure processing nodes and is there any limit for processing nodes for a processor and do we need to do any scheduling for nodes... i don't know whether these questions are appropriate, but well these thoughts bugs my mind.


Thanks
Mark

THere are no technical limits; only sensible ones. Don't overload any machine - for example you would not configure 24 nodes on a four CPU machine in general!
No scheduling by you is necessary; the PX engine looks after allocation of notes based on the configuration file that you specify. Note that you can specify different configuration files for different jobs; for example you would use a single processing node for a tiny job that only processes a few rows.

Hi,

Following Mark's Question What do they mean by CPU and what do they mean by Node? In one of the posts I found through search which says that number of nodes should be the half of the number of CPU's for better performance. Pls clarify

Thanks
--Rich


A little bit of ink is powerful than the strongest memory

The General rule of the thumb is - Two processing nodes per cpu

Regards

Even that may be too many, there are times, for example when the database server (on the same machine) also needs CPUs, or you are doing some really intensive processing in your ETL, that you'd configure maybe one processing node per two CPUs.