Home
%3CLINGO-SUB%20id%3D%22lingo-sub-571865%22%20slang%3D%22en-US%22%3ESharePoint%20Workflow%20settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-571865%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20TECHNET%20on%20Apr%2019%2C%202018%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20Hello%20All%2C%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Customer%20recently%20asked%20me%20about%20this%20and%20since%20i%20had%20to%20go%20hunting%20I%20figured%20i%20would%20leave%20this%20here%20for%20you.%26nbsp%3B%20Users%20are%20having%20problems%20running%20Workflows%20they%20will%20run%20sporatically%20and%20sometimes%20take%20quite%20a%20bit%20of%20time%20to%20execute.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Here%20are%20the%20commands%20that%20I%20recommend%3A%20%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3ESetting%20the%20Throttle%20Size%2C%20this%20is%20a%20setting%20that%20defines%20the%20maximum%20number%20of%20concurrently%20running%20workflows%20in%20IIS%20against%20a%20content%20database%2C%20The%20default%20value%20is%2015.%20%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3ETo%20set%20it%20run%20this%20command%2C%20where%20XX%20is%20the%20threshold%20you%20want%20to%20set.%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%3CBR%20%2F%3E%20Set-SPFarmConfig%20-WorkflowPostponeThreshold%20XX%20%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3E%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3ETo%20review%20what%20is%20currently%20set%20run%20this%20command%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%3CBR%20%2F%3E%20Get-SPFarmConfig%20%7C%20FT%20WorflowPostponeThreshold%20%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3ESetting%20the%20Batch%20size%2C%20This%20is%20the%20items%20that%20are%20allowed%20in%20the%20queue%20of%20the%20Timer%20Service%20(Per%20server%20it%20is%20running%20on).%26nbsp%3B%20Suggest%20this%20number%20be%20larger%20than%20throttle%20size%20to%20provide%20a%20better%20end%20user%20experience%20while%20protecting%20the%20SharePoint%20service.%20NOTE%3A%20Since%20Timer%20Service%20handles%20lots%20of%20other%20services%2C%20workflow%20is%20not%20necessarily%20its%20main%20priority.%20%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3ETo%20set%20it%20run%20this%20command%2C%20where%20XXX%20is%20the%20batch%20size%20you%20want%20set%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%3CBR%20%2F%3E%20Set-SPFarmConfig%20-WorkflowBatchSize%20XXX%20%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3E%3CBR%20%2F%3E%3COL%3E%3CBR%20%2F%3E%3CLI%3ETo%20review%20what%20is%20currently%20set%20run%20%26nbsp%3Bthis%20command%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FOL%3E%3CBR%20%2F%3E%20Get-SPFarmConfig%20%7C%20FT%20WorkflowBatchSiz%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20See%20this%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fsharepoint-server%2Fset-spfarmconfig%3Fview%3Dsharepoint-ps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20article%20%3C%2FA%3E%20if%20you%20are%20curious%20about%20other%20settings.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Pax%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-571865%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20TECHNET%20on%20Apr%2019%2C%202018%20Hello%20All%2CCustomer%20recently%20asked%20me%20about%20this%20and%20since%20i%20had%20to%20go%20hunting%20I%20figured%20i%20would%20leave%20this%20here%20for%20you.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-571865%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBatch%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPerformance%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerShell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eslow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ethrottle%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWorkflow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
First published on TECHNET on Apr 19, 2018
Hello All,

Customer recently asked me about this and since i had to go hunting I figured i would leave this here for you.  Users are having problems running Workflows they will run sporatically and sometimes take quite a bit of time to execute.

Here are the commands that I recommend:

  1. Setting the Throttle Size, this is a setting that defines the maximum number of concurrently running workflows in IIS against a content database, The default value is 15.

    1. To set it run this command, where XX is the threshold you want to set.




Set-SPFarmConfig -WorkflowPostponeThreshold XX



    1. To review what is currently set run this command




Get-SPFarmConfig | FT WorflowPostponeThreshold

  1. Setting the Batch size, This is the items that are allowed in the queue of the Timer Service (Per server it is running on).  Suggest this number be larger than throttle size to provide a better end user experience while protecting the SharePoint service. NOTE: Since Timer Service handles lots of other services, workflow is not necessarily its main priority.

    1. To set it run this command, where XXX is the batch size you want set




Set-SPFarmConfig -WorkflowBatchSize XXX



    1. To review what is currently set run  this command




Get-SPFarmConfig | FT WorkflowBatchSiz

See this article if you are curious about other settings.

Pax