Mike Henthorn, Covenant Technology Partners, LLC

1
Microsoft Office SharePoint Server 2007 SP 2 Key
Benefits

• Presented By
• Mike Henthorn, Covenant Technology Partners, LLC
• JD Wade, Horizons Consulting, Inc.

2
Agenda

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

3
Introduction to SP2

• Service Pack 2 for the 2007 Microsoft Office
  system
• 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
  Edition

4
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
  interoperability
• 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

5
Reminder

• 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
  TechNet.
• Updates Resource Center for SharePoint Products
  and Technologies
• http//tinyurl.com/36hlpf

6
Database Integrity

• Index fragmentation is a major cause of
  performance degradation in Microsoft SQL Server
  databases.
• 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.

7
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
  database.
• 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.

8
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

9
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
  errors.
• 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.

10
ECM Command

• stsadm -o variationsfixuptool

11
Site Management Enhancements

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

12
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.

13
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
  spaces.

14
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

15
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

16
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
  experience.
• Not with XP

17
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
  features.
• 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
  /HA101945391033.aspx

18
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

19

• 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  ?

20
Pre upgrade check report
Report results, Please review the results
at C\Program Files\Common Files\Microsoft
Shared\Web Server Extensions\12\logs\PreUpgradeChe
ck-20090712-199143-697.htm
There is some more info that I didn't capture but
you should get the idea. More info
http//tinyurl.com/stsadmFull reports
http//tinyurl.com/upgradereport
21
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
  information

22
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.

23
Microsoft Office Excel Services

• SP2 includes a broad range of fixes and
  enhancements that improve the performance,
  security, stability, and usability of Excel
  Services.
• 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
  site.
• 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
  scenarios.
• Fixes conditional formatting in Mozilla Firefox
  browsers.

24
Conclusion

• 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
  browsers.
• Finally, SP2 includes tools that you can use to
  prepare your SharePoint environment for the next
  major version of SharePoint Products and
  Technologies.

25
Resources

• http//blogs.technet.com/office_sustained_engineer
  ing/archive/2009/04/23/service-pack-2-for-the-2007
  -microsoft-office-system-available-today.aspx
• http//blogs.technet.com/office_sustained_engineer
  ing/archive/2009/04/16/service-pack-2-for-the-2007
  -microsoft-office-system-due-to-ship-april-28th.as
  px
• http//support.microsoft.com/kb/971620
• http//support.microsoft.com/kb/953334
• For MOSS  http//technet.microsoft.com/en-us/libra
  ry/dd793609.aspx
• For WSS   http//technet.microsoft.com/en-us/libra
  ry/dd793607.aspx
• http//www.microsoft.com/downloads/details.aspx?Fa
  milyIdB7816D90-5FC6-4347-89B0-A80DEB27A082displa
  ylangen
• SP2 Issues http//blogs.msdn.com/sharepoint/archi
  ve/2009/05/21/attention-important-information-on-s
  ervice-pack-2.aspx

26
Deployment
27
Deployment
28
Deployment
29
Deployment
30
Deployment
Central Administration
31
Deployment
32
Deployment

• Application
• Web Front End

33
Deployment
34
Deployment
Done
35
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
  -us/library/cc706876.aspx
• Backup any SharePoint out-of-box files you have
  customized
• Document content databases (stsadm o
  enumcontentdbs)
• Check content database sizes (lt100GB, load
  balance Site Coll.)
• Run orphan repair tool (KB 923904 stsadm o
  databaserepair).
• Run DBCC CHECKDB on all databases and address any
  errors.
• Defragment databases (KB 943345). This step is
  NOT needed after Service Pack 2
• Verify no upgrade timer jobs exist (see
  Deployment Guide).

SharePoint
36
Deployment Process

• Upgrade steps
• Backup farm just prior to upgrade
• Rename upgrade log file on all servers (file is
  cumulative).
• 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
  file).
• 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).

SharePoint
37
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

SharePoint
38
(No Transcript)