1 / 48

Performance and Capacity Management

Performance and Capacity Management. Nicolas Ménigon , SQLi et Dung T. Thoi, Microsoft Suisse. The Challenge SharePoint 2010 Performance Improvements The Capacity Management approach in 2010 Capacity Guidance. Agenda. SharePoint 2010 Performance Improvements.

varick
Télécharger la présentation

Performance and Capacity Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Performance and Capacity Management Nicolas Ménigon, SQLi et Dung T. Thoi, Microsoft Suisse

  2. The Challenge SharePoint 2010 Performance Improvements The Capacity Management approach in 2010 Capacity Guidance Agenda

  3. SharePoint 2010 Performance Improvements Nicolas Ménigonnmenigon@sqli.com

  4. SQLI en bref : 20 ans d’expérience, 20 agences dans le monde, 2000 collaborateurs SQLI Suisse : 10 ans d’expérience, une 100ne de collaborateurs, 2 agences (Genève et Lausanne) SQLI et Microsoft Microsoft Gold Partner L’offre : Consulting & Expertise Réalisation (projets forfait / assistance technique / TMA / Centre de services in shore - Near Shore) Formation et Accompagnement (AMOA, AMOE) L’expertise technologique : Plateformes : SharePoint 2007 et 2010, SQL Serveur, Biztalk .Net : Architecture, Industrialisation (TFS/VSTS), frameworket langages, RIA/RDA (Silverlight, WPF) & Multitouch Les PLUS : Centre formation (CPLS / SDPS) certifié Microsoft : SQLI Institut Web Agency intégrée SQLI en quelques mots

  5. The Challenge

  6. SharePoint 2007 SharePoint Server Client Apps Shared Service Provider Project Server 2007 Project Server 2007 Browsers (IE) InfoPath Service Search Service Project Web Access Office Client Project Web Access OneNote Excel Calc Service InfoPath User Profiles Project Business Data Catalog Outlook RSS Viewers Windows SharePoint Services Groove Config Content Workflow SharePoint Designer

  7. More, More, More… How is SharePoint 2010 Different

  8. 2010 SharePoint 2007 SharePoint Server Client Apps Shared Service Provider Project Server 2007 Project Server 2007 Browsers (IE) InfoPath Service Search Service Search Service Project Web Access Office Client Project Web Access Excel Calc Service OneNote Excel Calc Service User Profiles InfoPath User Profiles Business Data Catalog Project Business Data Catalog Outlook RSS Viewers Windows SharePoint Services Groove Config Content Workflow Config Content Workflow SharePoint Designer

  9. SharePoint 2010 SharePoint Server Client Apps SharePoint Service Applications Shared Service Provider Project Server 2010 Browsers (IE) 2007 Search Service Project Web Access Office Client Excel Calc Service OneNote User Profiles InfoPath Business Data Catalog Business Connection Service Project Outlook RSS Viewers SharePoint Foundation Windows SharePoint Services SharePoint Workspace Groove Config Content Workflow SharePoint Designer

  10. SharePoint 2010 SharePoint Server Client Apps SharePoint Service Applications Project Server 2010 Browsers (IE, Fire Fox) Browsers (IE, Fire Fox) Browsers (IE) Search Service PowerPoint Broadcast Service Project Web Access Office Client Office Client Office Client Excel Calc Service Web Analytics Service OneNote OneNote OneNote FAST 2010 Office Web App Service 3rd Party Services.. FAST Search Service User Profiles Visio Graphics Service InfoPath InfoPath InfoPath Business Connection Service Access Service Project Project Project InfoPath Service Managed Metadata Outlook Outlook Outlook Word Conversion Service PerformancePoint RSS Viewers RSS Viewers RSS Viewers SharePoint Workspace SharePoint Workspace SharePoint Foundation Sandboxed Code Service Usage & Health Logging SharePoint Workspace SharePoint Designer SharePoint Designer Visio Config Content Workflow SharePoint Designer Access

  11. SharePoint 2010 is Scalable and Flexible

  12. WFE and App Servers have more work SQL Servers have more work The Client Browser has more work SharePoint 2010 Perf Challenge

  13. SharePoint 2010 Performance Improvements

  14. PerformanceTerminology End User Perceived Latency Throughputand Scale Out Capacity and Data Scale Reliability

  15. Lighter and faster Pages Early Rendering WAN Optimized Better First and Second Browse (PLT1 and PLT2) Focused on Popular Scenarios IE8 and similar new browser are better for WAN Dependent on Content and Customizations Latency Improvements

  16. Incremental File Open/Save New protocol (Cobalt) Save is done in the background File Open Save Latency Investments Goodbye WFE & App Servers SQL

  17. Enabling new deployment scenarios in 2010Examples: 100 Million Items per Search Index (1 Billion with Fast 2010) Tens of Millions of Documents/Items in a single List View/Query 5000 items at a time Many recommendations/limits stay the same Site Collections per WebApp (150,000) Site Collections per Content DB (50,000) Content DB Size (100 GB) Data Scale Improvements • The Product has its limits! • Caution: • Plan & Prototype & Measure ahead of time • Don’t hit all limits simultaneously

  18. Site Collection/Content DB Size Considerations 100 GB and beyond… Content DB Size 1 TB • Repository / Archive • Challenges: • Fast Storage for performance • Backup & Restore • Upgrade • Team Collab • Frequent Writes 100 GB Read/Write Mix Write Intensive Mostly Read

  19. Optimized Key Scenarios – reducing transaction cost Optimized SQL to sustain higher load Added Protection to sustain a stable deployment Throughput & Reliability Improvements WFE & App Servers SQL

  20. Large List Throttling Throttling Excessive Client Load New built in protection against latency spikes and unplanned downtimes

  21. Large List Throttling Demo

  22. The Server informs Clients on it health condition The 2010 Clients Tune down the sync frequency (Backoff) when server is in stress/overloaded The Server starts throttles “low-priority” requests if health drops below thresholds, and becomes more aggressive just before going down Throttling Excessive Client Load 1 2 503! Before Clients Backoff After Clients Backoff

  23. Capacity Management in 2010 Dung T. Thoi tdthoi@microsoft.com Microsoft Suisse

  24. SharePoint 2007 Cap Planning Study, Experiment and Model Pilot +Deploy • Stabilize Proper Sizing • Model Over Sizing Under Sizing $$$$ 2 1

  25. SharePoint 2010 Cap Management Study, Experiment and Model Pilot +Deploy Over Sizing Under Sizing $$$$ • Design • Model • Pilot, Test and Optimize *Load Test Kit 2010*SPDiag 2010 *SPDiag 2010 • Analysis and Maintain • Deploy * These tools will ship as part of the SharePoint Administration Tool Kit

  26. The Logging DB The Dev Dashboard Monitoring in SharePoint 2010

  27. SharePoint 2010 logs everything it does into the ‘Logging Database’ Enabled by default on all deployments Customizable retention policy Schema is documented You can read, query and build reports directly from the Logging DB 3rd party apps can write their data to the Logging DB In SharePoint Server 2010, Web Analytics processes and uses this data for advanced reports Logging Database

  28. Capacity Guidance

  29. Capacity Planning Tech Center - Table of Content Planning Capacity Planning 101 Plan for software boundaries Recommendations Topology recommendations Hardware recommendations Data Storage recommendations Guidance per workload Case Study documentation Employee Portal, Company Portal, Team Collaboration, Social Networking, Document Management, Search… Partners/Third party Case Studies - (Intel, HP, EMC…) Capacity Management Tools SharePoint 2010 Load Test Kit SPDiag 2010 Troubleshooting SharePoint 2010 Performance Monitor and troubleshooting SharePoint Scalability Related Content SQL capacity planning guidance links... SharePoint 2010 "Capacity Planning Book"

  30. Capacity Planning 101: Chapter I: Overview Your Star A universe of SharePoint Deployments No Cookbook

  31. Standard Architectures Schematic Diagram, not to be use as a recommendation for Server Counts • Limited deployments • minimum services • up to 5000 users (~5 RPS) • 50-100 GB of data WFE & App Servers • Demos and Dev Boxes SQL Single Server Small Farm

  32. Standard Architectures Schematic Diagram, not to be use as a recommendation for Server Counts b • Large Enterprise • Up to 500k users (~500 RPS) • 10-20 TB of data • WFE • Federated • Services App Servers • Common Enterprises • 10-50k users (~50 RPS) • 1-2 TB of data • WFE SQL App Servers • Limited deployments • minimum services • up to 5000 users (~5 RPS) • 50-100 GB of data SQL WFE & App Servers • Demos and Dev Boxes SQL Medium Farm Single Server Small Farm Large Farm

  33. What Differentiates SharePoint Deployments? • Hardware, Setting and Topology • Facts: # of servers, HW spec, rolesTuning Options: Add WFE or App Server, tune settings Your Star . • Dataset • Facts: #of Site collections, DBs, Web Apps, Data SizeTuning Options: Split Site Collections, Balance Content DBs • Workload • Facts: purpose, services, # of Total users, concurrency, RPSTuning Options: Split farms, disable services, block clients • Health And Performance Score • Availability, Latency, Throughput, Responsiveness, Failure Rate… 8

  34. Medium Farm: Logical Architecture

  35. Medium Farm: Physical Topology

  36. Model: Understand your 2007 facts - Workload and Dataset, Targets Design: Study the guidance on how your facts might change in 2010 Pick initial Architecture - Hardware, Settings and Topology Pilot, Test and Optimize Load Test your 2010 farm, and analyze the Performance Tune the Hardware, Settings and Topology Split to multiple Farms if needed Deploy Implement in the data center and migrate users and content over Monitor Track your deployment periodically, troubleshoot Identify the bottlenecks and pain points, go to step 1. Capacity Planning 101:Chapter II: Capacity Management Steps

  37. Boundaries Types Hard limits enforced by system such as 2GB files Configurable Boundariessuch as 5000 items in a query Non-limited Boundaries- dependent on HW and configurations Rules of Thumb 1 WFE for 10-20k users Enabling 2010 features will require more power! (x1.5 to x2) Dedicate SQL power to Logging DB, Web Analytics, Project Server WFE and Apps Servers – starting at quad processor, 8 GB RAM SQL - starting at quad processor, 16 GB RAM … SharePoint 2010 Software Boundaries • The Product has its limits! • Caution: • Plan & Prototype & Measure ahead of time • Don’t hit all limits simultaneously

  38. Early references for initial architecture Understand the differences and extrapolate Prototype, Measure and Tune. MSITs Deployments/Case Studies . • . • Social Networking • . • Team Collaboration • . • Enterprise Portal . . • Federated Search • federated Meta Data, Web Analytics • User Profiles

  39. Description: Company wide, Self provisioning, TeamCollaboration, sites ~100k users Team Collaboration Data Set: Workload: • Browser requests generating ~83%

  40. Team Collaboration Hardware: Hardware Load Balancer Health & Performance Score: • 2 SQL Servers [16 Core, 32 GB, SQL 2008] • 5 WFE: [8 Core, 32 GB, Win 2008 R2] • 4 General + 1 crawl target • 3 App Servers [8 Core, 32 GB, Win 2008 R2] • WAC, Excel, PowerPoint Services: Federated Services: User Profile, Web Analytics, BCS, Managed Metadata • *Logging DB on a separate SQL box Compared to O12: No SQL changes 4 new App/WFE boxes + Scale up: 4 cores  8 cores, 16 GB  32 GB * Weplan to scale down now that things look healthy

  41. Load Test Kit (LTK) – V1 at RTM SPDiag 2010 – (sometimes in 2010) Additional investments:

  42. SharePoint 2010 is Bigger, Richer, Scalable and Flexible Faster, and more Reliable Easier to Diagnose Plan, Prototype, Measure Expect more guidance over time Summary

  43. Questions ?

  44. Thank you for your Attention! • For more Information please contact • Name Nicolas MENIGON • Title • Email nmenigon@sqli.com • Tel • Mobile • Company Name SQLi • Address Line • ZIP & Town

More Related