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!
Posted by at

5 comments:

  1. 21cssIndiaMarch 4, 2014 at 12:36 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  2. 21st Century Software SolutionsAugust 28, 2014 at 2:45 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  3. chaitanyaDecember 6, 2019 at 4:31 AM

    Hi All,

    Im facing issue while inserting data into temp table in sybase ase database and accessing it parallel and table getting lock. How to over come the issue.
    --Thankq

    ReplyDelete
  4. Bangalore Training AcademyDecember 24, 2019 at 1:58 AM

    Very interesting, good job and thanks for sharing such a good blog. Thanks a lot…
    Workday Training in Bangalore
    Workday Courses in Bangalore
    Workday Classes in Bangalore
    Workday Training Institute in Bangalore
    Workday Course Syllabus
    Best Workday Training
    Workday Training Centers

    ReplyDelete
  5. Yasodha VarmanFebruary 4, 2022 at 7:22 AM

    Jump into an immense learning experience of DevOps Training in Chennai from Infycle Technologies, the finest software training Institute in Chennai. Also, an excellent place to learn other technical courses like Cyber Security, Graphic Design and Animation, Block Security, Java, Cyber Security, Oracle, Python, Big data, Azure, Python, Manual and Automation Testing, DevOps, Medical Coding etc., and here we provide well-experienced trainers with excellent training to the freshers. And we also provide 100+ Live Practical Sessions with Real-Time scenarios which helps the students in learning the technical stuff easily and they are able to get through interviews in top MNC’s with an amazing package. for more queries call us on 7504633633, 7502633633.

    ReplyDelete

Subscribe to: Post Comments (Atom)