Configure Resource Throttling Settings for Large Lists in SharePoint 2016

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

Read more

How to Increase the Distributed Cache Memory Size in SharePoint Server?

By default, the Distributed cache memory allocation size defaults to a value of 10% of total physical memory when SharePoint Server 2016 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 affect server performance. Also, it 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, a feature called “Throttling” was 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 number…

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 that exceeds the configured threshold limit: Larger lists in SharePoint consume more resources and performance killers. We wanted to find all larger lists and libraries in the SharePoint…

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” whenever 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 Access denied…

Read more

Set SharePoint Application Pool Recycle Time

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

Read more

SharePoint Site Collection vs Subsite – Determine Which One to Create

SharePoint newbies often get confused with this question: When to create a 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…

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