The following information provides guidelines for SQL Server configuration for a Workflow (Process Manager) Database server. You can follow these guidelines to tune the performance of the SQL Server that hosts the Process Manager database. These guidelines are not exclusive, and additional configuration options may be appropriate depending on the specifics of your environment. For detailed information about SQL Server configuration, refer to Microsoft's documentation.
Table: SQL Server configuration options
Hardware: processors and memory
Having sufficient processors and memory lets you tune the performance of your SQL Server. 4 to 8 cores are common in well-performing environments.
Disk drive channel configuration
How you configure the disk drives and the controllers that interface those to your SQL server has a large influence on your overall performance. You can use disk drive channel configuration recommendations to maximize throughput and tune the performance of your SQL Server.