The EPM solution infrastructure requirements

Posted By Posted by: Laith Adel on September 24, 2010

 

The EPM solution infrastructure requirements can be categorised into 2 main categories:

  1. Hardware
  2. Software

 

Hardware

The hardware category has two folds or complements that need be thought of and decided:

  1. Servers’ Farm Topology: this basically cover the design of the three tier solution, where the number of servers for each tier is decided, or where a number of tiers are merged into a single server. Also this design will show whether these servers are physical or virtual. See example:

Microsoft EPMSolution - Hardware

  1. Hardware Specifications for  Each Server: this covers the processor, RAM, storage, network, etc

 

The two above components are dependent on many factors like the number of users; the type, complexity, and frequency of user operations; the number of postbacks in an operation; and the performance of data connections, etc. To come up with a recommendation, or design the topology, you can use the  “Estimate Performance and Capacity Requirements for Microsoft Project Server 2010” from Microsoft for that (but it is not straight forward)  http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4FC24C1B-94BF-463A-8ADA-3932DBDC2024&amp%3Bdisplaylang=en

Software:

The software requirements are relatively straight forward (assuming a standard implementation of the tool), following is a description of the key components required to be installed (and managed) by the infrastructure engineers. (Reference http://technet.microsoft.com/en-au/library/ee683978.aspx#section8 )

 

Client 

Internet Explorer Internet Explorer 7.0 or 8.0 is required for a Project Server 2010 installation and for client computers that will be using Project Web Access.
Microsoft Office Excel 2007 or 2010 (No Excel installation is required to view Excel Services reports)
Microsoft Project Professional 2010 or 2007 can be used to preview 2010 files without editing capability.MS Project 2007 with Service Pack 2 is supported for Project Server 2010 in compatibility mode (The  installation of KB980209 is recommended)

 

Servers

SQL Server 2005 or 2008 or R2: Standard or Enterprise Edition and 64bit required. The following components of SQL Server are required:

  • Database Engine
  • Analysis Services
  • Reporting Services (KB981702 required if not using R2)
  • Management tools
  • Connectivity components

Note:

SQL 2005 requires Service Pack 3 and Cumulative Update 3 (KB967909)

SQL 2008 requires Service Pack 1 and Cumulative Update 2 (KB970315)
Windows Server 2008 or R2: Standard, Enterprise, or Data Center Edition (64-bit)
Server Roles and Windows PowerShell Project Server 2010 requires the following Windows Server 2008 server roles on each application server in the farm:

  • Application Server role
    • Web Server role with Internet Information Services (IIS) 6 Management Compatibility enabled

In addition to these server roles, Project Server 2010 also requires that Windows PowerShell be enabled.

Both server roles and PowerShell are configured automatically by the SharePoint Server 2010 prerequisite installation tool if they are not already enabled.
Optional Exchange 2007 SP1 or later

 

SharePoint Server 2010 Enterprise Edition
Project Server 2010 
Blog Posted In Blog Posted In: Project Server
Blog Posted In Comments Off on The EPM solution infrastructure requirements