Default language.

Microsoft SQL Server database configuration 20.02

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.

Setting the database properties

Go to Database Properties > Options and configure the following:

SQL Server setting

Value

ALLOW_SNAPSHOT_ISOLATION

TRUE

READ_COMMITTED_SNAPSHOT ON

TRUE

PARAMETERIZATION

SIMPLE

COMPATIBILITY LEVEL

SQL SERVER 2017

Setting the server properties

Go to Server Properties > Advanced and configure the following:

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*