ArcGIS Architecture Series: Tools of an Architect

[JacobBoyle412]

The Architecture Practice team in Professional Services is pleased to announce a new series leading up to the Esri User Conference.  We will be highlighting various tools and best practices for ArcGIS Enterprise implementation and tuning.

System design and architecture can some times feel daunting.  As an ArcGIS Enterprise or ArcGIS Server administrator, you may occasionally be faced with decisions for how to best optimize the services within your site for performance, reduce wait-times, and eliminate service down times.

• ArcGIS Server Tuning and Optimization with System Log Parser - Outlines configuring ArcGIS Server for System Log Parser analysis and setting up System Log Parser.
• System Log Parser - Statistics and Service Optimization - Outlines what specific fields to focus on for service optimization and ways to tune services and the underlying data to optimize performance.
• What is eGDB Health - Egdbhealth is a tool for reporting on various characteristics of Enterprise Geodatabases (eGDBes).
• Using Egdbhealth to Evaluate a Geodatabase - This article discusses how to use the outputs of egdbhealth to evaluate the health of an eGDB.
• Using Egdbhealth in System Design - The primary purpose of the tool is to evaluate the “health” of eGDBes.  However, the output can also be used in a system design context.  This article addresses the system design use case. 
• **NEW** Planning Load Balancer Configuration for Highly Available ArcGIS Enterprise - Organizations often require a certain level of system uptime for their ArcGIS Enterprise deployments, such as 99 percent of the time or higher. 

Note: The contents presented above are recommendations that will typically improve performance for many scenarios. However, in some cases, these recommendations may not produce better performance results, in which case, additional performance testing and system configuration modifications may be needed.

Implementing ArcGIS‌ ArcGIS Monitor‌ ArcGIS Enterprise‌ Geodatabase

[MarkChilcott]

Hi David,

In relation to ArcGIS Monitor - does this create stats down to the layer level, or just to the service level?

Cheers,

Mark

[DavidHoy]

Hi Mark,
layer level stats are captured if the client requested at that level rather than at the service level.
So, for requests at layer level for a feature enabled map service, the calls are captured in the server logs.

The other trap is that, because Hosted Services are not serviced by an ArcSOC.exe, they do not get logged in the ArcGIS Server logs.
To get stats for Hosted Services, you need to query the Web Adaptor or Load Balancer/Reverse Proxy logs

[DavidHoy]

and Monitor will show what you configure it to retrieve from the available inputs

[AndreaB_]

Hi all,

I'm using System Log Parser and I'm looking for low use services that I can change to Shared Instances. Documentation says 'for most deployments this is fewer than one service request per minute on average'. So can I find average requests per minute per service in the System Log Parser output? To find values significantly below 1? If it's there I'm overlooking it.

Thank you!

[AndreaB_]

@DannyKrouk  or others, I am using the egdbhealth tool. The perf_StaleDbStats tab continually tells me "Warning: No statistics update information available. Review statistics updating procedures." for several a and D tables.

I have run the ArcGIS Pro tool Analyze Datasets as the data owner on those datasets, checking Base Tables, Delta Tables, and Archive Tables. Our DBA also runs Update Statistics using this script weekly: https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html but neither of those is catching these particular a and D tables.

Any ideas?