Best Practices for SQL Server in SharePoint

  • Use a dedicated server for SQL Server
  • Do not enable auto-create statistics on SharePoint content databases
  • Set max degree of parallelism (MAXDOP) to 1
  • Create DNS aliases that point to the IP address for all instances of SQL Server
  • NTFS Allocation Unit Size = 64 KB
    • format d: /FS:NTFS /Q /A:64K /Y
  • Collation = Latin1_General_CI_AS_KS_WS
  • Maximum Server Memory = 16 GB / 16,384 MB

Database Sizing

tempdb Initial Size Autogrowth
Rows Data 500 MB 500 MB
Log 125 MB 70 MB
  • Recovery model : Simple

 

model Initial Size Autogrowth
Rows Data 500 MB 500 MB
Log 125 MB 70 MB
  • Recovery model : Full
  • Auto Create Statistics : False
  • Auto Update Statistics : False

See Also

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s