Microsoft Office Project Server 2007 – Solution Elements and Data Flow

1. Microsoft Office Project Server 2007 – Solution Elements and Data Flow Michael Jordan Lead Architect (EPM Global Practice) Microsoft Corporation michjor@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 SharePoint Server Intranet Farm • Disaster Recovery • Virtualization

3. Prerequisite Knowledge • Deployed Project Server 2007 as POC • Reviewed TechNet and MSDN • http://technet.microsoft.com/en-us/library/cc303399.aspx • http://msdn.microsoft.com/en-us/office/aa905469.aspx Level 300

4. What We Will Cover • Review the logical solution • Describe key concepts to the solution elements • Describe key concepts to data flow • Cover elements of scalability and performance factors

5. Agenda • Solution Overview • Solution Elements • Data Flow

6. Agenda • Solution Overview • Solution Elements • Data Flow

7. Solution OverviewLogical Architecture Client Database Server Application/PSI Server All servers in farm (Timer Service) Business Logic Tier Web Service Tier http://ServerName:56737/SSPName/psi/*.asmx Internal Web Services External Web Services ASMX Definition Project User Context Filter Data Access Layer Data Access Layer Business Objects Eventing Service Queuing Service Server Side Scheduling Serializer Web Server Project Professional Authentication Project User Context Project Web Access 3rd Party Client Custom Logic Impersonation Local access to SSP Scheduling Engine Desktop Reporting Local Cache Soap Client Serializer IE Browser Level Security Zone ActiveX Controls Office Web Comp Outlook Addin http://ServerName/InstanceName/_vti_bin/psi/*.asmx User session state Project Server Draft Database(n) Shared Services Content Database PSI Forwarder Local Server Cache Farm Configuration Database Central Admin Content Database Shared Services Service Database Project Server Reporting Database(n) Project Server Published Database(n) Web Application Content Database(n) Project Server Archive Database(n) 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 • Terminal Services • VPN • Virtualization • 32/64 Bit • IIS • Binaries • Data Schema • Project • WSS • NT • Web • ULS • Perf Counter • Event • PSConfig • Firewall • Active Directory • DNS • Exchange • Loadbalancing • Clustering • Mirroring • Backup • Disaster Recovery • Network • Processor • Memory • Disk

8. Agenda • Solution Overview • Solution Elements • Data Flow

9. Solution ElementsClient Project Pro Internet Explorer • Project Web Access • Global users – WAN performance may determine TS users • Security Zone settings (GPO) • Active X • Deployment scripts • Rendering overhead for user perceived performance • Outlook Addin • OWC – ports and credentials • Windows Firewall • Level 2 browsers not supported • Application compatibility – requires TS usage • SOAP/HTTP • Cache • Roaming profile or TS user breaks fidelity (shared) • Differential saves (WAN performance) • Default size on disk • Profile – Create through GPO and registry • Visual reports – Size of mdb file on disk • Vista, MLU & Change highlighting – Client machine horsepower • Application compatibility – requires TS usage Capacity Scalability High Availability Performance Disk size for local cache and mdb files Scale up - client machine resources for CPU and RAM Scale up - client machine resources for CPU and RAM Remote access for WAN users Cache to queue connectivity Cache error dialog Remote Access to TS farm

10. Solution ElementsServer Web Front End PSI Server Receives and responds to HTTP requests (High network traffic) Manages WSS Authentication Hosts the Project Web App Built on Master pages and WebParts High HTTP payload (CPU burn) Manages Project authorization Hosts SSP Web App SSP round robin loadbalancing Runs Queue service (High CPU for RDSSync process) Limits - # SSP & PWA instances Does not support IFSS Hosts all Farm data Enterprise Edition Disk topology/IO path isolation Large bus bandwidth Memory allocation 10% of OS Lock pages in memory Setup TempDB 1::1 CPU ratio SQL Server Analysis Services • Data mart houses Project cubes • Permissions (SSP Account) • Local file system repository • Cubes • SQL Surface configuration • OWC and HTTP Pump • Build times against ReportingDB Capacity Scalability High Availability Performance Disk subsystem Isolate net work traffic Bus architecture 64Bit ReportingDB own instance/server Scale up 64 bit, CPU & RAM Scale out WFE and PSI Q thread count Watch CPU ratio WFE/PSI:SQL ReportingDB own instance/server Increase WFE & PSI Q thread count TempDB equal sizes - autogrow 64 Bit Isolate network traffic SAN Disks and clustering (SQL) Loadbalancing (WFE) SPOF (PSI round robin)

11. Solution ElementsSQL • Plan for size and file placement • GUIDS • Support federation – unique • Slower performance for reads and inserts on large tables • Introduces fragmentation • Clustered • One per table • Monotonical identity • Data stored as part of index • Non-clustered • Many per table • Allows GUID datatype • Data stored separate to index (holds a pointer) • Rebuild weekly after publishes • Use DTA (tuning advisor) with trace from core scenarios to identify and build new indexes • Disk defragmentation • Automate with SQL Plan wizard • Check Database Integrity • Verifies integrity of database • Uses DBCC Checkdb • Very disk and CPU intensive • Update Statistics • Help DB engine decide most optimal execution path • Improves the efficiency of queries • Uses UPDATE STATISTICS • Reindex databases • Defragments database indexes • Uses DBCC INDEXDEFRAG • Rebuild Index • Completely recreates the database index Index Management Maintenance Plans

12. Agenda • Solution Overview • Solution Elements • Data Flow

13. Data FlowComponents Profiles Storage MPP & Local cache Project Draft (Primary) Archive, Published (Draft Replicas). Reporting (Published & PWS replicas) OLAP Cubes (ReportDB replica) WSS – Users (Auth), PWS (Data) SSP_DB – Sessions & NC System – Logs • User: Read/Only • Browsing • User: Read Write • Statusing/Timesheet/Admin • Project Manager: Read Write • Queue: Write • PSI to Queue storage • Queue: Read Write • Queue job processing • PSI • WinProj: Serialized ByteArray • HTTP: Dataset parameter • Queue processing • BO/DAL (serialization) • SQL to SQL (no serialization) • Scheduling Engine • WinProj • WFE – Task Scheduling (NC) • Server Side Queue Movement • Multi-threaded, asynchronous and synchronous • Job Saving: Binary datatype, Draft and Published Q • Job Polling: Possible bottleneck read locks (adjust thread count) • Job Processing • “3rd” Q - Rendezvous • Job Statusing: Are you done yet

14. Data FlowEnd to end – key areas for scalability PWA WSS sync User Session OLAP Build ADSync Authentication Archive Proposals/Activities Timesheet/Statusing PWA Administration PSI Server Web Front End Draft Project Professional Shared Threads Shared Threads System Logs Published SSP – Queue Service (n instances) Session State (SSP_DB) SSP – Business Objects Reporting Task Scheduling (SSP_DB) SSP – Data Access Layer Authentication (WSS) OLAP Cubes Server Side Scheduling Engine Scheduling Engine Cache Serializer Delta saves Content PWS • Disable WSS Sync • PSDBTimeout • IIS Timeout • ASP.Net Timeout Capacity Scalability High Availability Performance Queue processing Multiple SSPs SQL queue storage limits SSP_DB job monitor to delete expired sessions Queue thread count Add PSI servers Adjust timeout settings Adjust permission sync Queue threads # PSI servers Disk subsystem Queue retries Multithreaded PSI – monitoring (SPOF) WFE – Loadbalancing SSP_DB – Disk topology Multiple servers Queue failover

15. Session Summary • Deploying Project Server 2007 is an enterprise undertaking • Consider all the solution elements in the deployment process and operational maintenance • Be aware of the many integration points for data flow and how they affect the solution

16. Webcasts SeriesWhat to expect next • 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 SharePoint Server Intranet Farm • Disaster Recovery • Virtualization

17. For More Information… • Project Server TechCenter • http://technet.microsoft.com/en-us/office/projectserver • Project Developer Portal • http://msdn.microsoft.com/en-us/office/aa905469.aspx • EPM University • http://www.msepmu.com • EPM Connect • http://www.epmconnect.com • The Microsoft Office Enterprise Project Management (EPM) Solution • http://www.microsoft.com/epm

18. Next Steps • View other EPM related webcast • http://www.microsoft.com/events/series/epm.asp • Check the latest download and content available for Project Server • http://technet.microsoft.com/en-us/office/projectserver