Archives of the TeradataForum
Message Posted: Fri, 07 Nov 2003 @ 20:49:28 GMT
Subj: | | Re: What is CPU Skew? |
|
From: | | Ruth Fenwick |
The system is only as fast as the slowest node. Skewed CPU is detrimental in two ways:
1) the skewed query looses the benefit of parallelism - all the work is on one node
2) that 1 node will be busier than the others, which means that other queries (that are parallel) will slow down because they
will all have to wait for the slow node to respond.
Ruth Fenwick
Database Services
|