View Source

If you already have an effective configuration, this is NOT mandatory If you have questions regarding the existence of an existing configuration, contact your DBA (database administrator) for more information. Database administrators should carefully review, understand, and incorporate the following concepts into your existing environment, if necessary.

By default, SQL server will use the following CPUs and memory when you check the SQL server properties from SQL Management Studio:

Public Documents > 1099 Pro CS SQL Server Configuration Recommendations > image2018-2-16_14-41-11.png

For intense SQL tasks, the SQL server can consume all the CPU on the server and bottleneck Windows OS. For this reason, we recommend you reserve CPU to the Windows OS.

Allocate 1 CPU if the total CPU is less than 8 CPUs, or, 2 CPUs if the total CPU is 8 or more. You can allocate the following CPUs:

Public Documents > 1099 Pro CS SQL Server Configuration Recommendations > image2018-2-19_11-27-7.png

For memory, we recommend allocating 80% to SQL server. In the following example, we allocated 6GB out of the total 8GB system memory to SQL server:

Public Documents > 1099 Pro CS SQL Server Configuration Recommendations > image2018-2-16_14-52-5.png