troubleshooting Question

Optimizing SharePoint 2010 Workflow execution

Avatar of Michael Carrillo
Michael CarrilloFlag for United States of America asked on
Microsoft SharePointMicrosoft DevelopmentMicrosoft Server Apps
12 Comments1 Solution1168 ViewsLast Modified:
I need help optimizing my workflows to execute in less than 5 minutes.

Without getting into too much detail.  I have three lists; Master, POC and Checklist.
Each list has a workflow associated with it.  The POC list iniciates a looping process
that copies list items from Master into the Checklist list.  I had to introduce a delay
of 1 minute in the workflow to allow related list items to be copied successfully into the
new list items. This is really background information. The workflows do work and items are
copied into the Checklist.  The problem is that it only copies one item every 5 minutes.
Despite my changing the following items on the WFE:

Throttle:

stsadm -o setproperty -pn workflow-eventdelivery-throttle -pv "25"
This should allow up to 25 workflows to be executed at a time. (Originally 15)

Batch size:

stsadm -o setproperty -pn workitem-eventdelivery-batchsize -pv "125"
Increased my workflow batch size to 125 workflows. (Originally 100)

Time out:
I kept the same (5 minutes)

Workflow Timer Interval:

stsadm -o setproperty -pn job-workflow -pv 3 -url https://MyApplication_URL/ 
This should allow me to execute workflows in as little as 3 minutes. (Originally 5 minutes)

I verfied that each of these values were set.  
Before changing these values I was getting one item copied every 5 minutes.
After changing these value I get:

1. 3 min
2. 5 min
3. 4 min
4. 5 min
5-500. 5 min each

There appears to be another setting that moves my timer jobs to execute on 5 minute intervals that coincide with the clock (ie start at 3:33, next 3:36, next 3:41, next 3:45, next 3:50, 3:55, 4:00, 4:05, etc.). I need help getting my workflows
to execute in less than 5 minutes for each item copied.
ASKER CERTIFIED SOLUTION
colly92002

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros