Deployment configuration options for the Project Server 2007 Cube Building Service

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

This article describes supported deployment configuration options that you can consider when planning to use the Microsoft Office Project Server 2007 Cube Building Service.

Important

OLAP cube creation and processes that occur on the Project Server application server can consume a large portion of the server's resources. . When considering deployment options, refer to Chapter overview: Plan for performance and capacity (Project Server).

Configuration options

There are three components to configure in your cube-building deployment:

• Project Server 2007   The Office Project Server 2007 application server with the Queuing service.

• SQL Server Analysis Services   Any of three versions can be used: SQL Server 2000 Analysis Services with Service Pack 4 (or a subsequent SP), SQL Server 2005 Analysis Services with SP 1 (or a subsequent SP), or SQL Server 2008 Analysis Services.

• Project Server Reporting database   The Project Server Reporting database is one of the four project databases created by Office Project Server 2007. Analysis Services accesses the tables in the Project Server Reporting database to create the Analysis Services cube database with Project cube data. The Project Server Reporting database can exist in either SQL Server 2000, SQL Server 2005, or SQL Server 2008.

Office Project Server 2007 supports using different versions of SQL Server for your database component and for SQL Server Analysis Services. For example, you can use SQL Server 2000 SP4 as your database server, and use SQL Server 2005 SP2 Analysis Services.

One-server configuration

The one-server configuration deploys all three components on the same computer.

This configuration should only be used for a very small company or for a small pilot deployment. This is not recommended for larger companies or for customers who are using many or larger projects.

Two-server configuration

There are two supported two-server configurations.

• The first option deploys the Project Server application server and the Project Server Reporting database on one server. SQL Server Analysis Services is deployed to the second server.

  

• The second option deploys the Project Server application server on the first server. Both the Project Server Reporting database and SQL Server Analysis Services are deployed to the second server.

  

OLAP cube builds and updates can be consume a large share of memory and processor cycles on the server, so both configurations improves performance by moving this functionality off of the Project Server application server.

Three-server configuration

The three-server configuration deploys each component on its own server.

This configuration provides better performance by allowing a dedicated server for each component.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

• Cube Building Service in Office Project Server 2007

See the full list of available books at Downloadable content for Project Server 2007.