TechNet_webcast_PRTL_375_Joelo_ScaleandPerformance by mudoc123

VIEWS: 0 PAGES: 40

									PRT375: SharePoint
Products & Technologies:
Performance and Capacity
Planning, Best Practices
and Lessons Learned
Joel Oleson
Technologist
joelo@microsoft.com
Prerequisite Knowledge

• IIS 6 Administration
• SharePoint Portal Server
• Windows SharePoint Services




 Level 300
Agenda
• Microsoft IT Best Practices & Lessons
  Learned
   – Microsoft IT’s Solution
   – Capacity Planning
   – Scalability & Manageability
   – Performance Tuning
   – FY06
   – References
• Q&A
Agenda
• Microsoft IT Best Practices & Lessons
  Learned
   – Microsoft IT’s Solution
   – Capacity Planning
   – Scalability & Manageability
   – Performance Tuning
   – FY06
   – References
• Q&A
                                              95,000 e-mail
300,000+ PCs and devices                      server accounts               Single Instance
                                                                            SAP
>7,000 Servers


                                      Dublin
    Canyon Park                       Reading       Munich
     Redmond                                 London

     Silicon Valley                                                                 Tokyo
                      Charlotte

                                                                                  400+
                                                                Singapore
                                                                                  supported
  89,000 end users                                                                MS sites
                                                                                  worldwide
                                  Sao Paulo

 123,500 remote                               Johannesburg                      Sydney

 connections/month                              3M+ e-mail messages
                                                per day internally
                                                                Microsoft IT Data as of May 1, 2004
IT SharePoint Strategy
User to Enterprise Consistency

                                  Enterprise



                       Division



               Team


  Individual
The Microsoft Site Hierarchy

                        MSWeb

               Divisional/Regional Portals
                              Personal Sites



                                    Team Sites
      Group Portals
Global SharePoint Deployment
       Aggregated enterprise search
       ● Portals
       ● Team Sites                                Regional search
       ● Personal Sites                            ● Portals
       ● Partner collaboration                     ● Team Sites
                                                   ● Personal Sites
                                                   ● Partner collaboration



                                      Dublin
  Redmond
                                                                                            Chofu



                                                                     Singapore   Regional search
                                                                                 ● Portals
                                                                                 ● Team Sites
                                                                                 ● Personal Sites
                                               Regional search
                                               ● Portals
                                               ● Team Sites
                                               ● Personal Sites
                                               ● Partner Collaboration
Agenda
• Microsoft IT Best Practices & Lessons
  Learned
   – Microsoft IT’s Solution
   – Capacity Planning
   – Scalability & Manageability
   – Performance Tuning
   – FY06
   – References
• Q&A
Capacity Planning
 • Plan for 25-50GB Databases
 • Limit Number & Size of Sites per
   Database
   – Use 250 sites per database = 25GB @
     100MB
 • Microsoft Profile:
   – Personal Site = 20MB
   – Team Site = 60MB
 • Data LUNS/Drives vs. Backup Drive
System Sizing

• Small Farm Scenario         • Large Farm Benefits
  – Availability not a          –   Search Offloaded
    concern                     –   Indexing Offloaded
  – Cost restrictive            –   Millions of documents
  – 1-3,000 Users               –   1000-30,000 Users
• Medium Farm Benefits • Adding Front Ends
  *                      – 1 per additional 25,000
  – High Availability 99.9%         users
  – Offloaded Indexing
  – 1000-30,000 Users
Hardware Decisions

•   Web – Memory, NIC
•   Search – NIC
•   Index – CPU, NIC
•   SQL – Memory, CPU, NIC, Backup
    Strategy
Americas Intranet Hardware
      SharePoint Portal Server 2003                    Windows SharePoint Services




                               2 WFE
        4 + 1 WFE                           2 WFE        2 WFE           2 WFE          2 WFE

                             Portal 100   Portal 200                      Host        Upgraded
                                                       Team Farm
                                                                         Header         Farm


        2 Search




         3 Index

  MSWeb & Shared Services




       SQL (A/P)            32bit SQL      x64 SQL
                                             (A/P)           SQL (A/P)            SQL (A/P)
                              (A/P)
       Portal SQL           Portal SQL    Portal SQL         Team SQL             Team SQL
         Cluster             Cluster        Cluster           Cluster              Cluster
Agenda
• Microsoft IT Best Practices & Lessons
  Learned
   – Microsoft IT’s Solution
   – Capacity Planning
   – Scalability & Manageability
   – Performance Tuning
   – FY06
   – References
• Q&A
SharePoint Growth and Scale
Usage Statistics on “Team”
   “Team” IIS Logs (Jan 2-8, 2005)
   Total Hits                 24 M
   Total Sessions             375 K
   Unique Visitors            80 K
   Page Requests              21 M
   Bandwidth Out              1TB
   Out bits/sec               14Mb
   Bandwidth In               77GB
   In bits/sec                1Mb
Web CPU vs. Connections
MSWeb Quick Stats
              - 6 Million Files Indexed
              - 37GB Indexes
              - Largest 15GB 2.2M files
                – Time to prop: 3 hr
                – Time to crawl: 12 days
              - Content Sources 195
Manageability with MOM 2005
• MOM Packs
  – Windows SharePoint Services
  – SharePoint Portal Server 2003
  – SQL 2000
  – IIS 6
  – Microsoft Cluster Service
  – Windows 2003 Server
• Web Site Monitoring
  – Web Sites and Services MP
Agenda
• Microsoft IT Best Practices & Lessons
  Learned
   – Capacity Planning
   – Scalability & Manageability
   – Performance Tuning
   – FY06
   – References
• Q&A
Key Perf Counters
Performance Tuning IIS
 • Use few virtual servers
 • Consolidate app pools, divide for poor
   performing
 • Use web garden for max performance
   – 3 W3WP work great one high usage virtual
     server on 4 GB box
 • Limit WP Memory consumed to 500 - max
   800MB
 • Disable auto-rapid failure
App Pool Worker Processes Properties
Performance Tuning SQL

• Maintenance Plan
  – Regular Defrag Dbs/Disks (Monthly/Quarterly)
  – Regular DBCCs
  – Cleanup/Offline
• Resource Planning
  – FTS vs. SPS Search (MSSearch.exe)
  – Instances? – 1 max for perf /server
  – Disk Optimization (RAID Config)
Performance Tuning Memory

 • Web Front End Server Memory
   – Use 4 GB RAM
   – Add /3GB to boot.ini
 • SQL
   – Use 4 GB RAM
   – Add /3GB to boot.ini
   – Add –g512 to SQL Startup Parameters
   – Use AWE and /PAE for 8GB Machines (High
     End)
   – Limit databases < 300
Performance Tuning Backups

 • OM Site Backups don’t scale and cause
   SQL blocking
 • SharePoint Database Explorer for file
   restore (Reskit)
 • Third party compressed database backup
 • Use Private Network or Fiber attached tape
 • Disk Pivoting -Utilize Passive Node
 • SPSBackup for Index only
Performance Tuning Network

• Private network or Fiber attached
  tape to offload network
• Configure Front End & Backend NIC
  w/ separate routes
• Use Crossover or hub/switch for NLB
  & MSCS Clusters
• GigE gave us 3X performance
Performance Tuning Index
 • Planning
   – Use Site Directory as Content Source
   – Scope w/ Source Groups
   – Use fewer Indexes
   – Ad hoc content in larger index
   – Important Content in smaller index
 • Maintenance
   – Avoid/Remove Single Threaded I-filters
   – Avoid Indexing content twice
   – Remove - default index every 10 min
   – Limit # of indexing threads
Performance Tuning Misc.

• Kerberos vs. NTLM vs. Basic
• IIS Compression - level 9
• Third Party – Offline, Replication,
  Acceleration
• WSS & SPS SP1 Fixes
• SPS Search vs. FTS
• WSS Hot fix (Post SP1)
  – KB: 889385 (SharePoint Usage & Site Backup)
Agenda
• Microsoft IT Best Practices & Lessons
  Learned
   – Capacity Planning
   – Scalability & Manageability
   – Performance Tuning
   – FY06
   – References
• Q&A
IT FY06 Plans

• 64bit Hardware & Software
  – Windows 2003 SP1 Rollout
  – SQL 2005
• SharePoint SP2
• Continue to Scale Up & Out
• Smart tools/WebParts to fit business
  scenarios
• Search/Index Optimization and Ranking
Agenda
• Microsoft IT Best Practices & Lessons
  Learned
   – Capacity Planning
   – Scalability & Manageability
   – Performance Tuning
   – FY06
   – References
• Q&A
References

• Microsoft IT Performance White Paper
  – http://www.microsoft.com/downloads/details.aspx?familyid=8acf3b
    81-2db5-4079-b904-589d2d49bedd&displaylang=en
• Microsoft IT SharePoint Deployment WebCast
  – http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=10
    32241971&Culture=en-US
• Microsoft SharePoint & ISA Extranet Whitepaper
  – http://www.microsoft.com/downloads/details.aspx?FamilyId=4C5B
    F9DD-3EFB-451D-B213-98ED039190BF&displaylang=en
• SharePoint Resource Kit
  – http://www.microsoft.com/technet/prodtechnol/sppt/reskit/default.
    mspx
• Visit TechNet at www.microsoft.com/technet
Session Summary

• Establish Profile - Plan for db capacity
• Namespace Strategy - Few IIS Virtual
  Servers/Web Sites
• Plan Enterprise Search to avoid duplicate
  indexing
• Monitor Performance for bottlenecks
IT Showcase:
How Microsoft Does IT
Customer-ready resources from Microsoft IT

 – IT Showcase on TechNet
   http://www.microsoft.com/technet/
   itshowcase/
 – IT Showcase on Microsoft Services
   http://www.microsoft.com/itshowcase/
Where Can I Get Help?

• Attend a free chat or webcast
  www.microsoft.com/technet/community/chats
  www.microsoft.com/technet/community/webcasts
• List of newsgroups
  www.microsoft.com/technet/community/newsgroups
• Microsoft community sites
  www.microsoft.com/technet/community
• Community events
  www.microsoft.com/technet/community/events
• Community columns
  www.microsoft.com/technet/community/columns
For More Information…

• Main TechNet Web site at
  www.microsoft.com/technet
• Additional resources to support this Session
  page can be found at
  www.microsoft.com/technet/tnt1-117
Questions and Answers

• Submit text questions using the “Ask a Question”
  button.
• Don’t forget to fill out the survey.
• For upcoming and previously live webcasts:
  www.microsoft.com/webcasts
• Got webcast content ideas?
  E-mail us at:
  http://go.microsoft.com/fwlink/?LinkId=41781
• Today's webcast was presented using Microsoft Office
  Live Meeting. Get a free 14 day trial
  http://www.microsoft.com/presentlive

								
To top