Workflow Database on SQL Express

asked on July 17, 2018

Hello All,

We have a client that runs a large amount of Workflows (around 2500) per day. This has, in turn, filled the database to its 10Gb limit. I know the best answer is to upgrade to full SQL Server but it is not financially feasible for them at this time.

We have created some Workflows that use SQL queries to clean up the log tables (Anything older than 5 days is removed). This has allowed us to keep the database under the 10Gb limit.

However, there are two tables dbo.workflow_code and dbo.search_message that have a total size around 7Gb.

Is there any way to truncate them in a similar way without damaging something? It is my understanding that these tables contain live data?

Thanks in advance

0 0

replied on July 18, 2018 • Show version history

I'm not sure about modifying Workflow's tables directly like that since there is a lot of interdependence, but have you tried adjusting the Workflow server options to shorten how long some of the data is kept before it is cleared out by the automated maintenance?

2 0

View 1 previous reply

replied on July 18, 2018 • Show version history

It was worth a shot. In that case, I'm not sure SQL Express is going to be able to handle that level of activity.

Is your client on Avante or Rio? If they have Rio, one option may be to split the workload between two workflow servers.

We're not using Express, but we are running around 10,000 workflows per hour so we have multiple workflow servers with separate databases.

Our main reason for this configuration is to distribute the work load, but in your client's case it would be a way to split the data up between two databases.

If that is an option, I think it would be preferable to messing around with the workflow database directly.

If I'm not mistaken the 10GB limit is per database, not per server, so they would need another workflow server, but they could use the same database server.

0 0

replied on July 18, 2018

They are using Avante. The initial scope was a lot smaller than what they have expanded to now. They have grown their LF use a lot sooner than they expected.

Anyway, thanks for your suggestion about the additional workflow server.

0 0

replied on July 19, 2018

Jason is right, modifying the database directly is not supported.

One reason you might not be seeing much of a difference with the built-in cleanup settings is because they're set to a fairly narrow window at night so they don't impact performance. Look in the Workflow Admin console under server timers and extend the time for the database cleanup one.

0 0

Question

Question

Workflow Database on SQL Express

Replies

Sign in to reply to this post.