max memory setting

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 […]

3.67 (3)

2020-09-01

2,945 reads

Blogs

Daily Coping 25 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 24 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Always On - tips for running large transactions

By NicHopper

Hi all, I wanted to get a second opinion on something, this weekend I...

Encrypted column copy

By IT researcher

I am using SQL Server 2008 R2. I have encrypted some of the columns...

SQL query error help

By rocky_498

Hi Guys, I have a table, around 320 fields. I am trying to use...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers