Numerous sessions for business rules

Question

On our SQL 2012 server that has the MDS database we are seeing a large number of sessions tied to business rule execution.  These sessions are not closing but instead are in a sleeping or inactive state.  This has caused the application pool to be maxed out and now is causing errors with the workflow manager service.  Is there a setting that will close these connections after completion or is there an underlying problem with the business rule process on our server.  The only error I see is the ones for the workflow manager service not able to connect to the application pool.

Thanks,

Kim Hughes

Answer 1

Consider raising a Connect (Microsoft bug) for this:

http://connect.microsoft.com/SQLServer