Microsoft SQL Server database configuration
The following table lists the Microsoft SQL Server database-configuration settings used during the performance benchmark testing for the tenant databases.
SQL Server setting | Value |
|---|---|
ALLOW_SNAPSHOT_ISOLATION | OFF |
READ_COMMITTED_SNAPSHOT | ON |
PARAMETERIZATION | SIMPLE |
Max Degree of Parallelism | 8 |
Cost of Threshold for Parallelism | 50 |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*