Tag: SharePoint 2016

How to fix “The local farm is not accessible.” error

the-local-farm-is-not-accessible

Add-SPShellAdmin -UserName CONTOSO\joeylicc

See Also

 

Advertisements

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

 

SharePoint 2016 System Requirements

Install SharePoint 2016 (Single Server Farm)

Hardware Requirements
  • Pilot, user acceptance test (Including Development or evaluation installation)
  • RAM : 16-24 GB
  • Processor : 64-bit, 4 cores
  • Hard disk : 80 GB for system drive; 100 GB for additional drives
Software Requirements
  • Prerequisite : Windows Server 2012 R2 update : April 2014
  • 64-bit edition of Microsoft SQL Server 2014 Service Pack 1 (SP1)
    • SQL Server Express is not supported
  • 64-bit edition of Windows Server 2012 R2 Standard or Datacenter

See Also

 

What’s new in SharePoint 2016

  • Hybrid
    • OneDrive Redirection
    • Sites you follow in one place
    • Hybrid Cloud Search
    • App Launcher and UI Changes
  • Infrastructure and Performance Improvements
    • MinRoles
      • Multi-Server Farm
        1. Front-end
        2. Application
        3. Distributed Cache
        4. Search
        5. Custom
      • Single-Server Farm
    • Zero Downtime Patching
    • Removed 5000 View Threshold – Sort of
    • Increased File Size for Uploads
    • Fast Site Creation
  • New Compliance Center
  • New Collaboration Experience
    • Durable Links
    • Site Folders

See Also