Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Is there any compulsion that SQL server 2008 and ArcGIS server 10/10.1 should be installed on same server machine and is it possible to install SQL server 2008 and ArcGis server on separate server machines?If is it possible then what are the complications and performance issue involved in above scenario.?

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

SQL server 2008 and ArcGIS server 10/10.1 should be installed on same server machine

Typically in an enterprise deployment, the answer is no, as both are quite cpu/memory hungry applications and they should not be fighting each other for resources (although you can do some tuning to make sure they don't hog all the resources).

is it possible to install SQL server 2008 and ArcGis server on separate server machines

Yes, and most architecture diagrams recommend this approach. Take a look at GIS Product Architecture for more information.

enter image description here

what are the complications and performance issue involved in above scenario.?

  • Avoid firewalls between the DBMS and ArcGIS Server
  • Ensure both are on LAN and not WAN, to avoid any network latency issues.
  • If your using ArcSDE, by separating it onto separate box can mean additional licensing.
  • A lot more information on System Design Process.
share|improve this answer
add comment

As Simon writes it is possible to install ArcGIS Server and SQL Server on separate servers - and recommended too. But if you are asking about the ArcSDE part of ArcGIS Server you will usually install this on the same server as your DBMS to get schemas and other stuff created ind the DBMS. You do not have to create ArcSDE services if you only wish to use Direct Connect to communicate with ArcSDE. You can actually also install ArcSDE on a separate server and run the ArcSDE services on this, if you want to.

Regards, Steen Kjeldsen Informi GIS Denmark

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.