Friends, it would be of great deal and help if we had an overall description of ‘what has occurred’ during determining the factors of down SharePoint
performance. Below I am listing some of the key point which had clicked to my mind.
1- Is issue present on all content databases and sites in a web application?
- If one site is having issues check the URL for the content database the site resides. – This can help determine if the issue is site specific or larger.
- If the content database URL has issues then check other Content databases in the same web application.
- If the web application is having issues validate other web applications in the same method.
- Compare web applications from each SQL server
, this can help determine if there is a SQL issue.
2- Is the issue present on all WFE's?
- Test from the WFE’s and from a desktop – This can help locate any issues with Network or Load Balancer
- Check WFE events, ULS
, IIS, performance monitor
- Do WFE’s have high CPU?
- Is High CPU on one process/web application
- Capture all processes organized by CPU utilization
- Determine what web application is related to process as necessary
3- IS SQL performing well?
- Have the correct Teams such as SA and DBA to validate Wintel Server or SQL for any issues.
4- Involvement of all internal teams should be required and record everything for easily sharing and record.
5- When involving Microsoft share all event logs, IIS logs, ULS logs, and performance monitor logs captured with them.
A SharePoint performance troubleshooting guide from Idera would also help you to determining the factors to be considered during troubleshooting down SharePoint performance.