welcome to the donald donais minnesota sharepoint · pdf file meeting #131 welcome to the...

Meeting #131http://sharepointmn.com

Welcome to the Minnesota SharePoint

User GroupNovember 11th, 2015

Performance Troubleshooting with SharePoint Online and Office 365

Sean McDonough

Donald Donais

Meeting #131http://sharepointmn.com

User Group Goal / Objectives

Develop and support a local community focused on Microsoft SharePoint Technologies

• Educate user group members about SharePoint Technologies• Transfer knowledge within the community• Communicate best practices• Introduce new products / solutions

Meeting #131http://sharepointmn.com

MNSPUG Sponsors

Wrox Press (www.wrox.com)

O’Reilly (www.oreilly.com)

Dedicated Sponsors

Avtex (www.avtex.com)

Microsoft (www.microsoft.com)

Annual Sponsor

Sponsorships Levels:• Gold Sponsorship - $500• Silver Sponsorship - $250

SharePoint User Group Support

Atomic Data (http://www.atomicdata.com)

Meeting #131http://sharepointmn.com

Today’s Lunch SponsorProducts Include: • Nintex Workflow Office 365• Nintex Forms Office 365• Nintex Workflow SharePoint• Nintex Forms SharePoint• Nintex Enterprise Forms & Mobile• Nintex Workflow Project Server• Nintex Live• Nintex Mobile

Session begins around 11:50 and runs about one hour.

Meeting #131http://sharepointmn.com

MN SharePoint Users Group Website

• SharePoint Resource Documents• SharePoint Resource links• RSS Feeds • Meeting Schedule• Past User Group Presentations• Past User Group Recordings• Sponsorship Information

• http://sharepointmn.com• Email: sharepoint@sharepointmn.com

Meeting #131http://sharepointmn.com

Social Networking

• Linked In group – The most interactive… includes job postings… Post Job Posting on the Jobs Discussion page

http://www.linkedin.com/groups?gid=1878792

• Twitter tags - @MNSPUG and #MNSPUG

• Yammer – Minnesota SharePoint Users Group https://www.yammer.com/mnspug/

Meeting #131http://sharepointmn.com

Upcoming Schedule

• Next Meeting December 9th, 2015 – Ask the Experts Panel Discussion Microsoft Technology Center, Edina, MN Check www.SharePointMN.com for updates!

• Ongoing Schedule 2nd Wednesday of every month 9:00 to 11:30 am Microsoft Technical Center – Edina

Meeting #131http://sharepointmn.com

Local and Online EventsMN Women in SharePoint – November 17th, 2015. Avtex Headquarters, Bloomington, MN – Bridging the Confidence GapDr Carolien Moors, founder of HardTalk Biz CoachingEvent Registration -http://www.avtex.com/events/november%20mnwisp%20meeting?_cldee=YWxleGlzamJlbGxAZ21haWwuY29t

MN SharePint – December 1st, 2015 at Joe Senser’s, Bloomington, MNhttp://www.meetup.com/Minnesota-SharePoint-SharePint/events/226594892

• Azure Active Directory• Office 365 (Exchange Online, SharePoint

Online, and Skype for Business)

• Azure Active Directory• Office 365 (Exchange Online)• Dynamics CRM Online

• Azure Active Directory• Dynamics CRM Online

• Azure Active Directory• Office 365 (Exchange Online, SharePoint

Online, and Skype for Business)• Dynamics CRM Online

• Azure Active Directory

1. The workstation contacts an internal DNS server to ask for the appropriate IP address.

2. If the internal DNS server doesn’t have the IP address for the hostname cached, it passes the lookup up-the-chain to Microsoft’s DNS server.

3. Microsoft’s DNS server responds with the IP address the client workstation needs.

1. Armed with the appropriate IP address, the client workstation issues an HTTP request to the SharePoint Online Server. That request travels the local network to the firewall or gateway.

2. In common scenarios, the firewall performs network address translation (NAT) to pass the internal client request on to the public Microsoft network entry point.

3. Within the Microsoft network, the request makes its way to the SharePoint Online servers for the client’s tenant.

4. An SPO front-end serves up the request.

1. Rather than going directly to a firewall or gateway, the client’s request goes to a web proxy.

2. The web proxy makes the actual outbound request.

3. In common scenarios, the firewall performs network address translation (NAT) to pass the proxy’s call through.

4. Within the Microsoft network, the request makes its way to the SharePoint Online servers for the client’s tenant.

5. An SPO front-end serves up the request.

6. The web proxy passes the response back to the client.

• HTTPS page requests• List/library uploads and downloads

• Do requests traverse a firewall? In all likelihood, the answer is “yes.”

• Is a proxy server part of the request path/sequence?

• What else sits on the internal network between client workstations and the Internet?

your RTT value (or values) in the context of your

• With a straight connection in-region, sub-100ms times are the norm.

• If you are part of a global organization with centralized egress out-of-region, RTT to your proxy may be high.

• Subtract RTT-to-proxy from RTT-to-SPO; the result is your RTT from proxy to SPO

• MSS (MaxSegmentSize) should be near the max of 1460 and not much lower.

• SACK (selective acknowledgement) should be enabled to handle dropped packets efficiently.

• Minify files, especially JavaScript files.• Resize images to usage sizes and compressing

them more aggressively.• Use sprite sheets to reduce the actual number of

HTTP requests needed to retrieve images.• Use SharePoint’s Image Rendition service.• Leverage a toolkit like Font Awesome in place of

individual icons and similar files.

$().SPServices.SPGetCurrentUser

• Instead, use the available REST and CSOM endpoints to retrieve this information.

http://SharePointInterface.com

http://about.me/spmcdonough

sean@sharepointinterface.com

1. SPTechCon Austin 2016http://www.sptechcon.com/

2. “Technical diagrams for SharePoint 2013”https://technet.microsoft.com/en-us/library/cc263199.aspx

3. “Deploying Office 365”http://video.ch9.ms/sessions/project/2014/PC215_Medford.pptx

4. “Office 365 Performance Management”https://mva.microsoft.com/en-US/training-courses/office-365-performance-management-8416

5. “Office 365 network traffic management”https://support.office.com/en-us/article/Office-365-network-traffic-management-e1da26c6-2d39-4379-af6f-4da213218408

6. “Where is my data?”https://www.microsoft.com/online/legal/v2/en-us/MOS_PTC_Geo_Boundaries.htm

7. “New datacenter regions for Office 365”https://msdn.microsoft.com/en-us/library/dn878163.aspx

8. “Network and migration planning for Office 365”https://support.office.com/en-us/article/Network-and-migration-planning-for-Office-365-f5ee6c33-bcd7-4b0b-b0f8-dc1d9fb8d132?ui=en-US&rs=en-US&ad=US#calculators

9. SysInternals PSPinghttps://live.sysinternals.com/psping.exe

10. TraceTCP on Githubhttp://simulatedsimian.github.io/tracetcp.html

11. WinPcap download (required for TraceTCP)https://www.winpcap.org/install/

12. “Preventing proxy authentication from delaying your O365 connection”http://blogs.technet.com/b/onthewire/archive/2014/06/16/preventing-proxy-authentication-from-delaying-your-o365-connection.aspx

13. Fiddler web debugging proxyhttp://www.telerik.com/fiddler

14. “FAQ – Certificates in Fiddler”http://www.telerik.com/blogs/faq---certificates-in-fiddler

15. “Analyzing your webpage’s network traffic”https://msdn.microsoft.com/en-us/library/dn255004(v=vs.85).aspx

16. “Diagnosing performance issues with SharePoint Online”https://msdn.microsoft.com/en-us/library/dn879455.aspx

17. “Image optimization for SharePoint Online”https://support.office.com/en-gb/article/Image-optimization-for-SharePoint-Online-c7edb02a-fdab-4f91-9a20-cba01dad28ef

18. Font Awesomehttps://fortawesome.github.io/Font-Awesome/

19. “How to improve your website performance with a CDN”http://b2evolution.net/web-hosting/blog/tips/improve-website-performance-with-cdn

20. “Navigation options for SharePoint Online”https://msdn.microsoft.com/en-us/library/dn850367.aspx

21. “Using Content Search Web Part instead of Content Query Web Part to improve performance in SharePoint Online”https://msdn.microsoft.com/en-us/library/dn878991.aspx

22. “Using jQuery Promises & Deferreds with SharePoint 2013”http://blog.qumsieh.ca/2013/10/31/using-jquery-promises-deferreds-with-sharepoint-2013-jsom/

23. “Lazy Load Plugin for jQuery”https://github.com/tuupola/jquery_lazyload

24. “Documentation > $().SPServices.SPGetCurrentUser”http://spservices.codeplex.com/wikipage?title=%24%28%29.SPServices.SPGetCurrentUser

25. “SPServices Example: UserProfileService.GetUserProfileByName”http://sympmarc.com/2012/02/15/spservices-example-userprofileservice-getuserprofilebyname/

26. “get current user info using jquery, REST and csom”http://sharepoint.stackexchange.com/questions/124909/get-current-user-info-using-jquery-rest-and-csom

27. “Users, groups and the roles REST API reference”https://msdn.microsoft.com/en-us/library/office/dn531432.aspx#bk_User

Meeting #131http://sharepointmn.com

Evaluations & Giveaways!