Wednesday, February 5, 2014

Max utility parallel degree

Running ASE 15.7 at a high patch level? Say, 100 or higher? Having trouble running BCP, index creation, etc. in parallel? Here's why:

There's a new configuration parameter.


max util parallel degree specifies the server-wide maximum number of worker processes allowed per query used by the create index with consumers and update stats with consumers commands.

Enjoy!