[Question] Best practices for using SQL Persistance

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,

Start by examining the SQL Persistence Data setup and the workflow host under the reported load of around 3000 concurrent workflows. Done would mean identifying and documenting database and host practices that address the reported performance issues and crashes.

Written by the indexing model from the issue text.