AnsweredAssumed Answered

ArcGIS for Server Map Service Load on Database

Question asked by hkoatnswps on Jun 4, 2018
Latest reply on Jun 7, 2018 by hkoatnswps

Hi, we have published a number of map services and they all point to feature classes in a Microsoft SQL Server database. My question is, if the map services are not being consumed by anything (e.g. apps, ArcMap, Portal... etc), would the map services still put any load/work on the database (not ArcGIS Server)? For instance, would the map services continuously to ping the database? The only thing I can see is there is a "Periodically check and repair data connection for idle instances" setting that will ping the database periodically (this setting can be turned off).

 

The map services are all quite simple/standard in that they simply point to the feature classes, some might have query definitions, that's about it (no extra stuff like WMS, feature access capabilities etc).

 

Same goes for the feature classes, they are straight-forward feature classes, nothing fancy like network datasets, domains, versionings... etc.

 

ArcGIS is 10.5 running on Windows 2012 R2; MS SQL is version 2014 SP2.

 

Thanks.

Outcomes