Home > Workload Solutions > SQL Server > White Papers > SQL Server 2019 Best Practices on PowerEdge Servers and PowerStore T Model Arrays > SQL Server Configuration
The SQL Server instance configuration includes many default settings that reflect a new installation of the database. The following table includes a subset of the database configuration parameters to show the baseline settings.
Table 7. Instance configuration parameters
Parameters | Values |
Maximum Degree of Parallelism (MAXDOP) | 0 |
Cost Threshold of Parallelism | 5 |
Recovery mode | Full |
Query Optimizer fixes | OFF |
max worker threads | 0 |
Min server memory | 98304 MB |
Max server memory | 98304 MB |
The overall profile can be labeled as an entry-level database through a review of the configuration parameters. An entry-level database configuration provides a foundation to build upon best practices. Over the course of validating best practices the database configuration will change to optimize performance. Starting with a minimal configuration and adding best practices can help customers address database growth challenges using these validated recommendations.