Hi, need your help. Is there any way Table Publish can use more then one processor thread?
We've got HUGE Publish process and it always uses max 1 thread although there is a 32 thread cluster willing to pick some job ;-)
Guys, you're advice highly appreciated!
BTW, DB is MSSQL2005
Is the publish container allocated to the job server cluster directly or is it assigned to a dedicated single job server? In most cases you should allocate it to the cluster.
Please check also the properties of you different job server. You should be set to using CPUs with '-1' which means that it uses all the processors available. Furthermore all job server services should use the same domain user which has local admin rights on the different servers.
When using a version below 8.2 check if the COM+ object for planning is using the identity of the same user as the user account used by the planning service.
Publish container is assigned to the cluster.
Settings are ok from the side of planning cluster.
I think the problem is with the database process used by EP to perform publish, not in the planning itself.
But I don;t know the solution for that