Hi,

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