SharePoint Foundation 2013 performance optimization

Here is the list of actions to perform to quickly improve the performance of your SharePoint Foundation 2013. Warning, these actions will sometimes have the effect of limiting the use of the logs and incidents.

1) Reduce WSS_Logging size by limiting the retention from 14 days to 1 day:

Paste the script below in the SharePoint Management Shell:

Set-SPUsageDefinition -Identity "Analytics Usage" -DaysRetained 1

Set-SPUsageDefinition -Identity "App Monitoring" -DaysRetained 1

Set-SPUsageDefinition -Identity "Bandwidth Monitoring" -DaysRetained 1

Set-SPUsageDefinition -Identity "Definition of usage fields for service calls" -DaysRetained 1

Set-SPUsageDefinition -Identity "File IO" -DaysRetained 1

Set-SPUsageDefinition -Identity "REST and Client API Action Usage" -DaysRetained 1

Set-SPUsageDefinition -Identity "REST and Client API Request Usage" -DaysRetained 1

Set-SPUsageDefinition -Identity "Sandbox Request Resource Measures" -DaysRetained 1

Set-SPUsageDefinition -Identity "Sandbox Requests" -DaysRetained 1

Set-SPUsageDefinition -Identity "Content Import Usage" -DaysRetained 1

Set-SPUsageDefinition -Identity "Content Export Usage" -DaysRetained 1

Set-SPUsageDefinition -Identity "Page Requests" -DaysRetained 1

Set-SPUsageDefinition -Identity "Feature Use" -DaysRetained 1

Set-SPUsageDefinition -Identity "Timer Jobs" -DaysRetained 1

Set-SPUsageDefinition -Identity "SQL Exceptions Usage" -DaysRetained 1

Set-SPUsageDefinition -Identity "SQL IO Usage" -DaysRetained 1

Set-SPUsageDefinition -Identity "SQL Latency Usage" -DaysRetained 1

Set-SPUsageDefinition -Identity "Task Use" -DaysRetained 1

Set-SPUsageDefinition -Identity "Tenant Logging" -DaysRetained 1

Set-SPUsageDefinition -Identity "App Statistics." -DaysRetained 1

Set-SPUsageDefinition -Identity "User Profile ActiveDirectory Import Usage" -DaysRetained 1

2) Reduce the Search indexation priority (NodeRunner.exe)

Paste the script below in the SharePoint Management Shell:

Set-SPEnterpriseSearchService -PerformanceLevel Reduced

3) Search Service Application optimization in Central Admin

3.1 Deactivate Search alerts status
3.2 Deactivate Query logging
3.3 Do not use Continious crawling with your Content Sources
3.4 Full Crawl during week-end
3.5 Incremental crawl at night

4) Stop IIS logging

Deactivate IIS logging for your SharePoint site

5) Deactivate all unnecessary SharePoint features

5.1 Site collection features
5.2 Site features

6) Install SP1

7) Install Cumulative updates