Software Performance (CPT Demos) 38th Edition
This section shares lessons learned about selecting and building effective GIS design solutions that satisfy operational performance and scalability needs. Software technology allows us to model our work processes, and provide these models to computers to optimize user workflow performance. The complexity of these models, the functions selected to generate our display, the complexity of the data source, and how application functions are orchestrated to analyze and present information processing needs all have a significant impact on computer system workload and subsequent performance and scalability.
Workflow description is retained in a workflow recipe. Performance factors used to generate the workflow recipe include the following:
- Desktop (ArcMap or Pro)
Proper workflow selection establishes the foundation for a successful system architecture design.
- 1 Software technology category
- 2 Software technology pattern
- 3 Display Graphics selection
- 4 ArcGIS density/portal selection
- 5 Display complexity selection
- 6 ArcGIS percent data cache (%DataCache) selection
- 7 Resolution selection
- 8 Output selection
- 9 Vector storage format selection
- 10 Imagery storage format selection
- 11 Standard workflow selections
- 12 Custom workflow processing loads
- 13 Project Workflow assignment (Custom Workflows)
- 14 CPT Capacity Planning videos
Software technology category
- Selection picks from a list of CPT Calculator software technology categories.
- Selection establishes the software dropdown list selections available in cell E3.
Software technology pattern
- Selection picks from a list of the most common user workflows.
- Selection identifies the software technology pattern.
- Software nickname is included in the workflow recipe.
ArcGIS for Desktop selection
- Selection applies to ArcGIS for Desktop workflows.
- Selection identifies which ArcGIS for Desktop application (ArcMap or Pro) is being used to support the workflow.
ArcGIS imagery selection
- Selection applies to ArcGIS for Desktop imagery workflows and ArcGIS for Server image services.
- Raster Image density must be selected in cell I3 for all Imagery workflows.
- Imagery data format is selected in cell J6. When selecting an Imagery workflow, cell J6 will provide a list of available Imagery data formats.
- Mosaic/Raster dataset metadata search engine host location (FGDB or DBMS) is selected in cell A11.
Display Graphics selection
ArcGIS density/portal selection
- Selection applies to all workflows.
- Raster image should be selected when imagery layer is included in the display.
- JPEG is the default output format for raster image selection.
- PNG24 is the default output format for vector only selection.
- Portal selections should be used for services registered with a Portal for ArcGIS server.
Portal for ArcGIS registered workflows
Portal for ArcGIS provides a collaborative content management system that organizations can deploy in their own infrastructure (on premises or in a private cloud). Portal establishes a common reference location for self-service ArcGIS services management and collaboration throughout the organization.
Portal selections (VPortal and RPortal) identify workflow density for hosted ArcGIS for Server workflows registered with Portal, and these workflows include increased service time on the Web service component for Portal content management processing along with the GIS Server processing loads.
A majority of Portal operations include creating Web Maps and/or adding services to the site, actions which establish registered services with the Portal for ArcGIS site. Portal can also be used for feature data collection and publishing/editing feature services stored in the ArcGIS Data Store. Portal Web Maps that include services from external Internet sources should use the Portal workflow (no internal hosted service loads). Internal registered services should use portal in the Density/Portal selection for creating the portal loads.
Display complexity selection
Workflow complexity directly impacts display performance and system cost. CPT Calculator was used to generate results for an AGS REST 2D V 100%Dyn 13x7 PNG24 workflow supporting 100,000 TPH throughput ArcGIS for Server site deployed on a single tier 4-core Arc16 baseline 4-core servers with a small file geodatabase data source:
- Medium complexity requires two 4-core servers with local response time of 0.22 sec.
- Light complexity requires one 4-core server with a local response time of 0.14 sec.
- Heavy complexity requires two 4-core servers with a local response time of 0.35 sec.
- 3x Medium complexity requires four 4-core servers with a local response time of 0.63 sec.
- 5x Medium complexity requires six 4-core servers with a local response time of 1.11 sec.
- 10x Medium complexity requires twelve 4-core servers with a local response time of 2.4 sec.
ArcGIS percent data cache (%DataCache) selection
- %DataCache selection is included to highlight the advantage of cached map services.
- Selection identifies the percent of dynamic map layers (processing time) that will be pre-processed and included in a map cache when publishing the service.
- MapCache service tiles can be included with the workflow using the +mapcache selection.
- Workflow recipe identifies the percent of dynamic layers (processing time) remaining in the display.
- Includes capability to enter any percentage for Map Cache selection.
- DeskDefault 1920x1080 map size selection.
- WebDefault 1366x768 map size selection.
- 256x256 map cache selection.
- 400x300 very small mobile phone selection.
- 600x400 optimum performance web map size (half HTML page display).
- 1366x768 tablet, rich Internet application large device format.
- 1920x1080 Workstation, high resolution ArcMap client.
- 2560x1600 Very high resolution client.
Custom resolution settings can be entered in cells J3:K3.
- Display traffic is adjusted proportional to the number of pixels in the display.
- Service time is adjusted by 25 percent of the display pixel variation.
- Default JPEG for outputs with raster imagery layer
- JPEG is opaque—suitable for base layer only
- Default PNG24 for vector-only map layers
- PNG supports transparency overlays, good for business layers
- PNG8 compresses best
- PNG32 best color spectrum
- PDF good for local printing
- Feature used for simple editing of business layers
- Minimize feature layers in mash-up to keep traffic loads reasonable.
- Use image layers for basemap and non-edited business layers.
- Feature also used for desktop workflows, high-traffic loads
- ICA used for Citrix WTS terminal client traffic
Vector storage format selection
Selection provides a dropdown list of standard GIS vector data sources.
- DB_DBMS (direct connect to database management system) is the primary baseline workflow selection.
- Versioned enterprise geodatabase is used for maintenance workflows.
- Simple feature enterprise geodatabase for replicated read-only publication database.
- Use DB_DBMS selection for ArcGIS Data Store Portal feature service datasets.
- User DB_DBMS selection for direct connect to supported tabular DBMS systems.
- File geodatabase is good for single-server publication data source.
- Shapefile performance overhead scales with size of data—not recommended for multi-user environments.
Imagery storage format selection
- Imagery data format selection depends on a variety of business factors.
- SDE raster dataset is no longer recommended as the optimum storage format.
- Mosaic dataset provides optimum data management and performance.
- CPT provides preliminary performance expectations for imagery data format selection.
Note: Additional information on imagery management strategies is provided in Lesson 4: GIS data administration.
Standard workflow selections
- Select Workflow tab in cell D30.
- Select desired workflow from cell E30.
Best Practice: Optimum complexity settings generate reasonable system design performance targets.
Warning: Workflow complexity established too high during design will generate inflated hardware and licensing cost estimates.
Workflow complexity established too low during design can increase deployment risk.
Heavy complexity workflows will satisfy most standard web mapping deployment needs.
Custom workflow processing loads
- Software pattern selection: Establishes baseline workflow processing load and display traffic.
- Desktop application selection: Identifies ArcGIS for Desktop application selection.
Additional selection impact on workflow loads
- Display complexity: Adjust map processing loads (Client Wkstn, Citrix, SOC, DS, DBMS).
- Percent data cache (Dynamic): Adjust map processing loads (Client Wkstn, Citrix, SOC, DS, DBMS).
- Display resolution: Adjust traffic and map processing loads (Client Wkstn, Citrix, SOC, DS, DBMS).
- Graphics: Adjust traffic and processing loads for 3D displays.
- Data density/portal: Adjust traffic and processing loads (Client Wkstn, Citrix, SOC, DS, DBMS).
- Output format: Adjust traffic and processing loads (web, SOC).
- +MapCache: Includes average display cached tile downloads in display traffic.
Calculator workflows are copied to the CPT Workflow tab to include in project workflows.
- Standard Workflows are pre-generated from the CPT Calculator and provided on the Workflow tab.
- You can use the Excel Copy/paste values function to include custom workflows in Project Workflow list.
Best Practice: Software technology baseline service time, traffic loads, and relative performance adjustments are derived from test benchmarks.
Project Workflow assignment (Custom Workflows)
The CPT Calculator tab is a primary source for generating workflow performance targets stored on the CPT Workflow tab. Workflow performance targets are generated from a WFBaseline lookup table modified by software technology performance factors configured in the CPT Calculator tab. Workflows configured on the CPT Calculator tab are displayed in the Calculator Workflows section on the Workflow tab. Figure A-3.17 shows how to include a copy of a custom workflow generated by the CPT Calculator tab to your Project Workflow section.
Calculator Workflows identified on the CPT Workflow tab represent the current workflow selection configured on the CPT Calculator tab. The following procedure can be used to select a Calculator Workflow and use the paste special values function to include a copy in your Project Workflow section.
- Select a Project or Standard workflow on the Workflow tab and insert copied cells into your Project Workflow section. This workflow will provide a template for entering the new Calculator Workflow values.
- Select and Copy the blue cells (cells from column A through N in the Calculator Workflow section).
- Select cell in column A of your template workflow, and paste special values (Paste 123) to insert the new Calculator Workflow performance targets.
Warning: DO NOT copy the Calculator Workflow row and insert copied cells as a new row in your Project Workflows. If you do this, the new Project Workflow row will have blue cells and not reference the proper values. Delete the row to recover your Project Workflows and follow proper procedures above.
- Select workflow name in column A and add nickname (WebLite_) followed by an underscore to the new Project Workflow name.
Once you have added the new Custom Workflow to your Project Workflow section, and included a nickname to make the workflow name unique, you are ready to use the new workflow in your CPT Design.
- Chapter 3 video shows how to create custom workflows on the CPT Calculator tab and then move these workflows to your Project Workflow section on the Workflow tab for use in your design.
The next section will take a closer look at ArcGIS Server software performance.