How to configure settings as per the System Information Overview
System information (available from the Help menu in front end tools: Help | Info... ) reports settings that should be meeting a recommended value, e.g.:
maximum degree of parallelism
How and where are these settings changed?
Recommended values are those required for optimal performance. Highlighted rows are those that should be adjusted to optimize performance.
Regarding the settings to be changed on the SQL Server, these changes can be made using Transact SQL, or from within SQL Management Studio or Configuration Manager. Some notable examples and how to change them follow.
Please note that these are advanced options and should be changed only by an experienced database administrator or certified SQL Server professional.
The server collation is specified during SQL Server installation. Default server-level collation is SQL_Latin1_General_CP1_CI_AS. Please use caution as changing the default collation for an instance of SQL Server can be a complex operation.