We are deploying Flowable 7.2 in production with SQL Server as our backend database. Our architecture includes Flowable Engine (port 8081) communicating via HTTP tasks to a Spring Boot API layer (port 8080), which calls external client APIs. We need official guidance on the following:
1. Database Indexing: What are the recommended indexing strategies (clustered/non-clustered) for Flowable tables? Which columns should be indexed for optimal performance? What is the recommended index maintenance strategy (rebuild/reorganize frequency)?
2. Database Maintenance: Best practices for archiving/purging historical data? Recommended SQL Server connection pooling settings? Any query optimization techniques?
3. Server Sizing & Capacity Planning: Official recommendations for production environment: RAM, CPU cores, JVM heap allocation for Flowable Engine and Spring Boot API layers? Any performance benchmarks for Flowable 7.2?
4. Clustering: Resource requirements if we implement clustered Flowable deployments on SQL Server?
5. Performance Metrics: What key metrics should we monitor?