Mike Henthorn, Covenant Technology Partners, LLC - PowerPoint PPT Presentation


PPT – Mike Henthorn, Covenant Technology Partners, LLC PowerPoint presentation | free to view - id: 2776bc-ZDc1Z


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation

Mike Henthorn, Covenant Technology Partners, LLC


none – PowerPoint PPT presentation

Number of Views:53
Avg rating:3.0/5.0
Slides: 39
Provided by: justinj2


Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Mike Henthorn, Covenant Technology Partners, LLC

Microsoft Office SharePoint Server 2007 SP 2 Key
  • Presented By
  • Mike Henthorn, Covenant Technology Partners, LLC
  • JD Wade, Horizons Consulting, Inc.

  • Part I
  • Introductions
  • Introduction to Microsoft SP2
  • Overview of SharePoint SP2 Improvements
  • Part 2
  • Review of the SharePoint Update Process

Introduction to SP2
  • Service Pack 2 for the 2007 Microsoft Office
  • Service Pack 2 will update the following
  • Microsoft Windows SharePoint Services 3.0 (WSS)
  • Microsoft Office SharePoint Server 2007 (MOSS)
  • Microsoft Office Project Server 2007
  • Microsoft Office Forms Server 2007
  • Microsoft Search Server 2008
  • Microsoft Search Server 2008 Express
  • Microsoft Office Groove Server 2007, 64-Bit

SharePoint (MOSS, WSS)
  • Focusing on the improvements to the following
  • Microsoft Windows SharePoint Services 3.0 (WSS)
  • Microsoft Office SharePoint Server 2007 (MOSS)
  • Key features of this update
  • Improve performance and availability in your
    SharePoint server farm
  • Rollup of fixes to known issues across SharePoint
    Products and Technologies
  • Enhancements designed to support greater
  • Improve user experience
  • Reduce administrative burden
  • Provides the groundwork for an eventual upgrade
    path to the next major version of SharePoint
    Products and Technologies
  • Has been officially named SharePoint 2010

  • Important to note that this SP2 release
    incorporates all previous major and minor updates
  • Hotfixes
  • Service Pack 1 (SP1)
  • Infrastructure Update
  • Cumulative update packages up to and including
    those released in February 2009.
  • Upgrade paths
  • WSS 3.0 RTM Directly to SP2
  • SharePoint 2007 RTM Directly to SP2
  • Outstanding issue
  • After installing this update your License will be
    set back to evaluation period of 180 Days..
  • A patch was release 6/25/2009
  • KB Article http//tinyurl.com/kb971620
  • MSDN Blog http//tinyurl.com/msdn-sp2-update
  • For more technical information on SP2, please see
  • Updates Resource Center for SharePoint Products
    and Technologies
  • http//tinyurl.com/36hlpf

Database Integrity
  • Index fragmentation is a major cause of
    performance degradation in Microsoft SQL Server
  • Problem was addressed in SP2
  • New enhanced version of the Database Statistics
    timer job.
  • Previously, the sole responsibility of the
    Database Statistics job was to update query
    optimization statistics for content databases.
  • As of SP2, the job also rebuilds content database
    indexes every time it runs. This automatic index
    rebuild helps to stop fragmentation and maintain
    database performance.
  • The Database Statistics job uses the online index
    rebuild feature of SQL Server 2005 and should run
    without any impact on performance for content
    databases of up to the recommended size limit of
    100 GB.

Read-Only Content Databases
  • While performing some maintenance tasks, you may
    need to mark content databases as read-only.
  • On farms that are running SP2, the site
    collection associated with a read-only content
    database is set to be read-only automatically,
    and the user interface is modified so that users
    cannot perform tasks that require writing to the
  • Previously, the user interface was not modified,
    and users received error messages when they
    attempted to perform operations that wrote
    information to the content database.

Stsadm Enhancements
  • SP2 added 5 new commands for the Stsadm
    command-line tool.
  • Stsadm commands
  • ECM
  • stsadm -o variationsfixuptool
  • Site Management
  • stsadm -o enumallwebs
  • Administration
  • stsadm -o preupgradecheck
  • Search
  • stsadm -o setqueryprocessoroptions
  • stsadm -o listqueryprocessoroptions
  • More info http//tinyurl.com/stsadm

Microsoft Enterprise Content Management
  • Content Deployment and Site Variations
  • Office SharePoint Server 2007 SP2 includes
    several enhancements that improve the performance
    and stability of the content deployment and site
    variations features. 
  • In particular, Office SharePoint Server 2007 SP2
    adds a new operation to the Stsadm command-line
    tool that enables a SharePoint administrator to
    scan sites that use the variations feature for
  • The operation reports on errors encountered and,
    where possible, fixes the underlying issues.
  • For example, the operation can find and repair
    missing peer relationships and corrupted entries
    in the internal variations relationships list.
  • Handles the propagation of large volumes of
    variations content in a more manageable way.

ECM Command
  • stsadm -o variationsfixuptool

Site Management Enhancements
  • stsadm -o enumallwebs
  • stsadm -o enumallwebs -databasename
  • Displays the IDs and site map status for all site
    collections and subsites in the content database
  • More info http//tinyurl.com/stsadm

Commands with new parameters
  • Stsadm o deletesite
  • -Force the -force parameter is new with SP2 and
    allows you to delete orphaned site collections.
    In order to run the command, you need the GUID
    for the site collection. You can get this from
    either running the enumallwebs command as
    described above and looking for any site
    collections where InSiteMap"False".
  • Stsadm o deleteweb
  • -Force the -force parameter is new with SP2 and
    allows you to delete orphaned webs in the same
    way you can delete orphaned sites with deletesite
    -force as shown above.
  • Stsadm o backup
  • -Nositelock (site collection backup) specifies
    that the site collection lock during a site
    collection backup is not set to read-only.
  • -Force farm (catastrophic) backup ignores the
    disk space check and proceeds with the backup.
  • Stsadm o osearch
  • -Reprovisionindex in a farm with multiple SSPs,
    you can use to re-initialize the query servers
    for one of the SSPs while the other SSP continues
    to serve the query request.

Microsoft Office Search Server
  • Improves the reliability and stability of WSS
    crawl, of SharePoint crawl, of crawling through a
    very large corpus, and of backup restore.
  • For example, the Query processor multiplier can
    be used to tune the query performance for SSP
    indexing content sources that have highly
    restrictive permissions and many duplicates.
  • Improves the accuracy of searches that involve
    numbers. For example, there is additional support
    for large numbers in which a comma is used to
    separate every three digits (for example,
    1,000,000), for numbers that are between 9 and 40
    characters, and for numbers that are separated by

Microsoft Office Search Server, Cont
  • Introduces a new command to the Stsadm.exe tool
    that lets a SharePoint administrator tune the
    Query processor multiplier parameter.
  • stsadm -o setqueryprocessoroptions
  • Sets the current values of the SharePoint Search
    query processor settings

Microsoft Office Search Server, Cont
  • stsadm -o listqueryprocessoroptions
  • Displays the current values of the SharePoint
    Search query processor settings
  • More info http//tinyurl.com/stsadm

Improved User Experience with Forms
Authentication (FBA)
  • Windows SharePoint Services 3.0 SP2 and Office
    SharePoint Server 2007 SP2 offer a substantially
    improved client integration experience for
    forms-based authentication users.
  • Previously, forms-based authentication provided a
    poor experience when users attempted to use the
    client integration features of Windows SharePoint
    Services 3.0 or Office SharePoint Server 2007
    the client application would repeatedly prompt
    users for credentials whenever they executed a
    command in a document. To avoid this,
    administrators were advised to disable SharePoint
    client integration features in forms-based
    authentication environments.
  • Windows SharePoint Services 3.0 SP2 and Office
    SharePoint Server 2007 SP2, together with the SP2
    updates for Microsoft Office Client applications,
    provide a much smoother user experience and make
    client integration a viable option for
    forms-based authentication users.
  • Users of Microsoft Windows Vista must install
    Vista SP2 to take advantage of the improved user
  • Not with XP

Browser Support
  • Web browser support in SharePoint Products and
    Technologies is divided into two levels.
  • Level 1 Web browsers provide an optimal user
    experience for all SharePoint sites, through the
    use of advanced Microsoft ActiveX control
  • Level 1 browser support is extended to include
  • Microsoft Internet Explorer 8
  • Microsoft Internet Explorer 7 (already)
  • Level 2 Web browsers support all of the basic
    features of SharePoint Products and Technologies,
    including read and write functionality and site
    administration tasks.
  • Level 2 browser support is extended to include
  • Firefox 2
  • Firefox 3
  • http//office.microsoft.com/en-us/sharepointserver

Pre upgrade check operations
  • stsadm -o preupgradecheck
  • Assist administrators in preparing for upgrade
    from Windows SharePoint Services 3.0 and related
    products to future version of SharePoint and
    Technology products

  • This tool goes one step deeper and after the
    completion of this tool a nice output page is
    displayed that further dives into your FARM and
    outputs some decent information.  If there are
    failures or issues it will be deeply highlighted
    in this output. 
  • Guess Im ready to upgrade  ?

Pre upgrade check report
Report results, Please review the results
at C\Program Files\Common Files\Microsoft
Shared\Web Server Extensions\12\logs\PreUpgradeChe
There is some more info that I didn't capture but
you should get the idea. More info
http//tinyurl.com/stsadm Full reports
Pre-Upgrade Check Report (Sections)
  • Detail Report Sections
  • Information Only Search content sources and
    start addresses
  • Information Only Informational rule to list the
    Office Server Search topology information
  • Information Only Servers in the current farm
  • Information Only The components from this farm
  • Information Only Supported upgrade types
  • Information Only Site Definition Information
  • Information Only Language pack information
  • Information Only Feature Information
  • Information Only Alternate Access Mapping
    Url(s) within the current environment that should
    be considered when upgrading.
  • Information Only Lists and Libraries
  • Information Only Customized list views that
    will not be upgraded.
  • Information Only Customized field types that
    will not be upgraded.
  • Information Only Modified authorized types for
    workflow in web.config
  • Information Only Informational rule to list the
    Windows SharePoint Services Search topology

Microsoft Office Forms Server
  • SP2 offers a range of improvements for users of
    InfoPath Forms Services.
  • Performance enhancements in SP2 reduce both the
    memory requirements and the page load times for
    large browser-rendered forms.
  • SP2 also improves the browser rendering of
    various controls, such as the Cannot be blank red
    asterisk and the rich text field.
  • Improves reliability of Forms Server and of
    Microsoft Office SharePoint Server by addressing
    the previous behavior in which an upgrade of an
    administrator-approved form template triggers an
    IIS reset.
  • Improves the Digital Signature functionality for
    InfoPath Forms Services.

Microsoft Office Excel Services
  • SP2 includes a broad range of fixes and
    enhancements that improve the performance,
    security, stability, and usability of Excel
  • SP2 makes it easier to configure Excel Web Access
    Web Parts on new sites.
  • Several rendering, calculation, and security
    issues have been resolved.
  • Fixes Open Snapshot so that snapshots open more
    reliably, even if there is no SharePoint root
  • Fixes display issues that cause calculations to
    appear incorrect in some cases.
  • Improves connections to cubes by using .odc files
    in non-English cases.
  • Improves the performance of programmatic
  • Fixes conditional formatting in Mozilla Firefox

  • Windows SharePoint Services Service Pack 2 and
    Office SharePoint Server 2007 Service Pack 2
    offer significant enhancements to the
    performance, availability, and stability of your
    SharePoint environment.
  • Installing these service packs in your server
    farm also brings greater interoperability, with
    newly added support for broader range of Web
  • Finally, SP2 includes tools that you can use to
    prepare your SharePoint environment for the next
    major version of SharePoint Products and

  • http//blogs.technet.com/office_sustained_engineer
  • http//blogs.technet.com/office_sustained_engineer
  • http//support.microsoft.com/kb/971620
  • http//support.microsoft.com/kb/953334
  • For MOSS  http//technet.microsoft.com/en-us/libra
  • For WSS   http//technet.microsoft.com/en-us/libra
  • http//www.microsoft.com/downloads/details.aspx?Fa
  • SP2 Issues http//blogs.msdn.com/sharepoint/archi

Central Administration
  • Application
  • Web Front End

Deployment Process
  • Pre-steps (complete prior to upgrade)
  • Check for adequate disk space for binaries, index
    files (2.85 times), SQL database files (incl.
    tempdb), temp file locations, and log files.
  • Backup farm and verify restore capabilities. See
    backup notes here http//technet.microsoft.com/en
  • Backup any SharePoint out-of-box files you have
  • Document content databases (stsadm o
  • Check content database sizes (lt100GB, load
    balance Site Coll.)
  • Run orphan repair tool (KB 923904 stsadm o
  • Run DBCC CHECKDB on all databases and address any
  • Defragment databases (KB 943345). This step is
    NOT needed after Service Pack 2
  • Verify no upgrade timer jobs exist (see
    Deployment Guide).

Deployment Process
  • Upgrade steps
  • Backup farm just prior to upgrade
  • Rename upgrade log file on all servers (file is
  • Disable anti-virus (KB 936867).
  • Stop the WWW service on all WFE.
  • To speed up upgrade or if content DBs are greater
    than 25GB, disconnect databases (can use batch
  • Logged in as the Setup account, run appropriate
    packages. Cancel SharePoint Configuration Wizard
    each time.
  • Determine best first server to run upgrade (see
    Deployment Guide)
  • Run upgrade using psconfig cmd upgrade inplace
    b2b command line. Upgrade Process is fully
    described in KB 948780 (Baretail can be used to
    monitor upgrade log).

Deployment Process
  • Verify upgrade was successful using the upgrade
    log. Check the version number in CA (see
    Deployment Guide).
  • Complete upgrade on all other servers as
    described in above order
  • If you detached databases, begin attaching again
    one by one, upgrade process will be done when
    they attach. There is a more advanced parallel
    upgrade process for very large farms available in
    deployment document.
  • Install WSS and SharePoint Language Pack updates
    for both WSS and SharePoint.
  • Enable anti-virus (KB 936867)
  • Start the WWW service on all WFE
  • Complete a full crawl of all SharePoint content
    New features
  • Backup farm

(No Transcript)
About PowerShow.com