Home > Workload Solutions > SQL Server > Guides > Implementation Guide—SQL Server 2019 Best Practices on PowerStore > SQL Server configuration
The SQL Server instance configuration includes many default settings that reflect a new installation of the database. Table 9 includes a subset of the database configuration parameters to show the baseline settings.
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 helps customers address database growth challenges using these validated recommendations.