Sometimes one w3wp process will take more cpu utilization and wa can’t access that site

Sometimes one w3wp process will take more cpu utilization and wa can’t access that site.

That time just get the info of all process running on it and get their utilization by looking inti task manager. Select processes from all users in the left corner. Now it will listout which w3wp is taking high utilization. Now we need to find out that w3wp is related to which app pool and need to recycle that app pool in IIS.

By using that find which app pool is related to which w3wp.exe

Go to c: windows/system32/inetsrv/ .\appcmd list wp

This will list out app pools with PID in processes

Find out high usage app pool and recycle it in IIS.

Issue was solved.

Items are being deleted from the index and are not retrievable from the main default.aspx page search bar

Issue Definition:

-------------------------

1)      Users are unable to retrieve items from the index they could previously.

2)      Items are being deleted from the index and are not retrievable from the main default.aspx page search bar.

RESOLUTION:

-----------------------------------------------------

As part of troubleshooting, I did following steps.

1)      We run psconfig.exe on application server.

2)      Need to check Disable loopback check is setup or not on server. Went to registry and found that it is already there.

3)      Specify host names: To specify the host names that are mapped to the loopback address and can connect to Web sites. This method would be preferred for NTLM authentications.

· Click Start, click Run, type regedit, and then click OK.
· In Registry Editor, locate and then click the following registry key:
· HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0
· Right-click MSV1_0, point to New, and then click Multi-String Value.
· Type BackConnectionHostNames, and then press ENTER.
· Right-click BackConnectionHostNames, and then click Modify.
· In the Value data box, type the host name or the host names for the sites that are on the local computer, and then click OK.
· Quit Registry Editor, and then restart the IISAdmin Service

In the above step, I specified all host names and tried to start crawling. No use.

2)            In technet blog, I found that if any patches effected on SharePoint services, we need to recreate and enter value for disablleloopback check in registry entry.

3)            Mentioned admin account for Search Service application administrators in central admin.

4)            Administrators for user profiles service application:  Here we will mention users who will be able to manage settings related to UPS and search content. Checked admin account rights for UPS and found admin account is not having Retrieve people data for search crawlers. Checked that permissions for admin account.

Permanently Delete a SharePoint Site Collection

#Permanently Delete a SharePoint Site Collection.

#To begin, you will need to load the SharePoint Online module to be able to run commands in PowerShell. You must also replace the url "https://anjantech-admin.sharepoint.com" and use your SharePoint administrative site.

Import-Module Microsoft.Online.Sharepoint.PowerShell

$credential = Get-credential
Connect-SPOService -url https://anjantech-admin.sharepoint.com -Credential $credential

#This command will delete the SharePoint site collection. You must replace the url "https://anjantech.sharepoint.com/sites/SiteCollectionName" with your Sharepoint Online URL and use the Site Collection Name that is to be deleted for this script to work properly.

Remove-SPOSite -Identity https://anjantech.sharepoint.com/sites/SiteCollectionName -NoWait

#This command will pause the script for 20 seconds before proceeding.
Start-Sleep -s 20

#This script will permanently delete the SharePoint site collection after it is sent to the SharePoint Site Recycle Bin. You must replace the url “https://anjantech.sharepoint.com/sites/SiteCollectionName” with your Sharepoint Online URL and use your Site Collection Name that is to be permanently deleted for this script to work properly.

Remove-SPODeletedSite -Identity https://anjantech.sharepoint.com/sites/SiteCollectionName

Delete Site Collection with Sub Sites

#Deleting a SharePoint Site Collection and its Subsites

#To begin, you will need to load the SharePoint Online module to be able to run commands in PowerShell. You must also replace the url "https://anjantech-admin.sharepoint.com" and use your SharePoint administrative site.

Import-Module Microsoft.Online.Sharepoint.PowerShell
$credential = Get-credential
Connect-SPOService -url https://anjantech-admin.sharepoint.com -Credential $credential

#This command will delete the SharePoint site collection. You must replace the url "https://anjantech.sharepoint.com/sites/SiteCollectionName" with your Sharepoint Online URL and use the Site Collection Name that is to be deleted for this script to work properly.

Remove-SPOSite -Identity https://anjantech.sharepoint.com/sites/SiteCollectionName -NoWait

Connect with SharePoint Online using SP Online Management Shell

Install the SharePoint Online Management Shell by downloading and running the https://www.microsoft.com/en-us/download/details.aspx?id=35588 or installing module from the PowerShell Gallery   https://www.powershellgallery.com/packages/Microsoft.Online.SharePoint.PowerShell/16.0.19223.12000



If your operating system is using PowerShell 5 or newer, you can install Sharepoint Online Management Shell also by running following command in administrative mode.

Install-Module -Name Microsoft.Online.SharePoint.PowerShell

To open the SharePoint Online Management Shell command prompt, from the Start screen, type sharepoint, and then click SharePoint Online Management Shell.

To connect with a user name and password

Fill in the values for the $adminUPN and $orgName variables (replacing all the text between the quotes, including the < and > characters), and then run the following commands at the SharePoint Online Management Shell command prompt:

$adminUPN="<the full email address of a SharePoint administrator account, example: anjan@anjantech.com>" $orgName="<name of your Office 365 organization, example: anjantech>" $userCredential = Get-Credential -UserName $adminUPN -Message "Type the password." Connect-SPOService -Url https://$anjantech-admin.sharepoint.com -Credential $userCredential

The site requires that the feature {.......} to be activated in site collection.

Get-spfeature –identity ca7bd552-10b1-4563-85b9-5ed1d39c962a –url "http://site collection url " –force

It will activate the feature of that particular GUID

Then need to enable ctypes feature also

Enable-spfeature –identity ctypes –url "http://site collection url " -force

SharePoint Online limits (Threshold Limits)

SharePoint Online limits

Applies To: SharePoint Online SharePoint Online Small Business

This article describes SharePoint Online limits that apply to all plans. For storage and user limits for current Office 365 plans and SharePoint Online standalone plans, see the SharePoint Online service description. For storage and user limits for previous Office 365 mid-size and small business plans, see Limits for Office 365 plans for small and mid-size businesses later in this article.

NOTES: 

·         SharePoint trial plans and Online Preview sites aren't covered here.

·         For SharePoint 2016 limits, see SharePoint 2016 software boundaries and limits. For SharePoint 2013 limits, see SharePoint 2013 software boundaries and limits.

·         For information about mailbox storage limits in Exchange Online, see Exchange Online Limits.

Service limits

·         Items and files - A list can have up to 30 million items and a library can have up to 30 million files and folders. Views can have up to 12 lookup columns. To learn more about other restrictions for viewing large lists, see Manage large lists and libraries in Office 365. A file's entire path, including its name, must be fewer than 400 characters. For information about characters that can't be used in file names, see Invalid characters in file and folder names. For information about blocked file name extensions, see Types of files that cannot be added to a list or library

·         Subsites - Up to 2,000 per site collection

·         File size - Less than 15 GB per file. Files attached to list items can be up to 250 MB in size.

·         Sync - For optimum performance, we recommend storing no more than 100,000 files in a single OneDrive or team site library. If you use the previous OneDrive for Business sync client (Groove.exe), the sync limit per library is 5,000 items.

·         Versions - 5,000 major versions and 511 minor versions

·         SharePoint groups - A user can belong to 5,000 groups, and each group can have up to 5,000 users. You can have up to 10,000 groups per site collection.

·         Users - 2 million per site collection.

NOTE: There is no limit to the number of external users you can invite to your SharePoint Online site collections. For more information, see Manage external sharing for your SharePoint Online environment.

Limits for Office 365 plans for small and mid-size businesses

These plans are no longer available for purchase. See Switch to a different Office 365 plan or subscription for instructions on how to update your plan to one of the new plans.

Feature	Office 365 Mid-size Business	Office 365 Small Business and Small Business Premium
Storage NOTE: We recommend monitoring the Recycle Bin and emptying it regularly. The storage space it uses is part of the organization's total file storage limit.	1 TB per organization plus 0.5 GB per subscribed user. You can purchase additional storage up to a maximum of 20 TB. To buy storage, see Change storage space for your subscription.	1 TB per organization.
Storage for site collections and Office 365 Groups	Up to 1 TB per site collection or group.	1 TB
Site collections and Office 365 groups	20 per organization (not including a OneDrive for each licensed user).	1 per organization (not including a OneDrive for each licensed user).
Number of users	1 - 250	1 - 25

Additional Resources

For information about this:	Go here:
Office 365 connectivity limits	To learn more about Internet bandwidth, port and protocol considerations for Office 365 plans, see Office 365 Ports and Protocols.
SharePoint feature availability	To learn more about SharePoint feature availability and the SharePoint Online service in Office 365, see SharePoint Online Service Description.
SharePoint Online search limits	To learn more about the search limits for SharePoint Online, see Search limits for SharePoint Online.
OneDrive for Business restrictions and limits	To learn more about restrictions and limits when using the new OneDrive sync client (OneDrive.exe), see Restrictions and limitations when you sync files and folders. To learn more about restrictions and limits when using the previous OneDrive for Business sync client (Groove.exe), see Restrictions and limitations when you sync SharePoint libraries to your computer through OneDrive for Business. To determine which sync client you're using, see Which OneDrive sync client am I using?
File types	To learn about file types that can't be added to a list, see Types of files that cannot be added to a list or library.
Online URLs	To learn about SharePoint Online addresses, see SharePoint Online URLs and IP Addresses.
Site languages	To learn how to set language for your sites, see Change your language and region settings.
Planning and deploying SharePoint Online	SharePoint Online Planning Guide for Office 365 for business.
Adding or reducing storage	Change storage space for your subscription.

Reference : Microsoft (https://support.office.com/en-us/article/SharePoint-Online-limits-8f34ff47-b749-408b-abc0-b605e1f6d498)