City of Rome Year 2 (CPT Demos 36th Edition)


 * City of Rome System Architecture Design (Year 2)

This section shares the CPT analysis supporting the City of Rome Year 2 system architecture design. The City of Rome case study brings together what has been discussed in the earlier chapters and demonstrates the value of the system design analysis in making informed design decisions.

Technical architecture strategy: Year 2
Figure 12.29 shows the City of Rome year 2 implementation strategies.

A server-based architecture in the central IT data center will be expanded to support the year 2 implementation. 
 * Server platforms will include a Windows Terminal Server farm to support the remote ArcGIS for Desktop users.
 * ArcGIS for Server to support the public web services.
 * A central GIS data server to support the enterprise geodatabase.

Network suitability analysis: Year 2
Figure 12.31 shows the Year 2 CPT Design workflow configuration. To simplify configuration effort, start with a copy of the Year 1 CPT Design tab (virtual server platform configuration) and add the Year 2 workflows to complete the business needs analysis.

While you configure the user requirements and site locations in the CPT, and update the site traffic summation ranges to include all site workflow traffic going over the network connections (these CPT configuration procedures were discussed in Chapter 6), Excel will complete the network suitability analysis.

Several performance problems are identified in the existing design due to network traffic bottlenecks.
 * Red cells in columns F:G identify traffic bottlenecks.
 * Recommend network upgrades to about twice identified network traffic.

Recommended network upgrades: 
 * Data center LAN from 100 Mbps to 1 Gbps
 * Data center WAN from 24 Mbps to 45 Mbps
 * Site 2 from 3 Mbps to 24 Mbps
 * Data center Internet from 24 Mbps to 135 Mbps
 * Site 5 from 1.5 Mbps to 3 Mbps
 * Site 6 from 1.5 Mbps to 12 Mbps
 * Site 7 from 1.5 Mbps to 6 Mbps
 * Site 8 from 1.5 Mbps to 18 Mbps
 * Site 9 from 1.5 Mbps to 18 Mbps

Figure 12.32 shows the Year 2 network suitability upgrades. Results of the network suitability analysis should be shared with the Network Administrator, and together identify upgrades for the year 2 network infrastructure to support the year 2 design. Recommended network upgrades are included in column H.

The RESET/ADJUST function in Column AF must be reset and returned to SAVE to recalculate batch process productivity for the new configuration.

CPT Design shows network bottlenecks are resolved. 
 * Workflow performance summary shows relative user display performance for each workflow at each site location.

CPT Design analysis for high availability virtual platform configuration: Year 2
Confirm the virtual platform configuration:
 * The Workflow Configuration sheet was copied from the Year 1 virtual server configuration and should have the proper hardware platform configuration set.
 * The decision was made to use the E5-2667v2 16-core host server platform for the higher capacity Year 2 deployment. Once you confirm the proper hardware configuration, Excel completes the system architecture design analysis.

Figure 12.36 shows the virtual server and host platform requirements for the Enterprise HA virtual server configuration.
 * High availability host platform configuration

The RESET/ADJUST function in Column AF must be reset and returned to SAVE to recalculate batch process productivity for the new configuration.

HA virtual server and host platform configuration:
 * Three (3) E5-2667v2 16-core host platforms, 256 GB RAM.
 * Five (5) 4-core WTS Virtual Servers, 47 GB RAM.
 * Two (2) 2-core WebIn Virtual Servers, 6 GB RAM.
 * Two (2) 2-core WebPub Virtual Servers, 6 GB RAM.
 * One (1) 4-core DBMS Virtual Server plus failover, 47 GB RAM.

"Best practice: Host platform configuration must have N+1 servers for high availability."



The decision was made to use the E5-2637v2 8-core server platform. Once you confirm the proper hardware configuration, Excel completes the system architecture design analysis. Figure 12.37 provides a physical Citrix tier hybrid Year 2 solution with the Web Services and DBMS platform tier deployed in a virtual server environment.
 * HA WTS physical servers with Web and DBMS virtual servers

The RESET/ADJUST function in Column AF must be reset and returned to SAVE to recalculate batch process productivity for the new configuration.

HA WTS physical with Web and DBMS virtual server and host platform configuration:
 * Three (3) E5-2637v2 8-core WTS platforms, 98 GB RAM.
 * Two (2) E5-2637v2 8-core Host platforms, 192 GB RAM.
 * Two (2) 2-core WebIn Virtual Servers, 6 GB RAM.
 * Two (2) 2-core WebPub Virtual Servers, 6 GB RAM.
 * One (1) 4-core DBMS Virtual Server plus failover, 49 GB RAM.

"Best practice: WTS Citrix XenApp Physical server configuration provides lower risk deployment strategy." 

CPT Design analysis for data center without hosting public Web services
Copy previous high availability virtual platform configuration — Year 2 solution on separate tab and delete WebPublic peak throughput from column D. Once you remove the WebPublic peak throughput, Excel completes the system architecture design analysis.

City decided to host the City Hall data center virtual servers on lower capacity E5-2637v2 8-core platforms to reduce overall system cost. Once you confirm the proper hardware configuration, Excel completes the system architecture design analysis. 

Figure 12.41 shows the virtual server and host platform requirements for the Enterprise HA City Hall data center virtual server configuration after removing the Web Public service loads. The Web Public services will be deployed on Amazon Web services.
 * High availability host platform configuration

HA WTS physical with Web and DBMS virtual server and host platform configuration:
 * Three (3) E5-2637v2 8-core WTS platforms, 98 GB RAM.
 * Two (2) E5-2637v2 8-core Host platforms, 63 GB RAM.
 * Two (2) 2-core WebIn Virtual Servers, 6 GB RAM.
 * One (1) 4-core DBMS Virtual Server plus failover, 49 GB RAM.

"Best practice: Publishing public services on the Amazon Cloud removes requirements to host these services in your data center environment. " 

CPT Calculator analysis for Amazon Cloud public services configuration
Figure 12.44 shows the CPT Calculator used to compute web public server platform solution. CPT Calculator can be used for completing a single workflow system architecture design sizing analysis.

Enter the Web public peak throughput and data source selections.
 * Peak throughput = 100,000 TPH
 * Select Small FGDB data source (you will use geodatabase replication services to publish data updates to the Amazon machine).

Amazon AMI Platform Selection:
 * Select AMI m3.Large 2-core (6.5 CU) 7.5 GB as the platform selection.

"Best practice: The AMI m3.large 2-core (6.5 CU) 7.5 GB virtual server machine was Amazon’s highest performing 2-core server configuration based on information Amazon shares for AMI instance performance. "


 * Identify a two-tier high-availability configuration.

Amazon Cloud platform solution:
 * Two (2) m3.large 2-core (6.5 CU) 7.5 GB Amazon Machine Instances.
 * Data source: File geodatabase.

Amazon AMI pricing (based on pricing model):
 * Fixed cost for three-year term = $954 per AMI
 * Variable cost of $0.099 per hour for 26,280 hours = $2,602
 * Total cost per server = $3,556
 * Cost for two servers = $7,111

"Best practice: Use ArcGIS for Server Cloud Builder to deploy services on the Amazon EC2 site." 

Workflow loads analysis
Figure 12.48 shows the City of Rome Police Department user needs and CPT Design workflow configuration. The CPT Design analysis is completed on a separate CPT Design tab. The CPT requirements analysis includes all of the police workflows identified during the business needs analysis. An additional batch process was included in the design to reserve core to accommodate one system administration batch process during peak system loads.

The RESET/ADJUST function in Column AF must be reset and returned to SAVE to recalculate batch process productivity for the new configuration.

The CPT Design shows no network bottleneck issues. 

Network suitability analysis
Figure 12.44 shows the Police hardware configuration. Separate single core VMs were established for the system administration batch process (Batch) and the mobile synchronization service (WebMap). The SDE geodatabase would be deployed on a single database server (DBMS).

Police HA Virtual Server platform solution:
 * Host platform: Xeon E5-2637v2 4-core servers.
 * Batch tier: 1-core virtual servers, 80 percent rollover.
 * WebMap tier: 1-core virtual servers, 80 percent rollover.
 * DBMS tier: 2-core virtual servers, 80 percent rollover.

Xeon E5-2637v2 4 core (1 chip) 3500 MHz servers were selected as the host platforms. The E5-2637v2 processor had a SPECrate_int2006 benchmark of 52.8 per core, one of the faster machines available in the 2014 procurement period.

Platform selection: 
 * Client workstation: Intel Core i7-4770 4-core (1 chip) 3400 MHz selected to represent the client workstation environments.
 * Data center server tier: Xeon E5-2637v2 4 core (1 chip) 3500 MHz platform selected for the virtual host server platforms based on highest performing best buy 4-core server configuration.
 * 80 percent rollover selected for all server platform tier.

CPT Design software configuration
Figure 12.50 shows the software and virtual machine configurations. For each workflow, assign software to the appropriate platform tier and select appropriate data source.

Default Row 5 software assignment:
 * Client software set to client
 * Web software set to WebMap
 * SOC software set to WebMap (Mobile synchronization services)
 * SDE software set to Default (Direct connect)
 * DBMS software set to DBMS

Batch workflow software assignment (row 6):
 * Web software set to Batch (batch virtual machine)
 * SOC software set to Batch (batch virtual machine)
 * DBMS software set to Default (Police DBMS geodatabase)

All remaining workflow software assignments set to default platform.

Data source assignment SDE_DBMS for all workflows. 

CPT Design analysis for high availability virtual platform configuration
Once the platforms and workflow software are configured, Excel completes the system architecture design analysis and provides the platform solution. Figure 12.46 shows the CPT Design Police virtual platform solution.

The RESET/ADJUST function in Column AF must be reset and returned to SAVE to recalculate batch process productivity for the new configuration.

HA virtual platform solution: 
 * Two (2) Xeon E5-2637v2 4-core (2 chip) servers, 36 GB RAM for failover configuration
 * Two (2) 1-core Batch virtual servers, 3 GB RAM.
 * Two (2) 1-core WebMap virtual servers, 3 GB RAM.
 * One (1) 2-core DBMS virtual server with failover, 25 GB RAM

Page Footer Specific license terms for this content System Design Strategies 26th edition - An Esri ® Technical Reference  Document • 2009 (final PDF release)