Fast Site Collection Creation for a template,

Enable-SPWebTemplateForSiteMaster -Template “STS#0” -CompatibilityLevel 15

Run this command.

New-SPConfigurationDatabase

Go to Sharepoint Central Administration -> Application Management -> Manage service applications-> User profile Service App -> Setup my site

Edit My Site Host and Personal Site Location and input the right location.
$Web = Get-SPWeb http://[MySiteURL]/personal/[UserID]
$Web.SetProperty("urn:schemas-microsoft-com:sharepoint:portal:profile:userprofile_guid", "[NewGUID]")
$Web.Update()



User Profile Service Application -> Manage User Profiles -> Find the user profile that is having issues -> Edit User Profile

• monitoring and throttling server resources and large lists for Web applications. 
• its enables you to control resource utilization during peak usage and prevent user activity from negatively affecting server performance. 

1. General Settings Ribbon, select Resource Throttling.
2. Enter values for the List View Threshold option.
3.  This limits queries within a list to guard against performance degradation with too many list items. 
4. In SharePoint Server 2013, a list can support up to 50 million items. 

• Central Administration 
• Application Management page,>> Databases section, Select Manage content databases.
•  Manage Content Databases page, select Add a content database.
•  Add Content Database page
• select the web application to which you want to attach a content database.