Microsoft SQL Server database configuration 18.08

The following table describes the Microsoft SQL Server database-configuration settings used during the performance benchmark testing.

Note

The database system was shared with many other active databases.


Below configurations are set in Database Properties -> Options

SQL Server setting

Value

ALLOW_SNAPSHOT_ISOLATION

OFF

READ_COMMITTED_SNAPSHOT

ON

PARAMETRIZATION

SIMPLE


Below configurations are set in Server Properties -> Advanced

SQL Server setting

Value

Cost Threshold for Parallelism

50

Max Degree of Parallelism

8

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*