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.
maxutilparalleldegree 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.
I've been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2, and Sybase ASE since release 4.0.1. Since then, I've worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.
I have been working on large-scale systems for most of that time, having tuned a 100-gig/week throughput application on MS SQL Server 6, and created one of the first ASE data warehouses.
My background includes work experience from PC's to Mainframes and back again, in all aspects of IT, from developer, to DBA Manager, to IT Executive. My specialty is performance and tuning with a special emphasis on large-scale projects with very large databases. I am very well known in the industry, having spoken at user conferences and user groups for many years, written articles and columns for many magazines nationally and internationally, as well as having written over a dozen books.