Improve work flow performance in SharePoint
Many of the reasons work flow ‘s work will less performance as expected.
we may encounter the below issues while we run the work flows.
Errors:
1.
When a item
added to the library it takes some times to initiate the workflow.
2.
Workflow
mail generating is not very fast sometimes.
3.
Workflows
takes more time to process
4.
“Due to
heavy load, the latest workflow operation has been queued. It will attempt to
resume at a later time” is coming sometimes.
5.
I had a
custom workflow approval web part and it is taking more than 30 seconds to
proceed.
Improve performance of
work flow:
There are some ways that can
improve the performance of the workflows. In this article I am mentioning the
ways to improve as per my experience.
1. Increase Throttle Size
2. Increase Batch Size
3. Time Out
4. Workflow
Timer Interval
Increase
Throttle Size :
The workflow
throttle setting controls how many workflows can be processing at any one time
on the entire server farm”. since if you can increase the throttle it will help
to increase the number of workflows running at a time.
Following
command shows how to get the existing value. the default is set to 15. from
SharePoint shell to execute this command.
stsadm -o getproperty -pn
workflow-eventdelivery-throttle
You can
change the value by using following command. Below example change the current
value to 25.
stsadm -o setproperty -pn workflow-eventdelivery-throttle
-pv "25"
Increase
Batch Size
Bbatch size
property controls how many work items waiting to be processed by the timer
service will be executed in each run” Therefore if we increase the Batch Size
there will be more workflow items ready to execute in the next time. Batch size
is improving performance in Immediate Execution and Timer Job.
Following
command shows the current batch size in the farm.
stsadm -o getproperty -pn
workitem-eventdelivery-batchsize
as you can
see default value is set to 100. following command will increate the size to
125.
stsadm -o setproperty -pn workitem-eventdelivery-batchsize
-pv "125"
Time Out
Timeout
specify the time which can be take maximum to complete the workflow timer job.
of cause not finished timers jobs can proceed in next cycle. this value
is specify in minutes. default value is 5.
Following
command shows how you can view the current configuration.
stsadm -o getproperty -pn
workflow-eventdelivery-timeout
Following
command will change the existing value to 10.
stsadm -o setproperty -pn
workflow-eventdelivery-timeout -pv "10"
Workflow Timer Interval
Workflow
timer Interval how often SPtimer job should run to process workflow items. this
is specify in the application level not in the farm level like others.
following
command shows the current setting of the web application.
stsadm -o
getproperty -pn job-workflow -url http://Webapplication
If you type
wrong URL following error will come.
|
SPTimer schedule string format
|
Meaning
|
|
"Every 10 minutes between 0
and 30"
|
Timer fires every 10 minutes from
the top of the hour to half past the hour
|
|
"Hourly between 9 and
17"
|
Every hour from 9 A.M. to 5 P.M.
|
|
"Daily at 15:00:00"
|
Timer fires every day at 3 P.M.
|
|
"Monthly at 15 15:00:00"
|
Timer fires on the 15th of every
month at 3 P.M.
|
Following
table shows the values you can set for the property.
Following
command set the workflow timer interval.
stsadm -o
setproperty -pn job-workflow -pv "Every 10 minutes between 0 and 30"
-url http://webapplication:port
I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.
