ArcGIS Server Database Connections Suggestion

[KeithConnatser]

Just a thought that I wanted to float out on geonet that might be a potential future release of GIS Server, we have been running into issues quite frequently where as we create more and more services in GIS Server and those services connect to geodatabases like an ArcSDE database of some kind that having a cluster of GIS servers running many different types of services all connecting to the same database in many cases takes up a lot of active DB connections. It would be very nice if there was some way as a part of the register step during publishing the service that this actually created a connection pool that could be leveraged by any and all map services running on that cluster, and you could define parameters on the connection pool for the min and max size, etc of those database connections. This might really help cut down the overhead that creating so many active connections per each service creates, especially when you are running a GIS Server with many services in a clustered environment.

[deleted-user-AYsXjhkrwuAA]

Hi Keith Connatser‌

+1 from me. We frequently run into these problems which seem worse now that we've upgraded server to 10.2 from 9.3 (I don't know why).

We are using direct connect and our Oracle DBA suggested switching the TNS Listener over to SHARED server mode which did help a little but hasn't completely solved the problem.

Now that we have to register the data sources for services it wouldn't be much of a leap to enable options to pool connections, but alas it seems the data sources register is only used when publishing services - as I discovered recently when I had to change the password for a connection.

Andrew