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’ »

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’ »

SharePoint listing all documents with versioning detail

Document library in SharePoint shows count of the documents only, but there are many minor and major versions for a document. In this blog post I am going to share how we can generate a report for a document library which have details for all major and minor versions of document version size and checkedIn …

Continue reading ‘SharePoint listing all documents with versioning detail’ »

SharePoint Storage Metrics to Check size of a document Library

SharePoint storage gives us a very useful report to understand the size of a site, sub site, list and library. To view the Storage Metrics report you have to follow simple steps Go to Site Collection Settings –> Site Collection Administration –> Storage Metrics You can drill down the document library or sub site to …

Continue reading ‘SharePoint Storage Metrics to Check size of a document Library’ »