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.?
[GIS] ArCGIS Server 10/10.1 And Sql Server 2008
arcgis-serverperformanceserversql server
Best Answer
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).
Yes, and most architecture diagrams recommend this approach. Take a look at GIS Product Architecture for more information.