none
Designing a workflow for performance using SharePoint 2013 workflow RRS feed

  • Question

  • Hello, and thank you in advance.  I am in the process of designing a workflow and this variation I thought may improve performance. This is a multi-step workflow which will have 8 workflows (instead of packing it all into one). Each workflow will be executed based on a dollar amount in the list item.

    When a list item is created do all 8 workflow files get stored in memory? Will there be performance issues? I'm more curious what happens behind the scenes. 

    Thanks.

    Thursday, July 18, 2019 4:27 PM

Answers

  • Hi AdamDoubleYou,

    If you create workflows using SharePoint designer everything will be stored in the content database.

    Testing has confirmed that a SharePoint web server can activate a maximum of 6 workflow instances per second. This number is cumulative, and therefore scales with the number of web servers in the farm. For example, 2 web servers can activate 12 workflow instances per second, and 3 web servers can activate 18.

    More information:

    https://docs.microsoft.com/en-us/SharePoint/install/software-boundaries-and-limits#Workflow

    Given your situation, running 8 workflows at the same time doesnot cause performance issues.

    And it's a good idea to execute the sub-sequent 8 workflows through a parent workflow.

    Best regards

    Itch Sun


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Friday, July 19, 2019 2:58 AM

All replies