1 / 39

Microsoft Office Project Server 2007: Maintenance and Monitoring

Microsoft Office Project Server 2007: Maintenance and Monitoring. Jean-Francois LeSaux Architect, EPM Global Practice Microsoft Corporation jeanfl@microsoft.com. Webcasts Series What to expect. Solution Overview and System Elements Solution Elements and Data Flow

rusti
Download Presentation

Microsoft Office Project Server 2007: Maintenance and Monitoring

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. Microsoft Office Project Server 2007: Maintenance and Monitoring Jean-Francois LeSaux Architect, EPM Global Practice Microsoft Corporation jeanfl@microsoft.com

  2. Webcasts SeriesWhat to expect • Solution Overview and System Elements • Solution Elements and Data Flow • Workload Scenarios and Reference Architecture • Network Communication • Server Administration • Maintenance and Monitoring • Deployment into a Microsoft® Office SharePoint® Server (MOSS) Intranet Farm • Disaster Recovery • Virtualization

  3. What We Will Cover • Review of the logical architecture • Microsoft® Office Project Server maintenance • Farm backup • Moving environments • Database care • Service packs and updates deployments • Project Server monitoring • Farm, server health • Usage

  4. Solution Overview:Logical Architecture Client Database Server Application/PSI Server All servers in farm (Timer Service) Business Logic Tier Web Service Tier Web Server http://ServerName:56737/SSPName/psi/*.asmx Internal Web Services External Web Services ASMX Definition Data Access Layer Project User Context Business Objects Filter Data Access Layer Eventing Service Queuing Service Server Side Scheduling Serializer Third-Party Client Project Professional Authentication Project User Context Project Web Access • Scheduling Engine • Desktop Reporting • Local Cache • Soap Client • Serializer • Custom Logic • Impersonation • Local access to SSP • IE Browser Level • Security Zone • ActiveX® Controls • Office Web Comp • Outlook Addin http://ServerName/InstanceName/_vti_bin/psi/*.asmx User session state Shared Services Content Database PSI Forwarder Local Server Cache Project Server Archive Database(n) Shared Services Service Database Web Application Content Database(n) Central Admin Content Database Project Server Draft Database(n) Project Server Reporting Database(n) Project Server Published Database(n) Farm Configuration Database Central Admin Web App Root Site Web App ASPX Web Parts PSI Proxies Master Pages System PWA and WSS content pages SSP Web App Patch Management Remote Access Services Logs Domain Sub-System Platform Fault Tolerance Firewall Active Directory® DNS Exchange • Loadbalancing • Clustering • Mirroring • Backup • Disaster Recovery Web ULS Perf Counter Event PSConfig Terminal Services VPN • Binaries • Data Schema • Virtualization • 32/64 Bit • IIS • Project • WSS • NT • Network • Processor • Memory • Disk

  5. Project Server Maintenance • Farm backup • Moving/migrating environments • Database care • Service packs and update deployments

  6. EPM Components

  7. EPM Content (Where Is My Data?) • Microsoft® Office Enterprise Project Management (EPM) data (Four databases) • Project • Enterprise Resource • Enterprise Custom Fields • Enterprise Global • (…) • EPM data in SharePoint (Content DB) • Documents • Risks • Issues • Deliverables

  8. EPM Data • EPM Administrative Backup/Restore • Use of the Project_Archive Database • Define the retention level (versions) • Driven by EPM functional administrator • Can be scheduled • Define the retention level (policy) “Oops I have deleted my project!”

  9. Backup and Restore Solutions • SharePoint Backup/Restore • Microsoft® SQL Server® Backup and Restore • Third-party solutions

  10. SharePoint Backup/RestoreHow it works Central Admin Console Farm File Server SQL Backup/Restore

  11. SharePoint Backup/RestoreDetails • Out-of-the-box UI and command-line access for Central Administrator • ‘Hooks up’ SharePoint databases and search index on Restore • Supports Full and Differential backup • Backs up the search index (MOSS only) • Extensible framework for third-party applications

  12. Use the command line with Windows Task Scheduler for scheduled backups Backs up content, SSP, EPM databases, and search index You must manually backup front-end files We recommend you keep images of your Web front ends High restore time  Low availability SharePoint Backup/RestoreLimitations

  13. Command Line • %CommonProgramFiles%\Microsoft Shared\Web Server Extensions\12\bin\Stsadm –o backup • –directory \\SHARE\Backup • –backupmethod full • > D:\LOGS\Log_backup.txt

  14. SQL-Only Backup/Restore • Pros • Reuse existing technology and processes • Non-application specific • Remember • Post-restore reattachment and clean up • Search index must be backed up separately via SharePoint backup for MOSS “My SQL servers are managed by a separate organization or data center from my SharePoint installations.”

  15. To create a farm backup Use stsadm –o backup/restore To migrate a site collection Use stsadm –o backup http://server/site To migrate a site/list/library/item Use stsadm –o export/import for sites Use Site Manager within site collection Solution for Each Scenario

  16. Database Care for DBAs • Table and Index Fragmentation • Re-Indexing • Statistics Update • Maintenance Plan

  17. Database Care for DBAs • SQL Maintenance Plan • Storage (separate data and log if possible) • Recovery model • Maintenance plans • Back Up Database • Check DatabaseIntegrity • RebuildIndex (-> update statistics) • HistoryCleanup • Maintenance Cleanup

  18. EPM 2007 Resource Kit Tools • Project Server Settings Backup and Restore (Playbooks) • Project Workspace Site Relinker • View Effective Rights

  19. EPM Settings • Backup/Restore Project Server 2007 Settings • For example, to move a configuration from/to differentenvironments • Development/Integration/Production • New tool in EPM 2007 Resource kit • Playbooks “How do I copy Project Server 2007 settings from development to production ?”

  20. Resource Kit: Playbooks

  21. EPM Settings • Pros • No need to transfer the EPM data • Clean way to work with several environments • Backup your settings and keep history • Cons • Not a backup or high-availability solution

  22. Deploying Software Updates • Check TechNet for deployment guidance • Stay up to date with http://support.microsoft.com

  23. Deploying Software Updates • Read the Knowledge Base article published • Backup all databases • Deploy the updates on a test environment and validate the impact before rolling out to Production • Install the updates on servers and clients (if required) • Propagate the changes on the farm (PSConfig)

  24. demonstration Maintenance Tools • Backup • Maintenance Plans • Resource Kit: Playbooks • Resource Kit: WSS Relink

  25. Project Server Monitoring • Farm, Server Health • Usage

  26. Project Server Monitoring • Tools of the trade • SharePoint Best Practices Analyzer • SharePoint Diagnostic Tool: SPDiag • Performance Monitor • Microsoft® Operations Manager 2005 • Microsoft® System Center 2007

  27. Best Practices Analyzer • SharePoint Best Practices Analyzer • www.microsoft.com/downloads/details.aspx?familyid=cb944b27-9d6b-4a1f-b3e1-778efda07df8&displaylang=en

  28. SharePoint Diagnostic Tool: SPDiag • What is it?

  29. SharePoint Diagnostic Tool: SPDiag • Snapshot View

  30. SharePoint Diagnostic Tool: SPDiag • Trends View

  31. Monitoring and Tools • New for 2007 – counters built in to the Performance System Monitor • As with all performance monitoring it is always best to capture a good baseline when things are working OK

  32. Performance Counters • General • % Sql Retries • % Sql Retries Last Hour • Active Threads • Average Queue Depth • Current Queue Depth • New Jobs Last Hour • Sql Calls/Hour • Sql Calls Last Hour • Sql Retries Last Hour • Jobs • % Jobs Failed • % Jobs Failed Last Hour • % Jobs Retried • % Jobs Retried Last Hour • Average Processing Time • Average Processing Time Last Hour • Average Wait Time • Average Wait Time Last Hour • Jobs Failed Last Hour • Jobs Processed/Hour • Jobs Processed Last Hour • Jobs Retried Last Hour

  33. Complete Monitoring Solutions • Microsoft Operations Manager 2005 • Microsoft System Center 2007

  34. Complete Monitoring Solutions • Microsoft Office Project Server 2007 Management Pack • http://go.microsoft.com/fwlink/?LinkID=94825&clcid=0x409 – White paper • This Management Pack alerts you about the following critical conditions: • Active Directory synchronization failed • Cube build failed • E-mail notification delivery failed • Database connection failed • Project plans take a long time to open • Version incompatibilities exist between the client and server • The Microsoft Office Project Server Queue service is not running • The Microsoft Office Project Server Events service is not running • Missing server-side event handlers • Project workspace creation failed • Project workspace user synchronization failed • Management Packs also available for:- • Windows® SharePoint® Services 3.0 • Microsoft SQL Server (2000 and 2005) • Base Operating Systems • Microsoft Web Sites and Services

  35. demonstration Monitoring Tools • SPDiag • IIS Logs Analysis

  36. Session Summary • Maintaining a Project Server 2007 environment involves several roles, tools, and processes • Leverage existing tools when monitoring Project Server 2007

  37. More Information on EPM • The Microsoft Office Enterprise Project Management (EPM) Solution • www.microsoft.com/epm • TechNet • Project Server TechCenter • Project Server 2007 Planning, Architecture, Deployment, and Operations • Deploy Office Project Server 2007 with Office SharePoint Server 2007 • IT Professionals webcast series • Administrator role guide for Project Web Access • http://office.microsoft.com/en-us/projectserver/HA102403241033.aspx • EPM University • www.msepmu.com • EPM Connect • www.epmconnect.com • Blogs • Project Server IT Professionals Bookmarks • http://blogs.msdn.com/project/ • http://blogs.msdn.com/brismith • http://blogs.msdn.com/shaden • http://blogs.msdn.com/chrisfie

  38. Questions and Answers • Submit text questions using the “Ask” button • Don’t forget to fill out the survey • For upcoming and previously live webcasts: www.microsoft.com/webcast • Got webcast content ideas? Contact us at: http://go.microsoft.com/fwlink/?LinkId=41781

More Related