var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: What will be No.of partitions of a table in this case
Is there any relationship between
No. of CPU , DOP(Degree of Parallelism) and No.of partitions of a table ?
The problem is as follows :
I've a table , containing 30 GB of data. We have
no. of CPU = 20
parallel_threads_per_CPU = 2 (NOT SURE)
parallel_max_servers = 40
A.Now What should be the DOP here ?
Is it 20*2 = 40 ?
B.Which one is preferable from the following options to decide the no. of partition
of the table , to acheive best performance :
1. No. of partition = The power of 2's (>= 40)
2. No. of partition >= multiple of 40's