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