[Question] Best practices for using SQL Persistance

[ljcbn]

Hello,

We are using Workflow Core to launch and manage a lot of complex workflows. For this, we are using SQL Persitance Data.
Unfortunally, we are encountenring some performance issue. Our workflow host seems crash due to the amount of data (around 3000 workflows are working concurrencely) and stoppes.

What are the best pratictices that we could use on our database and workflow host to fix it ?

Thanks,

[ljcbn]

We are adding workflow core with this into Program.cs in our webservice hosting our workflow host with the following code :

var configuration = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json")
.Build();

builder.Services.AddWorkflow(x => x.UseSqlServer(configuration.GetConnectionString("SQLPersistence"), true, true));

The problem seems to be a cached problem with too much object managed by the host