SharePoint Server 2016: Configure State Service

In previous blog posts, I shared detail on Installation and configuration of SharePoint 2016 and also for WFEs. In this blog I am sharing the details on how to manually provision State Service Application using PowerShell. Provision the SharePoint State service application in order to name the database according to the preferred naming convention.

  Useful links: SharePoint Farm User Accounts …

Continue reading ‘SharePoint Server 2016: Configure State Service’ »

SharePoint Server 2016: Add a web front end with distributed cache

Please follow the previous blog post to install SharePoint (SharePoint Server 2016 Installation Step by step) and running Configuration Wizard on Application server. Login to the Web Front end server(s). You are now ready to run the SharePoint 2016 Products Configuration Wizard located on the Windows Start menu. Follow these steps to create a farm: …

Continue reading ‘SharePoint Server 2016: Add a web front end with distributed cache’ »

SharePoint 2016: Products Configuration Wizard

After Installation of SharePoint on all application and web front end servers as mentioned in SharePoint Server 2016 Installation Step by step, you need to stat the configuration wizard to create a new farm. You are now ready to run the SharePoint 2016 Products Configuration Wizard located on the Windows Start menu. Follow these steps …

Continue reading ‘SharePoint 2016: Products Configuration Wizard’ »

SharePoint Server 2016 Installation Step by step

In this blog post I will share the details on creation of Multi server SharePoint Farm which include the Application server and Web Front End servers. I prepared this post in a way that you can create single server to multi server SharePoint farm and can create Dev, QA or Production environment for SharePoint server …

Continue reading ‘SharePoint Server 2016 Installation Step by step’ »

SharePoint Performance Issue- Set Memory Limits on SQL Server

By default, SQL Server is set to use max 2TB of RAM. You might not be having 2TB RAM in your environment, you might have 8GB, 16GB or more depending on your farm and SharePoint installation. Here is a formula to determine memory size for all instances of SQL Server. SQL Max Memory= TotalPhysicalMemory – …

Continue reading ‘SharePoint Performance Issue- Set Memory Limits on SQL Server’ »

Hostname Alias for SQL Server Instance

A Hostname alias SQL Server instance is a simple Hostname that allows clients to connect to an instance of SQL Server without specifying an instance name or a port number. They are very useful for upgrades, server migration, consolidation and disaster recovery. A network alias can redirect clients from one server to another. This is …

Continue reading ‘Hostname Alias for SQL Server Instance’ »

Best Practice: SQL Server settings before deploying SharePoint Server 2016

Do not enable auto-create statistics on a server that hosts SQL Server and SharePoint Server. Enabling auto-create statistics is not supported for SharePoint Server. SharePoint Server configures the required settings during provisioning and upgrade. Manually enabling auto-create statistics on a SharePoint database can significantly change the execution plan of a query. We recommend updating the …

Continue reading ‘Best Practice: SQL Server settings before deploying SharePoint Server 2016’ »

SQL Server 2012/R2/2014/2016 Installation Step by Step

In this blog post I will be sharing step by step installation detail for SQL Server with Best Practice for SharePoint. SQL Software requirements 64-bit edition of Microsoft SQL Server 2012 R2 or SQL Server 2014/16 Standard (Enterprise required for Always On) Named SQL alias recommended. Windows Server 2012/R2/2014/16 with latest patch levels should be …

Continue reading ‘SQL Server 2012/R2/2014/2016 Installation Step by Step’ »

Add .NET Windows Server Feature on Windows Server

When you are going to setup for a new SharePoint Farm, you need to install .Net windows feature on all servers (SQL and SharePoint). Follow the below steps to add .net Windows feature windows server. To add the .NET Windows Server feature, click on Start > All Programs > Administrative Tools > Server Manager. From …

Continue reading ‘Add .NET Windows Server Feature on Windows Server’ »

SharePoint Farm User Accounts

When you are going to deploy a SharePoint Farm, you need a set of user accounts with proper roles and permissions, in this blog post I am going to share the list of recommended user accounts required for a SharePoint 2016 Farm with their roles. I will share the installation details in later blog posts. …

Continue reading ‘SharePoint Farm User Accounts’ »