The MAXDOP value should be set respective to the number of cores defined to the SQL server.

Use the following table to find the correct value:

Mandatory: must not be less than 15

Recommended: 15

By default, the xp_cmdshell option is disabled.

It is recommended that you do not change the default value.

xp_cmdshell is an essential mechanism to execute arbitrary calls in the system using either the SQL Server context (that is the Windows account used to start the service), or a proxy account configured to execute xp_cmdshell using different credentials.

Mandatory: true

See Enable Optimize for Ad Hoc Workloads option.

Mandatory. Define four tempdb database filegroups.
The tempdb database is a global resource available to all users connected to the instance of SQL Server.

Pre-allocation configuration: Four data files with equal size;

Each data file:

• Auto grow = true

• File growth In percent: 20%

• Max size = 32GB

Log file:

• Auto grow = true

• File growth In percent: 20%

• Max size = UNLIMITED

Note| If the EM Config tab in the tailored CFE Guide is hidden, unhide it.

Mandatory. Set according to individual company policies since the system does not use the SQL Server Browser.

Mandatory. Enable shared memory and TCP/IP.

Mandatory. Validate the SQL Credential object’s ability to run scripts on the server. The object is created on assigning database permissions to the service accounts.
Perform these steps for the SQL Credential or for the default user:

1. In the Registry Editor, browse to

   HKEY_LOCAL_MACHINE\Software\Microsoft\Windows Script Host\Settings\

   HKEY_USERS\.DEFAULT\Software\Microsoft\Windows Script Host\Settings\

2. Validate that there is a Settings folder. If not create one.