max memory setting

SQLServerCentral Article

Using Recommendations for MAXDOP and Max Memory During Installation

  • Article

Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings that every DBA (should) change after every single installation. The settings are MaxDOP and Max Memory. This article looks at each of these settings and how they are presented during installation. MaxDOP When an instance of SQL […]

4 (4)

You rated this post out of 5. Change rating

2020-09-01

9,190 reads

Blogs

Azure Workbooks

By

I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...

SQL Prompt Tips–Using $surroundtext$ in a Snippet

By

A user on the SQL Community Slack was asking about what the $surroundtext$ variable....

SQL Server Quickie #46 – SQL Server on Linux

By

Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...

Read the latest Blogs

Forums

The World of Data Science

By urmila880

Comments posted to this topic are about the item The World of Data Science

PowerQuery in SSIS... is it only in 2023?

By pietlinden

First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source,...

Slicing status based on conditions

By MrRobot

Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers