SQL / Uncategorized
SQL max memory is a buffer pool limit, not a total
The number in the memory setting controls less than many administrators assume, and that gap matters on a busy server.
Topic file / 19
SQL
Memory, growth, fill factor, indexing and the database habits that support SharePoint.
A SharePoint administrator does not need to become a database specialist, but a few SQL settings have outsized effects. These entries explain the ones worth understanding and monitoring.
3 notes in this file
SharePoint 2010 / SQL / Uncategorized
A correction on SharePoint, SQL fill factor and index rebuilds
A confident recommendation can travel further than the evidence behind it. This note is about the repair.
SharePoint 2010 / SQL
Leave SQL autogrowth enabled, but make it predictable
Turning off a safety net is not a capacity plan. A sensible growth increment and a monitoring routine are better controls.
Outside reading
Useful references
Keep the current product documentation close when applying advice from an older entry.
- Microsoft Learn: SQL Server documentation (opens in a new tab)Official reference material for database engine configuration, performance and recovery.
- Microsoft Learn: Server memory configuration (opens in a new tab)How SQL Server allocates memory and how the maximum server memory setting is applied.
- Microsoft Learn: Always On availability groups (opens in a new tab)Architecture and operational overview for SQL Server high availability groups.
- Microsoft Support (opens in a new tab)Support articles, troubleshooting steps and product help from Microsoft.
- Microsoft Learn: SharePoint documentation (opens in a new tab)The starting point for current SharePoint administration, development and hybrid guidance.
- Microsoft Learn: SharePoint administration (opens in a new tab)Operational guidance for service settings, site management and the modern admin experience.
- Microsoft Learn: SharePoint search (opens in a new tab)Documentation for search architecture, crawling and result management.
- Microsoft Learn: PowerShell documentation (opens in a new tab)Language reference, cmdlet documentation and guidance for repeatable automation.