Multiple Project Servers, one SQL server

S

Steve Heller

Can we have multiple Project Server boxes talking to one SQL Server
box? Are there any problems with such a setup? Any hints would be
appreciated.
 
G

Gary L. Chefetz [MVP]

Steve:

It's not a problem, but you'll need to use a custom installation routine on
every project server box that you build beyond the first site. Specifically,
you'll want to create the databases manually.
 
B

Brian K - Project MVP

Steve said:
Can we have multiple Project Server boxes talking to one SQL Server
box? Are there any problems with such a setup? Any hints would be
appreciated.
Click to expand...

One thing to remember is that when sql server response starts to lag
with project server it tends not to be the cpu or memory but rather the
NIC so having several on one SQL box might tax the NIC on the sql box
to the point where adding another sql server may be required.
 
S

Steve Heller

Gary L. Chefetz said:
Steve:

It's not a problem, but you'll need to use a custom installation routine on
every project server box that you build beyond the first site. Specifically,
you'll want to create the databases manually.
Click to expand...

Actually, what I was wondering is whether it would work to have the
multiple Project Server boxes talking to the same database on the same
SQL Server. I take it from your answer that this would not be a good
idea. Am I correct?
 
G

Gary L. Chefetz [MVP]

Steve:

It is possible to build a server farm to support your implementation.
 
Top