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

10,163 reads

Blogs

A Conversation That Refused to End: What We Learned from Our First Event in Zurich

By

On May 8, 2025, we hosted our first official event in Switzerland at Prime...

A DevOps Workshop Tomorrow in Atlanta

By

Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...

Stop Wasting Time Rebuilding Indexes Every Night

By

Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....

Read the latest Blogs

Forums

is there an elegant way for agent notification to show failure if any step fails

By stan

hi our corp dw load sqlagent job goes to the next step on the...

is there an elegant way for agent notification to show failure if any step fails

By stan

hi our corp dw load sqlagent job goes to the next step on the...

Are Data Breaches Inevitable?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are Data Breaches Inevitable?

Visit the forum

Question of the Day

The Internals of Writing a Page

In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?

See possible answers