Configure Resource Throttling Settings for Large Lists in SharePoint 2016

What is resource throttling in SharePoint? The biggest performance bottleneck in SharePoint sites is caused usually by large lists. If you have 50 simultaneous users on a site and two of them are contributing to large lists, all 50 users will experience very slow performance. Luckily starting from SharePoint 2010, There is…

Read more

How to Increase Distributed Cache Memory Size in SharePoint 2013?

By default, the Distributed cache memory allocation size defaults to a value of 10% of total physical memory when SharePoint Server 2013 installs. The Distributed Cache service uses half of that memory allocation for data storage (also known as cache size, 5% cache size). You can change the memory allocation as it…

Read more

SharePoint Group vs Active Directory Group – Which is Best?

So you need to determine the best way to manage SharePoint users, Whether to use SharePoint groups or Active Directory groups to manage permissions in SharePoint? Well, Both SharePoint Group and AD Group have their own advantages and disadvantages. Let me list down some of them: Manageability: Any SharePoint site owner/admin can…

Read more

Change Log Files Location for ULS, Usage and Health Data Collection

No doubts, diagnostic logs and “Usage and health data” logs are extremely helpful. However, it could cause performance issues and slow down SharePoint if not managed properly. These logs can use large amounts of drive space and can affect server performance. Also, can quickly fill the system disk which could potentially bring…

Read more

Configure Resource Throttling in SharePoint 2013 using PowerShell

What is Resource throttling?Large lists are always performance killers in SharePoint. Luckily starting from SharePoint 2010, There is a feature called “Throttling” introduced to address this issue.  Any operation such as data retrieval, update, delete of more than 2000 rows results in low performance in SharePoint 2007 days. Throttling defines the Maximum…

Read more

Find All Large Lists Exceeding Threshold Limit in SharePoint using PowerShell

Requirement: Find all lists exceeding the list view threshold limit configured on Web Application’s resource throttling settings. PowerShell Script to find all Large Lists which are exceeding the configured threshold limit: This script generates a CSV file at “C:\LargeListData.CSV”, Just open it in Microsoft Excel, apply some formatting and here is how…

Read more

Disable UAC in Windows Server 2012 – SharePoint Best Practice

In SharePoint 2013 farms on Windows Server 2012, it is annoying that we’ve to choose “Run as Administrator” every time when opening Central Administration, Command Prompt, SharePoint Management Shell, Windows PowerShell, etc. and failing so would introduce some weird issues such as buttons and links missing in SharePoint Central Admin ribbon, Getting…

Read more

Set SharePoint Application Pool Recycle Time

By design application pools in IIS are restarted once per every 29 hours to provide best performance and stability. The very first user access SharePoint after app pool recycle will experience considerable delay, as .net assemblies needs to be recompiled to the memory. So, we use Warm-up scripts for SharePoint 2013 to…

Read more

SharePoint Site Collection vs Subsite – Determine Which One to Create

SharePoint newbies often get confused with this question: When to create Site collection and when to use Subsites? What are the advantages of having a Ste collection rather subsite? Well, the choice of Site collection or subsite can be determined based on these factors: Security/Permission Management – Every Site collection uses unique…

Read more

Increase Maximum Size of Site Template, List Templates in SharePoint

In SharePoint 2007, You can’t save a list or site template (.stp ) file which is bigger than 10MB. MOSS 2007 gives an error message: “The list is too large to save as a template. The size of a template cannot exceed 10485760 bytes.” When you try to save a list or…

Read more