[jboss-user] [jBPM] - Re: JBPM 3.2.5, MSSQL 2005 - blocking in JBPM_JOB table

Sash K [http://community.jboss.org/people/swishey] created the discussion "Re: JBPM 3.2.5,MSSQL 2005 - blocking in JBPM_JOB table" To view the discussion, visit: http://community.jboss.org/message/562945#562945 -------------------------------------------------------------- Upgraded to jbpm 3.2.9.  The situation improved somewhat, but still having serious blocking issues.   Before the upgrade over 200 jobs would create blocking issues in mssql server, after upgrade can safely do 500 jobs.  Going to 1000 jobs creates blocking issues, freezing processing for many hours.   On oracle there are no blocking issues, but that was to be expected since oracle does not block.   Upgraded to mssql 2008 as well, but also as expected, did not solve the issue.   Is there some specific information I can provide that would help in troubleshooting ?   Thank you. -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/562945#562945] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]